Note: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex is now published.
After many requests from readers, I’ve put together new, revised version of the Oracle 11g on Ubuntu recipe. This new version is a little different than the first one published: it’s based on a bare-bones install of Ubuntu 7.10 (Gutsy Gibbon) server version instead of the desktop version. As an improvement, I’ve tried to pare down dependencies to a minimal set.
Your feedback is more than welcome — it’s the main reason why I wrote a new version of this HOWTO. I’ve also tested and repeated this procedure twice. Even so, it might still have problems, so please let me know so we can improve it 1.
We start with a freshly installed Ubuntu 7.10 server. The only modification made on the base installation was installing an sshd 2 server and a nfs client 3 to use the distribution files on another box in the office. Change 192.168.x.y to the IP address of your new server.
[email protected]:~$ xhost +192.168.x.y 192.168.x.y being added to access control list
After that, almost all we need to do can be done via a single SSH session. This first part must be executed as root, so we execute sudo -s to gain super-user access. After that, we proceed to update our mirrors so we can upgrade the installed base packages:
[email protected]:~# uname -a Linux idlebox 2.6.22-14-server #1 SMP Sun Oct 14 23:34:23 GMT 2007 i686 GNU/Linux [email protected]:~# apt-get update (...) [email protected]:~# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be upgraded: libssl0.9.8 tzdata 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 3479kB of archives. After unpacking 262kB of additional disk space will be used. Do you want to continue [Y/n]?
Afterwards, we install some package dependencies. This is the smallest number of packages I’ve been able to test so far (the first version of this HOWTO required 18 extra packages). Since I had the Ubuntu distribution CD-ROM available, very few packages must be downloaded from the network:
[email protected]:~# apt-get install gcc make binutils libaio1 gawk ksh libc6-dev rpm libmotif3 alien lsb-rpm libtool Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: autotools-dev cpp cpp-4.1 debhelper dpkg-dev gcc-4.1 gcc-4.1-base gettext html2text intltool-debian libbeecrypt6 libice6 libneon25 librpm4 libsm6 libx11-6 libx11-data libxau6 libxdmcp6 libxext6 libxml2 libxmu6 libxp6 libxt6 linux-libc-dev patch po-debconf x11-common Suggested packages: lintian binutils-doc cpp-doc gcc-4.1-locales dh-make debian-keyring gcc-multilib manpages-dev autoconf automake1.9 flex bison gdb gcc-doc gcc-4.1-multilib gcc-4.1-doc cvs gettext-doc glibc-doc libtool-doc automaken g77 fortran77-compiler gcj make-doc diff-doc Recommended packages: libmudflap0-dev libltdl3-dev xml-core libmail-sendmail-perl libcompress-zlib-perl The following NEW packages will be installed: alien autotools-dev binutils cpp cpp-4.1 debhelper dpkg-dev gawk gcc gcc-4.1 gcc-4.1-base gettext html2text intltool-debian ksh libaio1 libbeecrypt6 libc6-dev libice6 libmotif3 libneon25 librpm4 libsm6 libtool libx11-6 libx11-data libxau6 libxdmcp6 libxext6 libxml2 libxmu6 libxp6 libxt6 linux-libc-dev lsb-rpm make patch po-debconf rpm x11-common 0 upgraded, 40 newly installed, 0 to remove and 0 not upgraded. Need to get 5355kB/21.2MB of archives. After unpacking 69.8MB of additional disk space will be used. Do you want to continue [Y/n]?
After the necessary packages are installed, we change the default replacement for sh from dash to bash so we don’t have surprises from scripts depending on bash-like behavior.
[email protected]:~# cd /bin [email protected]:~# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2007-11-04 15:29 /bin/sh -> dash [email protected]:/bin# ln -sf bash /bin/sh [email protected]:/bin# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2007-11-05 10:42 /bin/sh -> bash
We make some modifications to our base system (line numbers added for clarity):
01 [email protected]:~# addgroup oinstall Adding group `oinstall' (GID 1001) ... Done. 02 [email protected]:~# addgroup dba Adding group `dba' (GID 1002) ... Done. 03 [email protected]:~# addgroup nobody Adding group `nobody' (GID 1003) ... Done. 04 [email protected]:~# usermod -g nobody nobody 05 [email protected]:~# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle 06 [email protected]:~# passwd -l oracle Password changed. 07 [email protected]:~# mkdir /home/oracle 08 [email protected]:~# chown -R oracle:dba /home/oracle 09 [email protected]:~# ln -s /usr/bin/awk /bin/awk 10 [email protected]:~# ln -s /usr/bin/rpm /bin/rpm 11 [email protected]:~# ln -s /usr/bin/basename /bin/basename 12 [email protected]:~# mkdir /etc/rc.d 13 [email protected]:~# for i in 0 1 2 3 4 5 6 S ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done 14 [email protected]:~# mkdir -p /u01/app/oracle 15 [email protected]:~# chown -R oracle:dba /u01
- Lines
01-03add the groups we need. - Line
04adapts Ubuntunobodyusers so the Oracle installer doesn’t get confused. - On lines
05-08we create the Oracle user, lock that account so no one can login with it, and create aHOMEdirectory for the user (not the same asORACLE_HOME). - On lines
09-13we create some symlinks so we can fool the Oracle installer. - Finally, on lines
14-15we create ourORACLE_BASEandORACLE_HOME. Alternatively, you can copy/paste this 4.
We also need to change some system-wide defaults. There is some explanation for all these system modifications on the first post on installing Oracle 11g on Ubuntu.
First, add this to the end of your /etc/sysctl.conf. It extends the number of allowed file descriptors, the size of shared memory, and does some tweaking with the network subsystem.
fs.file-max = 65535 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 1024 65535 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144 net.core.wmem_max = 262144
Then, add this at the end of your /etc/security/limits.conf:
oracle soft nproc 2047 oracle hard nproc 16383 oracle soft nofile 1023 oracle hard nofile 65535
Add this to /etc/pam.d/login to enforce what we added to limits.conf:
cat >> /etc/pam.d/login << EOF session required /lib/security/pam_limits.so session required pam_limits.so
(See footnote 5 for an alternative method to performing these last three steps.)
The last thing to do is reload the configuration on /etc/sysctl.conf so the system is affected without a reboot. It’s also a good idea to logout and login again so the limits specified above take place.
[email protected]:~# sysctl -p kernel.printk = 4 4 1 7 kernel.maps_protect = 1 fs.file-max = 65535 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144 net.core.wmem_max = 262144
I’ve made the distribution files available on a NFS mount on /media/database, so we su to the oracle user and start our installation on a remote X server. Please note the -ignoreSysPrereqs flag to the Oracle installer.
[email protected]:~# su - oracle [email protected]:~$ export DISPLAY=Xserver.IPaddress:0.0 [email protected]:~$ cd /media/database/ [email protected]:/media/database$ ./runInstaller -ignoreSysPrereqs Starting Oracle Universal Installer... Checking Temp space: must be greater than 80 MB. Actual 6555 MB Passed Checking swap space: must be greater than 150 MB. Actual 400 MB Passed Checking monitor: must be configured to display at least 256 colors >>> Could not execute /usr/bin/xdpyinfo Failed <<<< >>> Ignoring required pre-requisite failures. Continuing... Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-11-04_09-39-05PM. Please wait ...
The installation should be pretty smooth. If, after some seconds, a window like this one shows up, you’re right on track. Hit Next.
I’ve changed the group to dba before hitting Next:
On this one, I left the defaults and hit Next:
Remember the -ignoreSysPrereqs option? Click on all the checkboxes on the list to change their state from “Failed” or “Warning” to “User Verified” and it will let you hit Next.
In my case, I just installed the software and created a database afterwards with dbca.
Since this is a test box, I modified the groups to be dba:
A quick summary show appear, and it’s time to hit Install:
This will take a while. The first time I run the installer, it took so long I thought it was frozen. Let it run. At some point it will reach the “linking” stage.
Let it run and you’ll be presented with a request to run two scripts as root:
They should output something like this:
[email protected]:~# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory to 770. Changing groupname of /u01/app/oraInventory to dba. The execution of the script is complete [email protected]:~# /u01/app/oracle/product/11.1.0/db_1/root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: (hit enter) Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Finished product-specific root actions.
And finally, the Oracle installer will congratulate you with some good news:
For the final steps of this setup, two more things must be done. First, add this to /etc/profile, so you can run dbca after login in again as the oracle user: 6
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 export PATH=$PATH:/u01/app/oracle/product/11.1.0/db_1/bin
Also, I’ve made some adjustments to the startup script. It should be useful after creating a database and setting it to start on /etc/oratab:
#!/bin/bash
#
# /etc/init.d/oracledb
#
# Run-level Startup script for the Oracle Listener and Instances
# It relies on the information on /etc/oratab
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi
case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbstart"
touch /var/lock/oracle
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"
su $ORACLE_OWNR -c $ORACLE_HOME/bin/dbshut
rm -f /var/lock/oracle
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: `basename $0` start|stop|restart|reload"
exit 1
esac
exit 0
After saving it as /etc/init.d/oracledb and making it owned by root, run this to make it executable:
[email protected]:~# chmod a+x /etc/init.d/oracledb
If you want this script to be run at every boot, execute this:
[email protected]:/bin# update-rc.d oracledb defaults 99 Adding system startup for /etc/init.d/oracledb ... /etc/rc0.d/K99oracledb -> ../init.d/oracledb /etc/rc1.d/K99oracledb -> ../init.d/oracledb /etc/rc6.d/K99oracledb -> ../init.d/oracledb /etc/rc2.d/S99oracledb -> ../init.d/oracledb /etc/rc3.d/S99oracledb -> ../init.d/oracledb /etc/rc4.d/S99oracledb -> ../init.d/oracledb /etc/rc5.d/S99oracledb -> ../init.d/oracledb
It would be a good idea to add yourself to the dba group, by using usermod or by directly editing the /etc/group file. Locate the line starting with dba and add your username after the comma:
dba:x:1002:oracle,pythian
After creating a database and firing it up (either manually or with the script provided), we test our installation:
[email protected]:~$ sqlplus /nolog SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 5 12:23:20 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved. SQL> connect /as sysdba Connected. SQL>
And now we can safely say: we’re done!
Again, please share your thoughts and your experiences with this.
Augusto Bott
So now, dear reader, we hope we have helped you figure out something you needed to know. It turns out that you can help us here at Pythian with something we need to know! If you are aware of a DBA requirement within your organization, salaried or consulting, please pop in your email address here:
We respect your privacy and will not share your address with any third party. As a thank you for just participating, we will enter you into a monthly draw for a year’s membership in the ACM, which includes access to 600 books from the O’Reilly Bookshelf Online, 500 books from Books24x7 and 3000 online courses from SkillSoft, including tons of courseware on Oracle, SQL Server, and MySQL.
1. The method described here should work just fine on Gutsy desktop version since it shares a common base with the server version, so package dependencies for Oracle should be the same on both versions. back
2. The steps regarding X forwarding to another box probably can be skipped if you have a X Server on the server itself. I built this document on a server without a X Server and forwarded the output to my box. back
3. If you are want to copy the distribution files directly to the server and use them from a local filesystem, you can skip the nfs-client installation. You will need the unzip package installed to extract the contents of the download. back
4. Users and groups configuration. Paste this as root:
addgroup oinstall addgroup dba addgroup nobody usermod -g nobody nobody useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle passwd -l oracle mkdir /home/oracle chown -R oracle:dba /home/oracle ln -s /usr/bin/awk /bin/awk ln -s /usr/bin/rpm /bin/rpm ln -s /usr/bin/basename /bin/basename mkdir /etc/rc.d for i in 0 1 2 3 4 5 6 S ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done mkdir -p /u01/app/oracle chown -R oracle:dba /u01
5. Paste this as root:
cat >> /etc/sysctl.conf << EOF fs.file-max = 65535 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 1024 65535 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144 net.core.wmem_max = 262144 EOF cat >> /etc/security/limits.conf << EOF oracle soft nproc 2047 oracle hard nproc 16383 oracle soft nofile 1023 oracle hard nofile 65535 EOF cat >> /etc/pam.d/login << EOF session required /lib/security/pam_limits.so session required pam_limits.so EOF
6. Paste the following, as root:
cat >> /etc/profile << EOF export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 export PATH=$PATH:/u01/app/oracle/product/11.1.0/db_1/bin EOF
114 Comments. Leave new
Hi augusto!
The need for using xhost + on your local box is cumbersome and unneeded. Just use ssh -X to enable X-forwarding. (all X stuff is done automagically that way) Also, it’s good practice to use root as little as possible. So if I would do it, I would logon as oracle, and switch to root temporarily to do the root stuff. (but that is impossible if the users doesn’t already exists ;-)
Personally, I’ve never seen trouble regarding the shell. Are you saying dash is so much different that it causes problems? For some scripts, it relies on ksh, but as far as I know that is handled by a shebang in the scripts (and to be honest, I’ve done installs without ksh (pdksh) installed, and it still worked)
I remember also symlinking the ‘env’ utility, during a preperation of debian etch, but dependencies could vary among oracle versions.
Good work!
@Frits,
Indeed, the ssh -X should work fine. As a personal option, I don’t like the idea of login in to a system directly as the oracle user, so I locked it (allowing explicitly just a few users to execute ‘sudo su – oracle’ would at least let us know which user used that command on the logs). Again, that’s a personal choice (kind’a paranoid, I must admit).
As for the dash substitution, I don’t really know if it really matters on this setup or not (I just didn’t want to take chances with it). Sometime ago I’ve hit some ‘funny errors’ when running installation scripts for some software packages – that’s when I found out that on Ubuntu, /bin/sh is not a symlink to /bin/bash as in many other distributions. As an example I remember that a particular ATI driver installation would inexplicably fail when I tried to install with the symlink to dash.
Anyway – thanks for your feedback!
Congrats for the step-by-step. I followed it and after 2 hours I had a database test under 11g on my ubuntu laptop ( old one but runs well, a lot of work done on Ubuntu 7.10 and Oracle 11g regarding performance)
As I said I’m using Ubuntu 7.10 desktop edition with compiz-fusion and modal/emergent java windows are not displayed ( only grey background ) to solve this, I added the following environment var on the bashrc / bash_profile of the computer users that must deal with java display applications
export AWT_TOOLKIT=MToolkit
This solves the visualization of java desktop apps with compiz-fusion
Best regards and good job ;)
D.
Checking the requirements of the operating system …
Expected score: A enterprise-4,enterprise-5,redhat-4,redhat-5,SuSE-10,asianux-2,asianux-3
Real score: (Operating System Version unknown)
Checking finished. The overall result of this check is: Failed <<<<
Problem: Oracle Database 11g is not certified in the current operating system.
Recommendation: Be sure to install the software on the platform correct.
thank you
@Enrique,
Did you remember to start the installer with the ‘-ignoreSysPrereqs’ command line switch?
Thanks for responding …
Execute the following steps
./runInstaller -ignoreSysPrereqs
The log is as follows
Checking the requirements of the operating system …
Expected score: One of enterprise-4, enterprise-5, redhat-4, redhat-5, SuSE-10, asianux-2, asianux-3
Real score: (Operating System Version unknown)
Checking finished. The overall result of this check is: Judgment <<<<
Problem: Oracle Database 11g is not certified in the current operating system.
Recommendation: Be sure to install the software on the platform correct.
================================================== ======
Testing requirements bundle operating system …
Checking finished. The overall result of this check is not performed <<<<
OUI-18001: The operating system ‘Linux version (Operating System Version unknown)’ is not supported.
Recommendation: Set up packages required before proceeding with the installation.
================================================== ======
Checking kernel parameters
Checking finished. The overall result of this check is not performed <<<<
OUI-18001: The operating system ‘Linux version (Operating System Version unknown)’ is not supported.
Recommendation: Follow the specific instructions of the operating system to upgrade the kernel parameters.
================================================== ======
Checking version of glibc Recommended
Checking finished. The overall result of this check is not performed <<<<
OUI-18001: The operating system ‘Linux version (Operating System Version unknown)’ is not supported.
Recommendation: There can be installed packages that make them are obsolete, in which case, you can pick up correctly with the installation. If not, it is recommended that does not continue. See technical notes on the product version to obtain the missing packages and upgrade the system.
================================================== ======
I do not have much knowledge of English but you can send your email screens with the steps made
Thanks in advance
Enrique
LIMA – PERU
Yes; type
./runInstaller -ignoreSysPrereqs
Checking the requirements of the operating system …
Expected score: One of enterprise-4, enterprise-5, redhat-4, redhat-5, SuSE-10, asianux-2, asianux-3
Real score: (Operating System Version unknown)
Checking finished. The overall result of this check is: Judgment <<<<
Problem: Oracle Database 11g is not certified in the current operating system.
Recommendation: Be sure to install the software on the platform correct.
================================================== ======
Testing requirements bundle operating system …
Checking finished. The overall result of this check is not performed <<<<
OUI-18001: The operating system ‘Linux version (Operating System Version unknown)’ is not supported.
Recommendation: Set up packages required before proceeding with the installation.
================================================== ======
Checking kernel parameters
Checking finished. The overall result of this check is not performed <<<<
OUI-18001: The operating system ‘Linux version (Operating System Version unknown)’ is not supported.
Recommendation: Follow the specific instructions of the operating system to upgrade the kernel parameters.
================================================== ======
Checking version of glibc Recommended
Checking finished. The overall result of this check is not performed <<<<
OUI-18001: The operating system ‘Linux version (Operating System Version unknown)’ is not supported.
Recommendation: There can be installed packages that make them are obsolete, in which case, you can pick up correctly with the installation. If not, it is recommended that does not continue. See technical notes on the product version to obtain the missing packages and upgrade the system.
Thanks
¿?
kike
Thank you friend, I came all right but you want to add export ORACLE_SID = orcl
Orcl where is the name of the database
Doing that I am glad I ran Linux is more than a feeling …
Kike
Hi,
I am getting the following error while trying to start the runInstaller for Oracle Clusterware
./runInstaller
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 4057 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4064 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-01-10_04-36-54PM. Please wait …sh: /home/oracle/crs_install/clusterware/install/unzip: No such file or directory
I am not sure what is causing this error. Please give me some pointers on how I can fix it.
I fixed the error by renaming the unzip under the clusterware install directory to unzip1 and then making a symlink from /home/oracle/crs_install/clusterware/install/unzip to /usr/bin/unzip.
That’s good news, Sara!
Thought this information might be useful to someone out there trying to install Oracle 11g Clusterware on Ubuntu 7.10 Gutsy (kernel 2.6.22) and use ocfs2 as the filesystem for the cluster files.
The ocfs2 version that gets shipped with Ubuntu 7.10 Gutsy is the mainline version 1.3.3. This version does not support mount option with “datavolume” which is required for cluster files OCR and Voting Disk.
On further research, we found that OCFS2 1.2 does not build with kernels 2.6.20 or later. And if you want to use the datavolume option, you need to get OCFS2 1.2.
The last kernel version that supports OCFS2 1.2 is 2.6.19.
We are going to try the Clusterware Installation again after we get 2.6.19 kernel compiled. I will post here if we do a successful installation.
We were unable to get the CRS installation to work although we got ocfs2 1.2.7 installed and compiled with kernel 2.6.18.1. The installer was very slow and seemed to hang after few hours. There were some random CPU soft lockup issues with that kernel version.
We have decided to try Oracle’s Enterprise Linux(iSCSI/ VM) in place of Ubuntu(AoE/ VM). But we would still like to know if someone has been able to do a successful installation of Oracle 11g RAC on Ubuntu / AoE/ VM configuration. We chose Ubuntu as we were using AoE. Does anyone know if Oracle’s Enterprise Linux supports AoE?
Any advice/suggestions would be really helpful.
Thanks.
Hi
I’m trying this installation by directly login to the server in GNOME – but I get this error
Where I have gone wrong?
./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-02-01_11-01-52AM. Please wait …[email protected]:/storage/orc/database$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Can’t connect to X11 window server using ‘Xserver.IPaddress:192.168.1.23’ as the value of the DISPLAY variable.
Xserver.IPaddress:192.168.1.23
Xserver.IPaddress:192.168.1.23
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to X11 window server using ‘Xserver.IPaddress:192.168.1.23’ as the value of the DISPLAY variable. The DISPLAY environment variable should be set to :, where the is usually ‘0.0’.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
– For csh: % setenv DISPLAY 192.168.1.128:0.0
– For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY
– Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as ‘xclock’:
%
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for ‘xclock’: ‘/usr/X11R6/bin/xclock’
you should use killall gdm first
then restart gdm using startx
and run it again
[…] of this post, but assuming you’ve already installed Oracle 11g accordingly to Augusto’s Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon) and you’ve setup the PATH, ORACLE_HOME and ORACLE_BASE variables, you can do everything in […]
Doesn’t works with Gutsy Desktop.
It sends ERROR:ORA-12162: TNS:net service name is incorrectly specified
when you try:
SQL> connect /as sysdba
AND WHEN TRYING TO START SERVICE IT SENDS:
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
HOWEVER TELNET TO 1521 CONNECTS
Hi ,
I installed oracle 10g on ubuntu 7.10, the installation was smooth, but the listener and http service was not running.
I checked the status using the command in the installation guide, and discovered that the listener was not up.
What do I do next?
Hi i’m trying installation instruction but there are some errors as below when i used ./runInstaller -ignoreSysPrereqs , how i can solve this solution ?
[email protected]:/media/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 80 MB. Actual 19222 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2014 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-03-04_10-36-38AM. Please wait …[email protected]:/media/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
Can’t connect to X11 window server using ‘192.168.0.116:0.0’ as the value of the DISPLAY variable.
192.168.0.116:0.0
192.168.0.116:0.0
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to X11 window server using ‘192.168.0.116:0.0’ as the value of the DISPLAY variable. The DISPLAY environment variable should be set to :, where the is usually ‘0.0’.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
– For csh: % setenv DISPLAY 192.168.1.128:0.0
– For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY
– Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as ‘xclock’:
%
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for ‘xclock’: ‘/usr/X11R6/bin/xclock’
[…] Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon) (tags: oracleinstall) […]
For those of you that are installing locally running X and are receiving “Can’t connect to X11 window server using ‘192.168.0.116:0.0′ as….” just login in as normal (X) but with the user oracle and run ./runInstaller -ignoreSysPrereqs
Cheers
Followed all the steps. Tried to run the installer and got this error:
[email protected]: ./runInstaller -ignoreSysPrereqs
-su: ./runInstaller: /bin/sh: bad interpreter: Permission denied
I’m a Linux novice and have limited knowledge of the OS.
What is needed to resolve this issue?
Thanks…
my error is about RPM
rpm : ToInstall rpm packages on Debian Systems, use alien.
error: cannot open Packages index using db3
error : cannot open Packages database in /var/lib/rpm
And after 88% of process in Installing the oracle…it STUCK FOREVER
Help Please
Thanks
Andriyana Tresnawan
Phone: +6285920511972
for those of you who got DISPLAY or X Problem like what Abu Staif got. The solution is extremely simple:
1. login to kubuntu/ubuntu as your usually user.
2. go to the extracted directory of your oracle
3. type xhost +
that’s it…
Andriyana Tresnawan
INDONESIA
+62859 2052 1972
@Beefeater
I am trying to follow these steps running in Parallels Desktop on a Mac. I am having problems with connecting to the X11 window server.
1) I’m not sure what IP address I should have listed
2) I can’t figure out how to log in as user oracle.
The only way I have been able to log in as oracle is by going root and then using the command ‘su – oracle’. As oracle in that case, I am getting the error.
Are there any other things that I should do differently if installing locally? I’m considering scrapping this VM and starting over without the setup listed here, though I’m not sure that I will be any more successful doing that.
Thanks for your help.
@Andriyana
“I am trying to follow these steps running in Parallels Desktop on a Mac.”
What should have for a DISPLAY value considering my situation?
I figured it out. I had to unlock user oracle. Then I was able to login normally as Beefeater said.
Installing now, we’ll see how it goes. I’m going to be brave and install software only and try to follow the steps to set up the dbase.
Thanks for the support.
@ Luke
Great Job…
@all,
I’m stuck on the process of installing Oracle 11g at 91%. It takes so long (up to 7 hours before I turn it off my laptop)…The Oracle trying to recognize the OS Group for ASM, OPRSYS and (something else I’ve forget). When I put the group ADM, or DBA or ROOT…It just stuck. My God, it only 9% left from process of recognizing turn to process of Installing. What’s wrong with it? Tell me what should I do?
Andri
INDONESIA
+6285920521972
Hi there
i have a problem with running the OUI
when i type in “./runInstaller -ignoreSysPrereqs” this Error is shown
[email protected]:~/linux.x64_11gR1_database/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 206979 MB Passed
Checking swap space: must be greater than 150 MB. Actual 9703 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-03-18_02-29-16PM. Please wait …sh: /home/oracle/linux.x64_11gR1_database/database/install/unzip: No such file or directory
found a possible answer to this problem: https://www.dbforums.com/showthread.php?t=1624849
but that didn’t helped me :(
does somebody know the answer? would be great, thanks
k, managed to install oracle but when i run
/etc/init.d/oracledb start
i got the same error-message as Cisse
the following:
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
tried to google for it but didn’t find any usefull help until yet :(
First of all I would like to thank you for this great step by step tutorial / howto on getting Oracle installed on an Ubuntu box.
I tried following the 7.04-guide yesterday, but with mixed luck. I was happy that it worked out initialy, but after the reboot, it would not start.
With the 7.10 i dont even think I have had that much luck. I am getting the same errors as Cisse and VT. Running the “/etc/init.d/oracledb start” returns;
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
Connecting to the database using SQL*Plus will return the following;
ERROR:ORA-12162: TNS:net service name is incorrectly specified
After running a Google search on the last one, i found a hint running “ORACLE_SID=asdb; export ORACLE_SID”. This will allow me to somewhat log in using SQL*Plus, but returns the message “Connected to an idle instance.”
I realy hope someone can post a hint in the right directions, since im not the only one with the problem :) And to be honest, I dont want to go back to Windows running Oracle :)
Also I am wondering on why the screens in this howto differs from the 7.04 howto ?
I’m new to Ubuntu, but after following the instructions above (right before the Oracle installer) I can no longer login locally to the server. It’s Ubuntu 7.10 Server running on VMware server. However I can still login as the same user remotely with SSH and Putty. Did anything modify the local login rights?
@rune
I have an answer for the “LISTNER not set”-problem
https://blog.vpire.com/?p=237
https://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php
But i can’t log onto the Enterprise Manager DB Control
i checked my portlist.ini (under *oracle_home*/install/portlist.ini) and thats the output:
Ultra Search HTTP port number =5620
seems strange for me..
let’s say my local ip is 192.168.1.135, shouldn’t https://192.168.1.135:1158/em/ let me access the control panel? i tried it, no luck. I also tried other ports like the one in the portlist, but without an effort. will keep googling, but maybe somebody knows the answer already and can help me :D
thanks
Hello,
I had an initial problem of failing to connect to X11-Server. Later, I saw the post below –
“For those of you that are installing locally running X and are receiving “Can’t connect to X11 window server using ‘192.168.0.116:0.0′ as….†just login in as normal (X) but with the user oracle and run ./runInstaller -ignoreSysPrereqs”
Which I followed and it worked but when I got to step 2 (Specify Inventory directory and credentials) I had a problem which says – OUI-10036:Could not create the inventory location. You may not have permission to write to this location.
Please can someone help me out of this problem.
Thanks
hi
get it to work now!
but..
when i restart my computer and i run the script, just the LISTENER is up,
Database Instance and Agent Connection to Instance are down.
I run “etc/init.d/oracledb”, but it didn’t help.
I know that i can start the database through the web browser but i want to start it from the script :(
Hi VT
To answer your preveous post first;
I found the answer getting the listner up myselfe. Even though the solution and result is somewhat the same, it differs from where you put it. My solution was to alter two lines in /etc/init.d/oracledb from
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/db(start|shut)”
into
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/db(start|shut) $ORACLE_HOME”
Also, i am not quite sure if https://127.0.0.1:1158/em/ would open the control panel, doesnt it use the https-protocol? Dont know if it matter, but i seem to rememer ive had one problem with it before?!
To answer your second post: how did you get it up? Any good clues is appreciated!
Finaly put the Linux HDD into my laptop again, and what do you know? Had Oracle-XE installed on it :) Copied the Oracle 11g installer to this computer, so ill see what ill be doing later tonight. Wondering if its worth a try getting it up and running here.
@Rune,
When connected to an idle instance, you can start it up.
But after running “sudo /etc/init.d/oracledb start”, exporting the SID “export ORACLE_SID=MY_SID”, I was able to connect:
$ sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 – Production on Wed Mar 19 17:38:39 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL>
SQL> select sysdate from dual;
SYSDATE
——–
19/03/08
SQL>
Maybe you forgot to start it up?
But I too get
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
And I’d like to know how that can go :)
Thanks, Augusto Bott, for an amazing how-to.
> idkline Says:
> Followed all the steps. Tried to run the installer and got this error:
>
> [email protected]: ./runInstaller -ignoreSysPrereqs
> -su: ./runInstaller: /bin/sh: bad interpreter: Permission denied
I got the same error when I tried to run off of the CD. I got it to work when I copied the CD contents to a temp directory on the local disk.
@Leonardo
How can i start up the idle instance? And I have a feeling the database is set up with no database what so ever?! At least i dont think there is a SID associated with the database.
Also tried the select sysdate from dual, but my reply wasnt as uplifting as yours:
select sysdate from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
As for your “ORACLE_HOME_LISTNER is not SET” you can try mine, or VT’s approach listed above. :)
Hello Beefeater,
Please can you explain what you meant by, I quote “For those of you that are installing locally running X and are receiving “Can’t connect to X11 window server using ‘192.168.0.116:0.0′ as….†just login in as normal (X) but with the user oracle and run ./runInstaller -ignoreSysPrereqs”
I want to install locally and I am having problem in understanding what you meant by “just login in as normal (X) but with the user oracle”
Thanks
@Luke
Please can you explain how you unlocked the user oracle?
Thanks
@Rune,
Did you create a database? This tutorial DIDN’T create anything, it mentions “After creating a database and firing it up (either manually or with the script provided)”.
If you didn’t create, create one running “sudo su – oracle” and “dbca”. There you set up everything for a database, including SID, files, admin password and such.
Then I created the script mentioned (/etc/init.d/oracledb) and ran “/etc/init.d/oracledb start”
Then, “export ORACLE_SID=MY_SID; sqlplus” got me in to a started instance (it says only “connected”).
To startup an idle instance, just type “startup” after the message “connected to an idle instance” (when logged in as sys as sysdba, or someone with admin privileges ;)
And your solution for my problem was VERY nice ;) Thanks. I hope now my advice runs well with you!
Best regards,
Leonardo.
@Leonardo
I tried creating the database with the dbca-tool last night. However, i was using the wrong user account to do it. That kept me going with quite a few problems last night, and gave me a few problemes now due to directories created with wrong permissions. However, your solution fixed the problem.
On the other side, the webbased controlpanel did not fire up again after rebooting, so i guess there is a little fine tuning left in my case. Anyway, thanks for your help, and im glad my solution could help you as well :)
@Jonathan
If I understand your problem correctly, try typing;
xhost local:oracle
sudo su – oracle
export DISPLAY=:0.0
./runInstaller -ignorePreReqs
Dont know if you need to add “export DISPLAY=:0.0”, but the solution worked for me. If you still get that you cant connect to the XServer, try adding your IP before :0.0
I found the answer for starting up Oracle Enterprise Manager
sudo su – oracle
export ORACLE_SID=MY_SID
emctl start dbconsole
If someone can tell me how to get it started by default that answer would be appreciated, if not this solution will do ;)
after following the steps, i got an error! I’ve tried modifying the tnsnames,ora and listener.ora but still the error occur.
[email protected]:/etc$ sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 – Production on Mon Mar 24 12:23:26 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SQL>
Brilliant howto – I’ve tried lots of oracle/debian ones before but this one actually works.
BTW, if you call disable on the oracle-xe init script and try to later shutdown, it will silently fail. You must re-enable then shutdown. This was biting for a bit until I traced through the init script. I don’t ever recall disabling oracle, but…
Guys can you post the links or upload to rapidshare the version of oracle installer that you’ve tried. I think it will work with the old universal installer. I’m newbie to oracle.
Keep up the good work!
Hello,
Thanks to the author of this marvelous “how to” and all other guys who offered their ideas. I was able to install Oracle 11g after using Oracle-xe for some time.
Although I was able to install 11g and use it, I can not still access the dbconsole. I tried:
http//localhost:5500.em
but it does not work. I tried as well:
sudo su – oracle
export ORACLE_SID=MY_SID
emctl start dbconsole
which also failed. Can someone give me some ideas on how to solve the problem.
I will be quite grateful.
Thanks.
The /etc/init.d/oracledb script provided above did not work for me. Oracle did not start properly. I made the following changes, and then it worked for me.
#!/bin/bash
#
# /etc/init.d/oracledb
#
# Run-level Startup script for the Oracle Listener and Instances
# It relies on the information on /etc/oratab
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo “Oracle startup: cannot start”
exit 1
fi
case “$1” in
start)
# Oracle listener and instance startup
echo -n “Starting Oracle: ”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/lsnrctl start LISTENER”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/dbstart $ORACLE_HOME”
su $ORACLE_OWNR -c “echo startup | $ORACLE_HOME/bin/sqlplus / as sysdba”
touch /var/lock/oracle
echo “OK”
;;
stop)
# Oracle listener and instance shutdown
echo -n “Shutdown Oracle: ”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/lsnrctl stop”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/dbshut $ORACLE_HOME”
rm -f /var/lock/oracle
echo “OK”
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo “Usage: `basename $0` start|stop|restart|reload”
exit 1
esac
exit 0
ok. I have screwed something up big style. Having followed the steps at the start regarding users I can no longer login to the sever directly (login incorrect). I can still get in via SSH.
Any Idead?
TM i just experienced the same thing. What i did was to i put ‘#’ to cat >> /etc/pam.d/login << EOF and the rest of the two lines.
The install does not work,
as it hangs on ./runInstaller -ignoreSysPrereqs
at the part on ignoring the 256 colors issue
Hi,
when I create a database using dbca command and then start it with the provided script, I can connect to the database.
When I restart the system and run the script, it looks ok. But when I try to connect to the database I get:
-ORA-12505, TNS listener does not currently know of SID given in connect descriptor (when connecting with Sql developer)
-ORA-27101:shared memory realm does not exsist
Any ideas?
Hi I also had problems with running the installer.
After following the steps outlined I could not run the installer with the oracle user account. The account could not connect to the xserver so I did this.
1) Install sux
2) sux – oracle
sux setup the authorization certificate for the oracle user to access the xserver
tested by running “xclock” in the console and boom it appeared.
[…] https://www.pythian.com/blogs/654/installing-oracle-11g-on-ubuntu-linux-710-gutsy-gibbon […]
Thanks for this very good checklist.
Ubuntu makes an interesting test environment.
Regards,
Alejandro
thanks Augusto and others… Oracle11g up and running on ubuntu now. cheers!
Hey. did all of the steps fine, until i got to this bit “I’ve made the distribution files available on a NFS mount on /media/database, so we su to the oracle user and start our installation on a remote X server. Please note the -ignoreSysPrereqs flag to the Oracle installer.”
How did you create an ‘NFS Mount’. I did this bit [email protected]:~$ cd /media/database/
and my shell said that there is ‘No such file or directory’. I assumed it was the database directory that does not exist because the ‘media’ directory does exist.
Can you help please?
Thanks
@ Maleek
I’ve created a NFS server on another machine, started the RPC daemons on the database machine (nfs-common) and mounted. The specifics of this procedure are beyond the scope of this howto…
Anyway, a new version of this post is on the works, using Ubuntu 8.04 (Hardy Heron) and no NFS at all, so… keep tuned.
/media/database$ ./runInstaller -ignoreSysPrereqs
I ran the above command, but with my own path and i got the below error.
./runInstaller: line 86/home/maleek/…../install/.oui: No such file or directory
It seems when i tried to run the installer, it tried to search the .oui file in the /install/ directory. Can anyone help please?
Thanks
@Jonathan Jide
try https://YOUR_HOST:1158/em/console/aboutApplication instead of http//localhost:5500.em after you have started it with
> sudo su – oracle
> export ORACLE_SID=MY_SID
> emctl start dbconsole
That is, unless it is to autostart ;)
Also…. please notice that you are using the HTTPS protocol, not the HTTP. Trying http://your_host:1158/em/blablabla will not work, since in my experience, Oracle EM does not redirect you to the correct protocol.
After:
[email protected]:~/oracle/database$ ./runInstaller
I got this message:
Préparation du lancement d’Oracle Universal Installer à partir de /tmp/OraInstall2008-04-30_07-01-35PM. Veuillez patienter…sh: /home/chau/oracle/database/install/unzip: not found
Please help.
@CHAU,
Please notice footnote #3 (click here). It looks like you don’t have the
unzippackage installed.@Bott,
Thank for your response.
1) I install the “unzip” package. It exists already, as the Terminal replies:
———————
[email protected]:/home/chau/database# apt-get install unzip
Reading package lists… Done
Building dependency tree
Reading state information… Done
unzip is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
———————
2) I check if oracle_database unzipped: yes. Here is its content:
———————
[email protected]:/home/chau/database# ls -l
total 28
drwxrwxr-x 11 oracle_database oinstall 4096 2007-10-16 19:07 doc
drwxrwxr-x 5 oracle_database oinstall 4096 2007-10-16 16:57 install
drwxrwxr-x 2 oracle_database oinstall 4096 2007-10-16 16:57 response
-rwxr-xr-x 1 oracle_database oinstall 3226 2007-10-16 16:57 runInstaller
drwxrwxr-x 14 oracle_database oinstall 4096 2007-10-16 17:00 stage
-rw-r–r– 1 oracle_database oinstall 4835 2007-10-16 19:07 welcome.html
[email protected]:/home/chau/database#
———————
Please help.
@Chau,
In this case, I’d strongly advise you to double-check your installation sources (perhaps download it again and verify the MD5?) as it should be a
unzipbinary on the package:[email protected]:~/database $ ls -l install/unzip
-rwxr-xr-x 1 pythian dba 102612 2007-08-03 13:28 install/unzip
1)
[email protected]:~$ pwd
/home/chau
[email protected]:~$ ls -l install/unzip
ls: cannot access install/unzip: No such file or directory
[email protected]:~$
2) new download oracle 11g is underway, check MD5 after.
[…] our last post about installing Oracle 11g on Ubuntu 7.10 (November, 6th), and considering Ubuntu 8.04 LTS was released on April 21st, I spent some time […]
[…] trust myself to remember « FET – Open Source TimetablingInstalling Oracle on Ubuntuhttps://www.pythian.com/blogs/654/installing-oracle-on-ubuntu-linux-710-gutsy-gibbon Published in:Uncategorized |on May 17th, 2008 |You can leave a response, or trackback from your […]
On the section that goes like this
cat >> /etc/pam.d/login << EOF
session required /lib/security/pam_limits.so
session required pam_limits.so
You are missing the trailing EOF
to finish the heredoc
George P. Milliken
Great guide. I am getting stuck at the point where the database is linking where it throws up an error ” Error invoking target `all_no_orcl` of makefile.
The log seems to indicate that the following is causing to to stop:
/usr/bin/ld: cannot find -lagtsh
collect2:
ld returned 1 exit status
Has anyone come across this before? Any ideas?
Z
Regarding
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
I read elsewhere that recent kernels (2.6.17+) are autotuning.
Check
cat /proc/sys/net/ipv4/tcp_moderate_rcvbuf
Regardin ephemeral ports Id start at 10000 to avoid the classic non-root server ports (8080 etc) May not matter…
Thanks for the guide though :)
@Maleek
I got the .oui problem when I tried to reinstall Oracle against a 64-bit OS. So, check your Oracle install file and see if it matches your OS.
I couldn’t get Ubuntu 7.10 LiveCD Desktop X to accept incoming connections. I traced the problem to /usr/bin/X :0 -br -audit 0 -auth /var/lib/gdm/:0.Xauth -nolisten tcp vt7
That -nolisten tcp must be the culprit.
What I did was start a new X in another display, without access control (in order to make it easier) with sudo X -ac :1.0 &
That way, I could use export DISPLAY=192.168.x.y:1:0 and CTRL+ALT+F9 to see the OUI window.
@Zahid
I found the same error with Gutsy x64 installation. There are some solutions over the net (search for 11g gutsy), but I found it too much already. I’m going back to 32b for Oracle.
@Sara you can bypass the need for the “datavolume” mount options under ocfs2 by using raw devices (no filesystem) for the OCR and Voting disks. Taking this approach I’ve gotten much closer to running Clusterware on Ubuntu 8.04.1 LTS.
I’m still dealing with the final stages of the installation as the final script run as root tries to do several things “for you” that fail since Ubuntu doesn’t have an /etc/inittab and /etc/rc.d/rcX.d among other bits.
@Jamin,
On the first stages, there’s a step to create a few symlinks to emulate the Redhat /etc layout:
for i in 0 1 2 3 4 5 6 S ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done. As far as I could investigate, the Oracle installer doesn’t need to touch /etc/inittab.Cheers!
@Bott
Thx for the comprehensive guidance …
cheers ..
it’s running smoothly on ubuntu dekstop
if we want to install on ubuntu server (System which doesn’t have Xserver installed) ,and get the error
about installation failure caused by glibc,
just comment out glibc requirement on stage/prereq/db/refhost.xml (will not executed).
to emulate red hat system, we can do
touch /etc/redhat-release
chmod 666 /etc/redhat-release
echo “Red Hat Linux release 4.0” > /etc/redhat-release
ln -s /etc /etc/rc.d
Regards,
I am not sure what is causing this error. Please give me some pointers on how I can fix it.
———————————————-
[email protected]:/home/jubuntu/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 80 MB. Actual 46497 MB Passed
Checking swap space: 0 MB available, 150 MB required. Failed <<<>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-08-01_03-38-33PM. Please wait …[email protected]:/home/jubuntu/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
No protocol specified
Can’t connect to X11 window server using ‘:0.0’ as the value of the DISPLAY variable.
:0.0
:0.0
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to X11 window server using ‘:0.0’ as the value of the DISPLAY variable. The DISPLAY environment variable should be set to :, where the is usually ‘0.0’.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
– For csh: % setenv DISPLAY 192.168.1.128:0.0
– For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY
– Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as ‘xclock’:
%
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for ‘xclock’: ‘/usr/X11R6/bin/xclock’
@joey,
Please remember to export the
DISPLAYvariable (one command line before runningrunInstaller.Cheers!
[…] bit Ubuntu 8.04.1 Server JEOS and Oracle 10g. Much of the work was taken from Augusto Bott’s Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon) and Peter Cooper’s How to Install VMware Tools on Ubuntu Hardy 8.04 under VMware […]
what about a next episode on configuring lamp with oracle. Would be really coool. Anyway|! U’ve done good stuff man! Tx a lot!
thank you for your tutorial very much.
Excellent Tutorial, it made things look easy.
Thanks again.
Thanks. With this tutorial the installation went smoothly.
When installation completed I realized I want to add Enterprise Manager Database Control however when I run OUI and click the “Installed Products” button the Inventory window opens but remains empty (the list of installed products does not appear, instead I see an empty inventory window).
Is this a known bug for Oracle on Ubuntu? Is there a workaround to add\remove products from the Oracle inventory?
@coren,
Please double check the location and permissions of the inventory directory you’re trying to use (right after you fire up
OUI).Cheers!
I tried executing the command “chmod -R o+rwx oraInventory” from root and then start OUI but the problem persists. I’m not sure I understand the part about the location of the inventory directory or the “right after firing OUI”.
Thanks again
@Coren,
Executing
chmod -R o+rwxwon’t do any good as what’s important in this stage is theuserandgroup. Please make sure you selected the proper values here.Cheers!
Dear there, I followed your steps, and stuck at DISPLAY Setting. I am setting up 11g on my T60p running Ubuntu 8.04 – the Hardy Heron. Since I don’t connect to any server, I set the DISPLAY=:0.0 However it didn’t work out. Please give me a hint, thanks.
=============================================================
[email protected]: su
root&sychen: su – oracle
Your account has expired; please contact your system administrator
su: User account has expired
(Ignored)
[email protected]:~$ cd /DATA/database
[email protected]:/DATA/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 80 MB. Actual 1138 MB Passed
Checking swap space: must be greater than 150 MB. Actual 988 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-11-28_10-59-33PM. Please wait …[email protected]:/DATA/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
No protocol specified
Can’t connect to X11 window server using ‘:0.0’ as the value of the DISPLAY variable.
:0.0
:0.0
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to X11 window server using ‘:0.0’ as the value of the DISPLAY variable.
…….
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as ‘xclock’:
%
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for ‘xclock’: ‘/usr/X11R6/bin/xclock’
[email protected]:/DATA/database$ xclock
No protocol specified
Error: Can’t open display: :0.0
[email protected]:/DATA/database$ exit
logout
[email protected]:/home/sychen# xclock
Warning: Tried to connect to session manager, Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed
[email protected]:/home/sychen# exit
exit
[email protected]:~$ xclock
[email protected]:~$ echo $DISPLAY
:0.0
========================================================
it is strange that as a common user “sychen” I can run xclock directly even without DISPLAY variable; as the root , I run the xclock and can see the clock, but got the warning msg; as “oracle”, I can not connect to xserver.
Thanks for the detailed help! To install ORACLE on your own machine, you just follow the steps in this article except that you log out after you created the user oracle. Then login in as the user “oracle” and pick the rest steps. Other things I tried and didn’t work is to play with 127.0.0.1, localhost or :0, xhost and so on.
dbca trouble. After successfully installed Oracle 11g, I went ahead to create the first database using dbca. however at the last step, it complains that libaio is not installed, and it can not execute the sqlplus. I did install the libaio1 however, and as a matter of fact, I can run sqlplus at terminal. So what could be the problem?
@Michael,
Have you created a database successfully before trying to start it up or connect to it with
sqlplus? DBCA will not be able to create the database withoutlibaio.Cheers!
Hi,
I installed Oracle 10g release 2 following this tutorial. I later went on to run dbca. After getting to the last step, it throws an error that it cannot create a directory which it named ‘/home/danielgeorge/admin/daniel/adump’. The database is to be named ‘daniel’. Please what should I do?
Thank you.
@Ehidiamen,
Please double-check permissions (users and groups as well) as the directory must be writeable by the
oracleuser (or by the user you run the database as).Cheers!
Regarding Michael’s comment from November 29, 2008 @ 10:48 am,, I was able to run the Oracle installer by logging in as user “oracle”. However, the first step of the install hangs at 44%. I’m trying to decipher the install log. This reply is a thank you to Michael. Any ideas about the hanging? I will let you know when I find the solution.
Oracle 10gR2 on Ubuntu 8.10 server Intrepid Ibex.
Gurus,
I installed the software separately. I started dbca and filled in all the details without any problem. But nothing happens after I press OK on the confirmation page. I could see that it started SQL*Plus in silent mode and also created directory for database files but nothing after that. It’s been 2 hrs and I’m still waiting for an error of some kind.
Appreciate leads and pointers.
Thanks
All those people having the ‘X11 window server’ error, run the below command(as oracle user) and try execute runInstaller again:
export DISPLAY=:0
Connect using sqlplus solved!
sqlplus “sys/[email protected] as sysdba”
This worked like a charm. Thank you!
Can you make another article explaining how to install on Ubuntu Server 8.04 LTS 64 bit.
I had some problems with the package requirements, especially with compat-libstdc++.
“Error on invoking target all_no_orcl’of makefile.”
Hi.
I am unable to start oracle setup istead of appearence of the installation window error msg appers……it the following steps..and error msg is also below….plz help me out….
this is the main problem i think.
Can’t connect to X11 window server using ‘Xserver.IPaddress:0.0’ as the value of the DISPLAY variable.
[email protected]:~/database$ cd
[email protected]:~$ export DISPLAY=Xserver.IPaddress:0.0
[email protected]:~$ ls -l
total 1803068
drwxr-xr-x 5 root root 4096 2008-10-07 18:14 database
-rw-r–r– 1 leo leo 1844527800 2009-07-31 06:08 oracle.zip
[email protected]:~$ cd database
[email protected]:~/database$ ls -l
total 28
drwxr-xr-x 11 root root 4096 2008-10-06 16:00 doc
drwxr-xr-x 5 root root 4096 2008-10-06 16:00 install
-rw-r–r– 1 root root 124 2008-10-06 21:35 README
-rwxr-xr-x 1 root root 2911 2008-09-26 17:41 runInstaller
drwxr-xr-x 14 root root 4096 2008-10-06 16:00 stage
-rw-r–r– 1 root root 4835 2008-09-26 17:40 welcome.html
[email protected]:~/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 80 MB. Actual 6770 MB Passed
Checking swap space: must be greater than 150 MB. Actual 933 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-08-03_12-24-49AM. Please wait …[email protected]:~/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
Can’t connect to X11 window server using ‘Xserver.IPaddress:0.0’ as the value of the DISPLAY variable.
Xserver.IPaddress:0.0
Xserver.IPaddress:0.0
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to X11 window server using ‘Xserver.IPaddress:0.0’ as the value of the DISPLAY variable. The DISPLAY environment variable should be set to :, where the is usually ‘0.0’.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
– For csh: % setenv DISPLAY 192.168.1.128:0.0
– For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY
– Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as ‘xclock’:
%
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for ‘xclock’: ‘/usr/X11R6/bin/xclock’
guys plz guide me how to make a database on oracle.i m new here
hi
could you send me link of extra packages
i am not able to find out from where i have to download extra packages and sub packages
like (autotools-dev cpp cpp-4.1 debhelper dpkg-dev gcc-4.1 gcc-4.1-base gettext html2text intltool-debian libbeecrypt6 libice6 libneon25 librpm4 libsm6
libx11-6 libx11-data libxau6 libxdmcp6 libxext6 libxml2 libxmu6 libxp6 libxt6 linux-libc-dev patch po-debconf x11-common
Suggested packages:
lintian binutils-doc cpp-doc gcc-4.1-locales dh-make debian-keyring gcc-multilib manpages-dev autoconf automake1.9 flex bison gdb gcc-doc
gcc-4.1-multilib gcc-4.1-doc cvs gettext-doc glibc-doc libtool-doc automaken g77 fortran77-compiler gcj make-doc diff-doc
Recommended packages:
libmudflap0-dev libltdl3-dev xml-core libmail-sendmail-perl libcompress-zlib-perl
The following NEW packages will be installed:
alien autotools-dev binutils cpp cpp-4.1 debhelper dpkg-dev gawk gcc gcc-4.1 gcc-4.1-base gettext html2text intltool-debian ksh libaio1 libbeecrypt6
libc6-dev libice6 libmotif3 libneon25 librpm4 libsm6 libtool libx11-6 libx11-data libxau6 libxdmcp6 libxext6 libxml2 libxmu6 libxp6 libxt6 linux-libc-dev
)
thanks
rajnish
Hi I followed the steps mentioned to install Oracle 11g x86-64 on Kubuntu 9.1 (64). I am getting the following. Please advise on what to do.
$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 123068 MB Passed
Checking swap space: must be greater than 150 MB. Actual 5994 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-11-08_09-57-34PM. Please wait …[email protected]:/home/anil/Oracle_install_files/linux.x64_11gR2_database_1of2/database$ Exception in thread “main” java.lang.NoClassDefFoundError
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at java.awt.Toolkit$2.run(Toolkit.java:821)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
at com.jgoodies.looks.LookUtils.isLowResolution(Unknown Source)
at com.jgoodies.looks.LookUtils.(Unknown Source)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.(PlasticLookAndFeel.java:122)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1783)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:480)
at oracle.install.commons.util.Application.startup(Application.java:758)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)
Guys, I am sorry to intervene but I am a complete novice. I have this concern: it has been said (by Bott) that the entire operation went well because the base of both the desktop and server versions of 7.10 are similar. I am using Karmic (9.10). Will it work or do I have to use the server version of Ubuntu 9.10?
I’m trying to install oracle 10g on Ubuntu 9.10
when i run ./runInstaller I receive the following error:
./runInstaller: line 54: /oracle/stage/102_64/data/base/install.oui: No such file or directory
THe file exists and the permissions are fine… no idea why this is happening.
Jason: All you have to do is run : xhost +
Run this as ur normal user who started the desktop. This way any other user such as user “oracle” can run a GUI application which this installer is.
good luck
I too get the:
[email protected]:~/database$ ./runInstaller
./runInstaller: line 54: /home/oracle/database/install/.oui: No such file or directory
The file is definitely there and has the right permissions. It is like the shell is unable to find it.
i have the same error that JAVA ERROR please help; i’m traying to install oracle 11g2 on ubuntu 9.10
thanks
I too get the:
[email protected]:~/database$ ./runInstaller -ignoreSysPrereqs
./runInstaller: line 137: /home/oracle/database/install/.oui: Nincs ilyen fájl vagy könyvtár
but
[email protected]:~/database$ ls -rtl install/.oui
-rwxr-xr-x 1 oracle oinstall 180222 2009-08-14 08:41 install/.oui
Sorry, I forgot to say
I try install Oracle 11gR2 on Ubuntu 9.10
To fix X11 (as root):
# xhost +local:oracle
# su – oracle
$ DISPLAY = :0.0; export DISPLAY
$ xclock //should display an X11 window
On Ubuntu 9.10 (Karmic), libstdc++.so.5, required by Oracle is replaced by .6. To fix:
1) add the following repository: https://archive.ubuntu.com/ubuntu jaunty universe
2) install libstdc++5 and run the install of Oracle
3) reinstall libstdc++6 (otherwise such apps as ooffice get broken)
Thanks for a great article I have Oracle 11G R2 up and running thanks to your handy guide really appreciate it thanks
Checking Temp space: must be greater than 120 MB. Actual 4057 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4064 MB Passed
Checking monitor: must be configured to display at least 256 colors >> failed
please give me how much resoluation i need to set