Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon)
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.
bott@mybox:~$ 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:
root@idlebox:~# uname -a Linux idlebox 2.6.22-14-server #1 SMP Sun Oct 14 23:34:23 GMT 2007 i686 GNU/Linux root@idlebox:~# apt-get update (...) root@idlebox:~# 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:
root@idlebox:~# 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.
root@idlebox:~# cd /bin root@idlebox:~# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2007-11-04 15:29 /bin/sh -> dash root@idlebox:/bin# ln -sf bash /bin/sh root@idlebox:/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 root@idlebox:~# addgroup oinstall Adding group `oinstall' (GID 1001) ... Done. 02 root@idlebox:~# addgroup dba Adding group `dba' (GID 1002) ... Done. 03 root@idlebox:~# addgroup nobody Adding group `nobody' (GID 1003) ... Done. 04 root@idlebox:~# usermod -g nobody nobody 05 root@idlebox:~# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle 06 root@idlebox:~# passwd -l oracle Password changed. 07 root@idlebox:~# mkdir /home/oracle 08 root@idlebox:~# chown -R oracle:dba /home/oracle 09 root@idlebox:~# ln -s /usr/bin/awk /bin/awk 10 root@idlebox:~# ln -s /usr/bin/rpm /bin/rpm 11 root@idlebox:~# ln -s /usr/bin/basename /bin/basename 12 root@idlebox:~# mkdir /etc/rc.d 13 root@idlebox:~# 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 root@idlebox:~# mkdir -p /u01/app/oracle 15 root@idlebox:~# 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.
root@idlebox:~# 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.
root@idlebox:~# su - oracle
oracle@idlebox:~$ export DISPLAY=Xserver.IPaddress:0.0
oracle@idlebox:~$ cd /media/database/
oracle@idlebox:/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:
root@idlebox:~# /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
root@idlebox:~# /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:
root@idlebox:~# chmod a+x /etc/init.d/oracledb
If you want this script to be run at every boot, execute this:
root@idlebox:/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:
pythian@idlebox:~$ 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
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. There’s also a very good document on www.dizwell.com/prod/node/1046. 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
November 7th, 2007 at 8:51 am
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!
November 7th, 2007 at 10:53 am
@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!
November 22nd, 2007 at 4:30 am
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.
November 23rd, 2007 at 2:06 pm
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
November 23rd, 2007 at 3:30 pm
@Enrique,
Did you remember to start the installer with the ‘-ignoreSysPrereqs’ command line switch?
November 24th, 2007 at 12:12 pm
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
November 24th, 2007 at 1:35 pm
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
November 26th, 2007 at 11:22 am
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
January 10th, 2008 at 5:55 pm
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.
January 10th, 2008 at 8:23 pm
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.
January 11th, 2008 at 12:06 pm
That’s good news, Sara!
January 11th, 2008 at 6:44 pm
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.
January 17th, 2008 at 5:18 pm
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.
February 1st, 2008 at 12:41 am
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 …oracle@bserver:/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’
February 7th, 2008 at 1:06 pm
[…] 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 […]
February 10th, 2008 at 2:39 am
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
March 3rd, 2008 at 1:10 pm
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?
March 4th, 2008 at 3:47 am
Hi i’m trying installation instruction but there are some errors as below when i used ./runInstaller -ignoreSysPrereqs , how i can solve this solution ?
oracle@Ubuntu:/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 …oracle@Ubuntu:/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’
March 5th, 2008 at 11:26 pm
[…] Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon) (tags: oracleinstall) […]
March 6th, 2008 at 1:25 pm
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
March 7th, 2008 at 3:53 pm
Followed all the steps. Tried to run the installer and got this error:
oracle@oralinux: ./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…
March 8th, 2008 at 3:21 am
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
March 8th, 2008 at 4:22 am
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
March 8th, 2008 at 1:58 pm
@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.
March 8th, 2008 at 2:24 pm
@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?
March 8th, 2008 at 3:06 pm
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.
March 8th, 2008 at 6:55 pm
@ 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
March 18th, 2008 at 8:33 am
Hi there
i have a problem with running the OUI
when i type in “./runInstaller -ignoreSysPrereqs” this Error is shown
oracle@sys:~/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: http://www.dbforums.com/showthread.php?t=1624849
but that didn’t helped me :(
does somebody know the answer? would be great, thanks
March 18th, 2008 at 12:15 pm
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 :(
March 18th, 2008 at 6:08 pm
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 ?
March 18th, 2008 at 9:26 pm
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?
March 19th, 2008 at 5:01 am
@rune
I have an answer for the “LISTNER not set”-problem
http://blog.vpire.com/?p=237
http://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 http://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
March 19th, 2008 at 9:23 am
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
March 19th, 2008 at 11:40 am
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 :(
March 19th, 2008 at 3:35 pm
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 http://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.
March 19th, 2008 at 3:53 pm
@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.
March 19th, 2008 at 5:59 pm
> idkline Says:
> Followed all the steps. Tried to run the installer and got this error:
>
> oracle@oralinux: ./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.
March 19th, 2008 at 9:02 pm
@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. :)
March 20th, 2008 at 3:45 am
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
March 20th, 2008 at 4:08 am
@Luke
Please can you explain how you unlocked the user oracle?
Thanks
March 20th, 2008 at 6:47 am
@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.
March 20th, 2008 at 2:54 pm
@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
March 20th, 2008 at 6:29 pm
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 ;)
March 24th, 2008 at 1:30 am
after following the steps, i got an error! I’ve tried modifying the tnsnames,ora and listener.ora but still the error occur.
oracle@jon-desktop:/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>
March 26th, 2008 at 5:36 pm
Brilliant howto - I’ve tried lots of oracle/debian ones before but this one actually works.
March 26th, 2008 at 7:53 pm
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…
March 27th, 2008 at 4:04 am
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!
March 27th, 2008 at 12:10 pm
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.
March 27th, 2008 at 2:12 pm
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
March 29th, 2008 at 11:43 pm
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?
April 1st, 2008 at 4:18 am
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.
April 2nd, 2008 at 4:51 am
The install does not work,
as it hangs on ./runInstaller -ignoreSysPrereqs
at the part on ignoring the 256 colors issue
April 6th, 2008 at 5:35 pm
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?
April 10th, 2008 at 2:02 pm
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.
April 18th, 2008 at 1:45 am
[…] http://www.pythian.com/blogs/654/installing-oracle-11g-on-ubuntu-linux-710-gutsy-gibbon […]
April 19th, 2008 at 2:57 am
Thanks for this very good checklist.
Ubuntu makes an interesting test environment.
Regards,
Alejandro
April 28th, 2008 at 3:54 am
thanks Augusto and others… Oracle11g up and running on ubuntu now. cheers!
April 28th, 2008 at 3:55 am
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 oracle@idlebox:~$ 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
April 28th, 2008 at 10:28 am
@ 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.
April 29th, 2008 at 8:50 am
/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
April 29th, 2008 at 11:32 am
@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.
April 30th, 2008 at 12:17 pm
After:
chau@pc5:~/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.
April 30th, 2008 at 3:23 pm
@CHAU,
Please notice footnote #3 (click here). It looks like you don’t have the
unzippackage installed.May 1st, 2008 at 5:21 am
@Bott,
Thank for your response.
1) I install the “unzip” package. It exists already, as the Terminal replies:
———————
root@pc5:/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:
———————
root@pc5:/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
root@pc5:/home/chau/database#
———————
Please help.
May 1st, 2008 at 11:03 am
@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:pythian@idlebox:~/database $ ls -l install/unzip
-rwxr-xr-x 1 pythian dba 102612 2007-08-03 13:28 install/unzip
May 1st, 2008 at 12:44 pm
1)
chau@pc5:~$ pwd
/home/chau
chau@pc5:~$ ls -l install/unzip
ls: cannot access install/unzip: No such file or directory
chau@pc5:~$
2) new download oracle 11g is underway, check MD5 after.
May 6th, 2008 at 4:07 pm
[…] 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 […]
May 16th, 2008 at 8:12 pm
[…] trust myself to remember « FET - Open Source TimetablingInstalling Oracle on Ubuntuhttp://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 […]
May 19th, 2008 at 11:18 pm
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
June 21st, 2008 at 5:30 am
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
July 5th, 2008 at 1:43 pm
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 :)
July 11th, 2008 at 10:47 am
@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.
July 11th, 2008 at 11:24 am
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.
July 11th, 2008 at 12:23 pm
@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.
July 18th, 2008 at 5:21 am
@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.
July 21st, 2008 at 7:53 am
@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!
July 24th, 2008 at 11:32 pm
@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,
August 1st, 2008 at 3:46 am
I am not sure what is causing this error. Please give me some pointers on how I can fix it.
———————————————-
oracle@jubuntu:/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 …oracle@jubuntu:/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’
August 4th, 2008 at 8:51 am
@joey,
Please remember to export the
DISPLAYvariable (one command line before runningrunInstaller.Cheers!
October 21st, 2008 at 11:36 am
[…] 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 […]
October 31st, 2008 at 4:53 am
what about a next episode on configuring lamp with oracle. Would be really coool. Anyway|! U’ve done good stuff man! Tx a lot!
November 14th, 2008 at 9:37 am
thank you for your tutorial very much.
November 20th, 2008 at 10:39 am
Excellent Tutorial, it made things look easy.
Thanks again.
November 21st, 2008 at 1:54 pm
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?
November 21st, 2008 at 2:42 pm
@coren,
Please double check the location and permissions of the inventory directory you’re trying to use (right after you fire up
OUI).Cheers!
November 21st, 2008 at 6:06 pm
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
November 25th, 2008 at 12:31 pm
@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!
November 28th, 2008 at 11:09 pm
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.
=============================================================
sychen@sychen: su
root&sychen: su - oracle
Your account has expired; please contact your system administrator
su: User account has expired
(Ignored)
oracle@sychen-laptop:~$ cd /DATA/database
oracle@sychen-laptop:/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 …oracle@sychen-laptop:/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’
oracle@sychen-laptop:/DATA/database$ xclock
No protocol specified
Error: Can’t open display: :0.0
oracle@sychen-laptop:/DATA/database$ exit
logout
root@sychen-laptop:/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
root@sychen-laptop:/home/sychen# exit
exit
sychen@sychen-laptop:~$ xclock
sychen@sychen-laptop:~$ 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.
November 29th, 2008 at 10:48 am
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.
November 29th, 2008 at 10:34 pm
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?
December 1st, 2008 at 11:09 am
@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!