Installing Oracle 11g on Ubuntu 8.04 LTS (Hardy Heron)
May 6, 2008 / By Augusto Bott
Note: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex is now published.
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 reviewing and putting together this new HOWTO for the installation.
Please note: I’ve used the x86 server version of Ubuntu 8.04, but the same steps should work without any problems for the Desktop version. Also notice that this whole procedure can easily take over six hours to complete, so don’t complain I didn’t warn you!
So, let’s get started, shall we?
Step One
Get the Ubuntu Linux 8.04 Hardy Heron (x86, 32-bit) image here, burn it, and install on any box you like. The only remark on the installation is that you should ask the installer to install an OpenSSH server at the end of the installation, since we’ll perform all the steps on this procedure remotely.
I’m not sure about the minimum requirements for the server, as, the last time I checked, running Oracle on Ubuntu is not officially supported by Oracle. In case you’re wondering, however, I’m using an x86 Pentium-like machine with 512M of RAM.
Step Two
Download Oracle 11g for Linux (x86, 32-bit).
It’s a good idea to verify the checksum hashes of the downloaded images before burning them (especially the ISO file to install Ubuntu). You can do that with one or more of md5sum filename, sha1sum filename , or cksum filename on almost any Unix-like box. Here are the pages showing the hashes:
- The MD5sums for the Ubuntu image
- The cksums of the Oracle image
(Wikipedia has pages on both these hash functions: MD5 and cksum.)
Step Three
We’ll need an X server for this howto, so on your desktop computer, allow X connections from your (soon-to-be) database server to your desktop. If you happen to be using Ubuntu on the Desktop as well, go to System -> Administration -> Login Window, select the Security tab and uncheck the box next to “Deny TCP connections to the Xserver”. You will have to restart your Xserver for this change to take effect.
I’m running Ubuntu on the desktop (I call this host “note“), so I have already an X server up and running. You can probably skip this step if you’re running the X server on the same machine you’re installing the database onto. Change 192.168.x.y to the IP address of your soon-to-be Oracle 11g database server:
bott@note:~$ hostname note user@note:~$ xhost +192.168.x.y 192.168.x.y being added to access control list
Step Four
Log in to your machine via SSH and upgrade all packages.
bott@note:~$ ssh user@192.168.x.y user@192.168.x.y's password: Linux hardy 2.6.24-16-server #1 SMP Thu Apr 10 13:58:00 UTC 2008 i686 The programs included with the Ubuntu system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. To access official Ubuntu documentation, please visit: http://help.ubuntu.com/ Last login: Thu May 1 21:45:05 2008 from 192.168.w.z user@hardy:~$
Once you have made sure you have network connectivity, update all packages to the latest version (after all, we’re using a newly released version and updates can be expected at some point in the future). Here’s the output as of Thursday, May 4th 2008:
user@hardy:~$ hostname hardy user@hardy:~$ sudo su - [sudo] password for pythian: root@hardy:~# apt-get update Hit http://security.ubuntu.com hardy-security Release.gpg Ign http://security.ubuntu.com hardy-security/main Translation-en_US Hit http://us.archive.ubuntu.com hardy Release.gpg Ign http://us.archive.ubuntu.com hardy/main Translation-en_US (...) Fetched 7455kB in 2min36s (47.6kB/s) Reading package lists... Done root@hardy:~# apt-get dist-upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done The following packages will be upgraded: libldap-2.4-2 lshw 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 498kB of archives. After this operation, 0B of additional disk space will be used. Do you want to continue [Y/n]? Get:1 http://us.archive.ubuntu.com hardy-updates/main libldap-2.4-2 2.4.7-6ubuntu4.1 [181kB] Get:2 http://us.archive.ubuntu.com hardy-updates/main lshw 02.12.01-2ubuntu1.1 [317kB] Fetched 498kB in 2s (211kB/s) (Reading database ... 18768 files and directories currently installed.) Preparing to replace libldap-2.4-2 2.4.7-6ubuntu3 (using .../libldap-2.4-2_2.4.7-6ubuntu4.1_i386.deb) ... Unpacking replacement libldap-2.4-2 ... Preparing to replace lshw 02.12.01-2ubuntu1 (using .../lshw_02.12.01-2ubuntu1.1_i386.deb) ... Unpacking replacement lshw ... Setting up libldap-2.4-2 (2.4.7-6ubuntu4.1) ... Setting up lshw (02.12.01-2ubuntu1.1) ... Processing triggers for libc6 ... ldconfig deferred processing now taking place root@hardy:~#
In case you’re wondering why we used sudo su - instead of sudo -s (as on the last version of this HOWTO ): sudo su - effectively makes us root with a new/empty session, while sudo -s makes us root while preserving some of our session variables from our “user” session. I chose this path in an attempt to make this whole process a bit more deterministic and less vulnerable to problems.
If apt-get dist-upgrade installs a new kernel version, it’s a good idea to reboot the box before proceeding.
root@hardy:~# reboot
Broadcast message from user@hardy
(/dev/pts/0) at 0:04 ...
The system is going down for reboot NOW!
root@hardy:~# Connection to 192.168.x.y closed by remote host.
Connection to 192.168.x.y closed.
bott@note:~$
Step Five
Once our machine is back up, we log in again and install a few extra packages needed for the installation: build-essential, libaio1, gawk, ksh, libmotif3, alien, libtool, and lsb-rpm. Please also note that our kernel has been upgraded to a newer build:
bott@note:~$ ssh user@192.168.x.y user@192.168.x.y's password: Linux hardy 2.6.24-16-server #1 SMP Thu Apr 10 13:58:00 UTC 2008 i686 The programs included with the Ubuntu system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. To access official Ubuntu documentation, please visit: http://help.ubuntu.com/ Last login: Thu May 1 21:45:05 2008 from 192.168.w.z user@hardy:~$ sudo su - [sudo] password for pythian: root@hardy:~# apt-get install build-essential libaio1 gawk ksh libmotif3 alien libtool lsb-rpm Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: autotools-dev binutils debhelper dpkg-dev g++ g++-4.2 gcc gcc-4.2 gettext html2text intltool-debian libbeecrypt6 libc6-dev libgomp1 libice6 libneon27 librpm4.4 libsm6 libstdc++6-4.2-dev libtimedate-perl libx11-6 libx11-data libxau6 libxcb-xlib0 libxcb1 libxdmcp6 libxext6 libxml2 libxmu6 libxp6 libxt6 linux-libc-dev make patch po-debconf rpm x11-common Suggested packages: lintian binutils-doc dh-make debian-keyring g++-multilib g++-4.2-multilib gcc-4.2-doc libstdc++6-4.2-dbg autoconf automake1.9 bison flex gcc-doc gcc-multilib gdb manpages-dev gcc-4.2-locales gcc-4.2-multilib libgcc1-dbg libgomp1-dbg libmudflap0-4.2-dbg libmudflap0-4.2-dev cvs gettext-doc glibc-doc libstdc++6-4.2-doc automaken gcj gfortran fortran95-compiler libtool-doc make-doc diff-doc Recommended packages: libltdl3-dev xml-core libmail-sendmail-perl libcompress-zlib-perl libmail-box-perl The following NEW packages will be installed: alien autotools-dev binutils build-essential debhelper dpkg-dev g++ g++-4.2 gawk gcc gcc-4.2 gettext html2text intltool-debian ksh libaio1 libbeecrypt6 libc6-dev libgomp1 libice6 libmotif3 libneon27 librpm4.4 libsm6 libstdc++6-4.2-dev libtimedate-perl libtool libx11-6 libx11-data libxau6 libxcb-xlib0 libxcb1 libxdmcp6 libxext6 libxml2 libxmu6 libxp6 libxt6 linux-libc-dev lsb-rpm make patch po-debconf rpm x11-common 0 upgraded, 45 newly installed, 0 to remove and 0 not upgraded. Need to get 22.9MB of archives. After this operation, 80.5MB of additional disk space will be used. Do you want to continue [Y/n]? (... again: downloads a bunch of packages ...) (... again: installs a bunch of packages ...) Processing triggers for libc6 ... ldconfig deferred processing now taking place root@hardy:~#
Step Six
After all those packages and updates are installed, we make some adjustments on our system. First of all, we change the default replacement for sh from dash to bash. Do not forget skip this step, otherwise we might get all sorts of weird errors during our installation:
root@hardy:~# cd /bin root@hardy:/bin# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2008-04-28 19:59 /bin/sh -> dash root@hardy:/bin# ln -sf bash /bin/sh root@hardy:/bin# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2008-05-01 22:51 /bin/sh -> bash
In case you’re wondering why Ubuntu uses dash as default, here is a detailed explanation of why dash is the default system shell and how if differs from bash.
Step Seven
Next we make some modifications to our base system (line numbers added for clarity, see below):
01 root@hardy:/bin# cd 02 root@hardy:~# pwd /root 04 root@hardy:~# addgroup oinstall Adding group `oinstall' (GID 1001) ... Done. 07 root@hardy:~# addgroup dba Adding group `dba' (GID 1002) ... Done. 10 root@hardy:~# addgroup nobody Adding group `nobody' (GID 1003) ... Done. 13 root@hardy:~# usermod -g nobody nobody 14 root@hardy:~# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle 15 root@hardy:~# passwd -l oracle Password changed. 17 root@hardy:~# mkdir /home/oracle 18 root@hardy:~# chown -R oracle:dba /home/oracle 19 root@hardy:~# ln -s /usr/bin/awk /bin/awk 20 root@hardy:~# ln -s /usr/bin/rpm /bin/rpm 21 root@hardy:~# ln -s /usr/bin/basename /bin/basename 22 root@hardy:~# mkdir /etc/rc.d 23 root@hardy:~# 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 24 root@hardy:~# mkdir -p /u01/app/oracle 25 root@hardy:~# chown -R oracle:dba /u01 26 root@hardy:~#
- Lines 01-03: change our path back to
/root(HOMEfor therootuser, not really needed) - Lines 04-12: add the groups we need.
- Line 13: adapts Ubuntu’s
nobodyuser so the Oracle installer doesn’t get confused. - Lines 14-18: we create the
oracleuser, lock that account so no one can log in with it, and create aHOMEdirectory for the user (not the same asORACLE_HOME). - Lines 19-23: we create some symlinks so the Oracle installer finds the paths where it expects them to be.
- Finally, on lines 24-25 we create our
ORACLE_BASE.
Step Eight
We change a few of the defaults on our system, adding the following to the end of /etc/sysctl.conf. This will extend the total number of file descriptors on a system, the size of shared memory, and will do some tweaking on the networking subsystem. About the networking tweaks: it may bring benefits or it may not — your mileage may vary.
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
Add this to the end of /etc/security/limits.conf:
oracle soft nproc 2047 oracle hard nproc 16383 oracle soft nofile 1023 oracle hard nofile 65535
And add this to the end of /etc/pam.d/login so we enforce what we just added to /etc/security/limits.conf:
session required /lib/security/pam_limits.so session required pam_limits.so
There is some explanation for all these system modifications on the first post: Installing Oracle 11g on Ubuntu Linux 7.04.
Before continuing, you have two choices: you reboot the machine so the new values are loaded for sysctl.conf; or you ask the box to reload them with sysctl -p:
root@hardy:~# sysctl -p kernel.printk = 4 4 1 7 kernel.maps_protect = 1 fs.inotify.max_user_watches = 524288 vm.mmap_min_addr = 65536 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.all.rp_filter = 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 65535 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144 net.core.wmem_max = 262144 root@hardy:~#
Step Nine
For this HOWTO, I’ve unpacked the ZIP file we downloaded on Step 2 in /home/oracle, so we su to the oracle user, export our DISPLAY (change 192.168.w.z to the IP address of your X server), and start the installation. When we do su - oracle, Ubuntu will complain about the account being expired — this is harmless. When starting the installer, please note that we pass the -ignoreSysPrereqs command-line switch.
root@hardy:~# su - oracle Your account has expired; please contact your system administrator su: User account has expired (Ignored) oracle@hardy:~$ export DISPLAY=192.168.w.z:0.0 oracle@hardy:~$ pwd /home/oracle oracle@hardy:~$ ls -l total 4 drwxr-xr-x 6 oracle dba 4096 2007-09-18 18:50 database oracle@hardy:~$ cd database oracle@hardy:~/database$ ls -l total 28 drwxr-xr-x 11 oracle dba 4096 2007-08-06 16:02 doc drwxr-xr-x 5 oracle dba 4096 2007-08-03 13:28 install drwxr-xr-x 2 oracle dba 4096 2007-09-18 18:52 response -rwxr-xr-x 1 oracle dba 2911 2007-08-03 13:28 runInstaller drwxr-xr-x 14 oracle dba 4096 2007-08-03 13:27 stage -rw-r--r-- 1 oracle dba 4835 2007-08-06 18:19 welcome.html oracle@hardy:~/database$ ./runInstaller -ignoreSysPrereqs
After a few moments, the Oracle Universal Installer (OUI) will show you a window similar to this one (as well as a bunch of garbled text on the SSH session, no need to bother with that now unless no window pops up):
After you hit Next, it will ask you where you want the Oracle Inventory should be installed. I’ve changed the group to dba, but you don’t need to change it if you don’t want to
Hitting Next will make the OUI review which products are included in the package:
We’re choosing Enterprise Edition on this HOWTO, but you can choose whatever you want.
It will ask you the paths for the installation:
I chose the defaults and hit Next:
The next step — some prerequisite checks. Some of them will fail: this is expected — after all we’re installing on an unsupported platform.
All you have to to is click on each of the unmarked the checkboxes (those on which Status is not Succeeded). As you click on them, the Status will change to User Verified.
After hitting Next, OUI will ask if we want to create a database. I chose “Install Software Only” as a new database can be created later with dbca.
I’ve changed all groups to dba:
It’ll show you a Summary before starting the installation. After hitting Install, go get yourself some coffee: this is going to take a while.
After we get to 90% of the installation (linking stage) it might seem stuck, but it isn’t: let it run, and go get yourself more coffee.
Once OUI is done with the linking, it will ask you to run two scripts as root:
Here’s the output on my setup:
root@hardy:~# /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@hardy:~# /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]:
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.
root@hardy:~#
And… congratulations! You just finished installing Oracle 11g on Ubuntu 8.04 LTS (Hardy Heron)!
However, we’re not completely done yet: a few actions need to be performed to make your life easier. First, we add these lines to /etc/profile:
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, a startup script might be useful, right? Create a file called /etc/init.d/oracledb and put this into it:
#!/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 $ORACLE_HOME"
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
After saving this file, make it executable:
root@hardy:~# chmod a+x /etc/init.d/oracledb
If you want this script to be run at every boot, execute this:
root@hardy:~# 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
Just remember: this script depends on the existence of a database on the machine, so don’t forget to run dbca as the oracle user, and configure it to start at boot time (edit /etc/oratab after creating the database, and set the last column to Y).
To make things easier, make your user part of the dba group. This way your user will be able to interact with the database server with the dba role. In the example below, user is the username:
root@hardy:~# usermod -G dba -a user
When creating a database with dbca, don’t forget to do so as the oracle user (and to export the DISPLAY environment variable). After creation, you should test if you can connect to it:
oracle@hardy:~$ export ORACLE_SID=heron oracle@hardy:~$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Mon May 5 02:39:27 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
After you get this output, we can finally say: it’s complete! Of course, I invite you to share your thoughts and your experiences with this HOWTO.
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.
Augusto Bott.
Related Posts
As of now, im still running Ubuntu 7.10 on both my laptop and desktop.
Desktop runs Oracle 11g while the laptop runs Oracle XE 10.
Anyway, I will upgrade to 8.04 on both computers in two weeks time, and seeing that you have made a tutorial for this installation as well really made my day!
Thank you for all your time and effort in this matter, it really helps a lot of people! Will check back in two weeks regarding problems and solutions ;)
Pingback: Log Buffer #96: a Carnival of the Vanities for DBAs
Thanks for the how-to.
It works just fine under Ubuntu 8.04. Did a lot of search and found your guide to be the best for Ubuntu or Debian based.
Many thanks,
Worked like a dream, even in a virtual machine!
Stephen
When trying to install on Ubuntu 8.04 x86-64, I ran into this error:
INFO: Linking external procedure agent (/u02/app/oracle/oracle/rdbms/lib/extproc32)
INFO: rm -f /u02/app/oracle/oracle/rdbms/lib/extproc32
INFO: gcc -m32 -o /u02/app/oracle/oracle/rdbms/lib/extproc32 -L/u02/app/oracle/oracle/rdbms/lib32/ -L/u02/app/oracle/oracle/lib32/ -L/u02/app/oracle/oracle/lib32/stubs/ /u02/app/oracle/oracle/rdbms/lib32/hormc.o /u02/app/oracle/oracle/rdbms/lib32/homts.o -lagtsh -lpthread -lclntsh `cat /u02/app/oracle/oracle/lib32/sysliblist` -Wl,-rpath,/u02/app/oracle/oracle/lib32 -lm `cat /u02/app/oracle/oracle/lib32/sysliblist` -ldl -lm -L/u02/app/oracle/oracle/lib32
INFO: /
INFO: usr
INFO: /
INFO: bin
INFO: /
INFO: ld
INFO: :
INFO:
INFO: cannot
INFO:
INFO: find
INFO:
INFO: -
INFO: lagtsh
INFO:
INFO: collect2:
INFO: ld returned 1 exit status
INFO:
INFO: make[1]: Leaving directory `/u02/app/oracle/oracle/rdbms/lib’
INFO: make[1]: *** [/u02/app/oracle/oracle/rdbms/lib/extproc32] Error 1
make: *** [extproc32] Error 2
INFO: End output from spawned process.
INFO: ———————————-
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target ‘all_no_orcl’ of makefile ‘/u02/app/oracle/oracle/rdbms/lib/ins_rdbms.mk’. See ‘/u01/app/oracle/oraInventory/logs/installActions2008-05-13_08-32-12PM.log’ for details.
Exception Severity: 1
Any idea how to get over this?
Thanks.
Did you get the solution to this?
I am facing that right now. I would appreciate any answer.
Cheers,
almudena
@Adrian
Unfortunately, no idea – haven’t tried to install Oracle 64-bit so far. However, if we do try to do it, we’ll post here the suggestions. Are you trying to install de 32-bit version on a 64-bit OS? If you’re doing a 64/64 install, I’d suggest you investigate if there are some 32-bit libraries available to install on your 64-bit system…
I’m doing a 64/64 install. I was actually trying to install 10g 64bit on Ubuntu 64 Hardy, but that failed miserably so I gave 11g 64bit a shot.
As it turns out, even though I do get that error, if I just hit continue the database will throw another error and then everything will install and work as expected, with the exception of the EM Console, which does not work at all.
I installed all the 32bit libraries available in Synaptic, that I could figure were related to this error. I can list the packages I have installed in the system if there’s anybody interested.
Installation how to for 8.04:
http://technicianspot.blogspot.com/2008/05/installing-linux-ubuntu.html
Need help, please.
Install “oracle Applications Release 12″ on Hardy Server amd64.
All system prerequis are installed. The install command is “rapidwiz”.
appmgr@ubu:~$ /d01/Stage12/startCD/Disk1/rapidwiz/rapidwiz
———- troubles below ———
appmgr@ubu:~$ Locking assertion failure. Backtrace:
#0 /usr/lib32/libxcb-xlib.so.0 [0xf73cd767]
#1 /usr/lib32/libxcb-xlib.so.0(xcb_xlib_unlock+0×31) [0xf73cd8b1]
#2 /usr/lib32/libX11.so.6(_XReply+0xfd) [0xcddf31bd]
#3 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so [0xce162a76]
#4 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so [0xce14880a]
#5 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so [0xce148a51]
#6 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so(Java_sun_awt_X11GraphicsEnvironment_initDisplay+0×24) [0xce148c5c]
#7 [0xf2437fa8]
#8 [0xf2431aeb]
#9 [0xf2431aeb]
#10 [0xf242f1b4]
#11 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf765734c]
#12 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf77f7c08]
#13 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf765717f]
#14 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so(JVM_DoPrivileged+0x2dd) [0xf76a636d]
#15 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/libjava.so(Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0x3d) [0xf73762cd]
#16 [0xf2437838]
#17 [0xf2431a14]
#18 [0xf242f1b4]
#19 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf765734c]
Locking assertion failure. Backtrace:
#0 /usr/lib32/libxcb-xlib.so.0 [0xf73cd767]
#1 /usr/lib32/libxcb-xlib.so.0(xcb_xlib_lock+0x2e) [0xf73cd81e]
#2 /usr/lib32/libX11.so.6 [0xcddf2518]
#3 /usr/lib32/libX11.so.6(XGetVisualInfo+0×26) [0xcdde90a6]
#4 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so [0xce1476df]
#5 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so [0xce147970]
#6 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so [0xce148b98]
#7 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so(Java_sun_awt_X11GraphicsEnvironment_initDisplay+0×24) [0xce148c5c]
#8 [0xf2437fa8]
#9 [0xf2431aeb]
#10 [0xf2431aeb]
#11 [0xf242f1b4]
#12 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf765734c]
#13 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf77f7c08]
#14 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so [0xf765717f]
#15 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/server/libjvm.so(JVM_DoPrivileged+0x2dd) [0xf76a636d]
#16 /d01/Stage12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/libjava.so(Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0x3d) [0xf73762cd]
#17 [0xf2437838]
#18 [0xf2431a14]
#19 [0xf242f1b4]
appmgr@ubu:~$ exit
logout
————–
The “Install Oracle Applications – Welcome” window is displayed but empty, then halt.
I need to install oracle client only to connect to an outside database using odbc. does the steps listed here work also for installing the client?
Hello
in step 9, i get the error Cannot Open Display, plz suggest something… i m going nuts
tried xterm, xhost etc..
regards
@mqatrawi,
I haven’t tried it myself, but to install only the client you could skip step eight (no need to modify those system defaults, once you’re not running the database, only the client). Also, you might want to consider using the Oracle Instant Client. It can be found here.
@badwanpk,
I’d suggest you double-check the IP addresses your currently using on your network, since the ones provided on this HOWTO are not ‘real’ IP addresses.
Cheers!
Hello
All the other steps are ok, but wile configuring the database, after the 13 steps in Database Configuration Assistant, the CONFIRMATION window opens but is empty, it shows no options, tried many times but in vain, plz suggest something.
regards
@badwanpk,
I’m sorry, but I don’t have any clues on what might be wrong on you particular case… I did ran into problems on the first attempt to install, so I’ve repeated this installation 4 more times to make sure all the steps are correct, leading to a successful installation. Perhaps you missed a few steps or made some sort of typo while entering the commands?
Good luck!
Hi Bott,
I installed the DB fine, and run the last script ( update-rc.d oracledb defaults 99 ) fine…
But after that i was trying to use DBCA command as oracle user and is not letting me create the DB. Also the terminal i have used to do the installation is having this :
rpm: To install rpm packages on Debian systems, use alien. See README.Debian.
error: cannot open Packages index using db3 – No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
I dont know exactly if this is the reason for wich I can not create the DB
thx a lot
Paul
@Paul,
Hi there. Thanks for pointing that out. I’ve tried reinstalling after the latest kernel upgrades and unfortunately you’re right: dbca dies in the middle. I’ll do some investigation myself and post the solution here (if I find one, afterall we’re talking about an unsupported platform anyways…).
In the meanwhile, has anyone around found a solution?
If you did, please let us know.
Cheers!
I’m on the step nine when i try to
su – oracle
i recieved this error
Your account has expired; please contact your system administrator
su: User account has expired
(Ignored)
Cannot execute /binbash: No such file or directory
regards
@buragas,
I’d say you’ve probably made a typo, since /binbash is not a valid binary on a standard Ubuntu setup. However, /bin/bash is a valid shell. Please double check the paths you’ve typed on steps 6 and 7 (line 14, to be exact). If you did made a typo on step 7, use usermod to change the default shell for the oracle user.
Cheers!
Dude, you rule – you just saved me hours of trudge. BTW, your instructions work pretty much word for word for 10g.
I had the same problem as badpwank with a blank confirmation window. Turning off visual effects (System -> Preferences -> Appearance -> Visual Effects tab) resolved the problem.
hello,
this has been of great help. i was able to create the DB, and start it and connect it from the oracle user. But I was unable to connect from default user(zalym).I have added zalym into the dba group.
When I try to connect thru SQLPlus, it comes back with this message
“Connected to an idle instance.”
after that any query i type, I get the following error.
ERROR at line 1:
ORA-01034: ORACLE not available
I am able to do everything from the oracle user. Connect, run queries against it etc. Why does this happen?
I am stuck with this. Please help.
I think my issue is related to the listener. Firstly the listener was not starting because of some hard coding in the dbstart script.
Refer – http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php
I am still unable to get it up.
I reinstalled, did everything word by word, and now it works. Thanks a lot mate.
@saleem,
Have you started sqlplus \'/as sysdba\' with your user?
Have you set the ORACLE_SID environment variable before that?
Cheers!
yes, all ur instructions work. i hv to export the ORACLE_SID everytime I access thru sqlplus which is fine…
thanks a bunch
i am newbie
i followed all of instructions
at finnally
when i type
—————————————————————-
oracle@backup:~$ sqlplus
SQL*Plus: Release 11.1.0.6.0 – Production on Mon Jun 9 18:13:58 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: oracle
Enter password: ******
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@backup:~$
—————————————————————-
i thing i have not created DataBases
can any one help ms..
For those with this error:
error at “invoking target ‘all_no_orcl ihsodbc’ of makefile
…/oracle/rdbms/lib/ins_rdbms.mk”
It can be fixed installing:
sudo apt-get install libstdc++5
The rest goes smooth.
Thanks for the tutorial. Excellent!
—
Oracle 10r2 on Ubuntu Hardy
BTW
I’ve been using “ssh -X user@machine” to run the Oracle installer; however, it is necessary to install XORG first if you are in Ubuntu Server (that comes with no X):
sudo apt-get install xorg
And runs very good.
Thanks again.
If anyone is having DISPLAY problems when performing the install on a local machine, try setting the DISPLAY to :0.0 instead of :0.0 (e.g. $ export DISPLAY=:0.0). It fixed for me.
That should have been “… try setting the DISPLAY to :0.0 instead of your.ip.is.here:0.0 …”
Do you have any experience in installing Oracle Enterprise Manager Grid Control 10g on ubuntu 8.04 ? or any doc, website that could help?
thanX in advance
Hello! I still have problems with the DISPLAY thing. I’m trying to install Oracle on my host, so I set DISPLAY=127.0.0.1:0.0 Even with DISPLAY=localhost:0.0
The result is the same:
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 <<<<
Then I try to rn xterm:
oracle@dremix:~/database$ xterm
xterm Xt error: Can’t open display: 127.0.0.1:0.0
I’m logged in with the oracle user.
Do you have any idea of what is happening?
Thank you!
Followed the above mentioned steps on Virtual PC 2007 running on Vista. Installation went like a charm. I did have some trouble setting up the xterm as I was running from the local computer so this is what I did:
1. As root $xhost +localhost
2. Login as oracle $su – oracle
3. $xhost and you should be able to see your localhost as one of the authorized clients
Everything else should be fine.
on step Nine , if you are installing on local machine you do not need to export DISPLAY but if you are installing on a remote machine try :
ssh username@remote-ip-address -Y
OR
ssh username@remote-ip-address -X
these commands let ssh forward X session from remote machine to local one,without need to set any DISPLAY variable, and you can see OUI screens.
(export DISPLAY never worked for me in ubuntu!)
As user ‘oracle’ I used ‘unzip’ for the .zip file, but the group is ‘oinstall’ instead of ‘dba’ for all of the files after unzipping. Is there something I did wrong? I am attempting to install on my laptop.
I followed the procedures except for the IP address portions. I performed steps 1, 2, 6, 7, 8, and 9.
Thanks for procedures and help.
Mike
@Alina,
If you’re installing on the same box you have an X server, you have to export DISPLAY=:0.0 (no IP,no host, nothing).
Cheers!
@Michael,
As long as the oracle user can read the files, you’ll be fine!
Cheers!
@Adrian
I was trying also to install 10g2 x64 at Ubuntu 8 x64 and finished with linking problems and not starting dbca. Please, try following:
1. apply steps from post of Rmantingh on
http://ubuntuforums.org/archive/index.php/t-592064.html
2. to solve problem with genclntsh: Failed to link libclntsh.so.10.1
because of incompatible libgcc.a I had to install
apt-get install gcc-multilib
3. once libclntsh.so.10.1 for lib32 was built dcba started without errors starting with ” UnsatisfiedLinkError exception loading native library: njni10 ”
ps: thanks to pythian for very helpful inst. procedure
i use the dbca command at step 13,the terminal show:
rpm: To install rpm packages on Debian systems, use alien. See README.Debian.
error: cannot open Packages index using db3 – No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
but i installed rpm packegages.
how to do?
thanks
Hi guys,
I followed the steps and everything worked fine. But when I got to the part where you type su – oracle and asks you for the password, I type in the password “oracle” and still it won’t let me in. In turn I can’t create the ‘inventory directory’ [/u01/app/oraInventory]. It pops up a message that I can’t create inventory because I don’t have write permission. Somebody have any idea?
Hi guys,
I got the oracle password part working, I just had to go to terminal – login as root – then use ‘su – oracle’ but then the problem now is that I can’t run the installation wizard anymore.. I typed in ./runInstaller -ignoreSysPrereqs and it gives me an error of like x server, can’t display and other stuff.. Just to give you guys a heads up I did not do the xhost in step 3 and ssh user@ipaddress in step 4 because I am installing it on the same machine (soon to be oracle server). Anyone can help me out? I would really appreciate it.
xterm can’t open display – looks like a bug:
just google “ubuntu xterm can’t open display”
Hello.
I’m getting DBCA hanging after I press “finish”, which I guess it’s the same problem of everyone here. Any news on that front? Will I have to install 7.10 to get this working??
Best regards,
Leonardo.
Well, it never rendered. I installed everything again in 7.10 and got the same blank/gray screen. I pressed enter, and it continued. I guess the same happens in 8.04.1, but I’m not reinstalling everything to test it. So, you might just give it a try.
@zm508_china,
We don’t use any RPM packages on this howto. Also, Ubuntu doesn’t have an index of all installed RPM packages on the machine – that message is supposed to be expected, but safely ignored.
Cheers!
@Jude,
sudo is a command to execute something as another user. When you execute sudo su - as your user, sudo is expecting your password, not the password from the ‘target’ (in this case, root.
@bug,
If you’re using a Ubuntu machine and want to use the X server on it, you need to go to menu System, Administration, Login Window. When the Login Preferences Window opens, uncheck “Deny TCP connections to the Xserver” and restart your X server (usually, a logout/login pair works just fine).
Cheers!
@Leonardo
I Had exactly the same problem: after pressing “Finish” in DBCA, I got stuck with an empty window, with no text and no buttons on it. It turns out this has to do something with the “Visual Effects” of the Ubuntu desktop. If you turn those off, you get the same window WITH the contents. See http://forums.oracle.com/forums/thread.jspa?messageID=2491552 for an explanation
@all people having DISPLAY problems
Here’s a forum posting that helped me out, it may be helpful to you as well: http://ubuntuforums.org/showpost.php?p=2457415&postcount=7
Thanks a lot for your instructions!
After having experienced some problems with Oracle 10g on Dapper Drake before, tonight I tried to install 11g (I downloaded linux.x64_11gR1_database.zip) on a Hardy Heron Desktop installation (64-bit).
Following each Step thoroughly, there were only the warnings you mentioned during the checks of the installer, and two error messages during the linking stage (at 88% to 90% of the whole process). By ignoring these (press “Continue”), the installation completed successfully.
Cheers,
Felix
Hi guys,
I followed every single step in this tutorial but when I get to step 9, the tutorial shows this:
drwxr-xr-x 6 oracle dba 4096 2007-09-18 18:50 database
oracle@hardy:~$ cd database
oracle@hardy:~/database$ ls -l
total 28
drwxr-xr-x 11 oracle dba 4096 2007-08-06 16:02 doc
drwxr-xr-x 5 oracle dba 4096 2007-08-03 13:28 install
drwxr-xr-x 2 oracle dba 4096 2007-09-18 18:52 response
-rwxr-xr-x 1 oracle dba 2911 2007-08-03 13:28 runInstaller
drwxr-xr-x 14 oracle dba 4096 2007-08-03 13:27 stage
-rw-r–r– 1 oracle dba 4835 2007-08-06 18:19 welcome.html
oracle@hardy:~/database$ ./runInstaller -ignoreSysPrereqs
But mine shows the root root instead of oracle dba:
drwxr-xr-x 6 root root 4096 2007-09-18 18:50 database
oracle@hardy:~$ cd database
oracle@hardy:~/database$ ls -l
total 28
drwxr-xr-x 11 root root 4096 2007-08-06 16:02 doc
drwxr-xr-x 5 root root 4096 2007-08-03 13:28 install
drwxr-xr-x 2 root root 4096 2007-09-18 18:52 response
-rwxr-xr-x 1 root root 2911 2007-08-03 13:28 runInstaller
drwxr-xr-x 14 root root 4096 2007-08-03 13:27 stage
-rw-r–r– 1 root root 4835 2007-08-06 18:19 welcome.html
oracle@hardy:~/database$ ./runInstaller -ignoreSysPrereqs
And in turn, I can’t install oracle. Also, I get this error:
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 80 MB. Actual 28599 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1466 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…
After the above error I get:
Can’t connect to X11 window server using ’192.168.43.129:0.0′ as the value of the DISPLAY variable.
Please help me out, I’ve been trying to solve this problem for weeks now. But I’m just not finding the solution. I am a newbie at ubuntu (LINUX) but I’ve learned quite a lot in the past few weeks of trying to solve this.
@Jude
It looks like you didn’t get line 18 from step 7:
17 root@hardy:~# mkdir /home/oracle
18 root@hardy:~# chown -R oracle:dba /home/oracle
You need to CHange OWNership of the directory. Try this, it might take care of your other problems.
Thanks Pythian, installation went fine. I created the database using dbca (it took forever but it did finish).
My major issue was not being able to access it from another machine, but I finally found the problem;
listener.ora was missing the SID_LIST_LISTENER section!
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.105)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
(SID_NAME = heron)
)
)
Thank you for such a nice tutorial.
I’m installing Oracle 11g on my local machine following the instructions above, I got the following errors after runInstaller.Then I have to run xhost + under my original login, and export DISPLAY=:0 under Oracle login, then OUI started runing.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-07-30_09-00-38PM. Please wait …
DISPLAY not set. Please set the DISPLAY and try again.
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.
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
This is a nice detailed tutorial. I am new to Ubuntu and Linux. Ubuntu came installed on my laptop.
I would like to install 11g. I have questions on some of the steps.
For Step 2:
How do I go about verifying the hashes of the downloaded image?
I was going to download the following 11g install file:
Oracle Database 11g Release 1 (11.1.0.6.0) for Linux x86
linux_x86_11gR1_database.zip (1,844,572,234 bytes) (cksum – 302838609).
Is this the correct one?
For Step 3:
In Windows, to check the IP address I typed ipconfig.
In Ubuntu, how do I check my IP address?
In this step you also reference the host as “note”. Where do I find the host name for my machine?
For Step 4:
I’m confused as to how the connection is being made to “hardy”. I see the first set of commands which I believe is my username and password. Then, all of a sudden I see commands that are connected to “hardy”.
Where are the commands for the actual connection to be made?
@Helen,
On your Ubuntu box you can use md5sum filename and cksum filename on step 2. On any Linux box, you find out how your network interfaces are set up by running ifconfig (step 3). The command for the “actual connection” to be made is actually the first line: ssh user@192.168.x.y, where 192.168.x.y is the IP address of your Ubuntu box. I guess you\'re trying to install Oracle on your own notebook, right? Just skip the ssh part of this tutorial (but keep the export DISPLAY and other IP-related stuff).
Cheers!
@Bob,
Please double-check your command-line for typos:
bott@mybox:~$ echo $DISPLAY
:0.0
bott@mybox:~$
Cheers!
Thank you for the reply.
For step 2; all I have to do is go to a terminal window – type md5sum <the name of the file I’m downloading from Oracle). Am I correct?
I am installing Oracle 11g on my laptop. Which steps should I be doing to get Oracle installed? You mentioned to skip the ssh part. I guess I skip step 4 and step 5.
I have the same problem as Bob, I did the echo $DISPLAY and it displays :0.0, also I tried using my IP address ‘DISPLAY=192.168.43.129:0.0; export DISPLAY’ and it displays ’192.168.43.129:0.0′ when I type echo $DISPLAY but I still get the same error as he has. Also, when I’m logged in as another and run the Installer it works fine it shows the installer dialog and everything but then the user is not oracle so I could not do anything to the database. Any ideas out there?
Also, when I run the Installer I get the ff error:
Checking Temp space: must be greater than 80 MB. Actual 28724 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1466 MB Passed
Checking monitor: must be configured to display at least 256 colors >>> Could not execute auto check for diplay colors using command /usr/bin/xdpy info. Check if the DIPSLAY variable is set. Failed<<<<
When I use a different account the third check Passes but then when I’m logged in as Oracle it Fails.
@Bob,
The xhost + helped a lot. Thanks mate.
instructions worked fine..however, after reboot I’m unable to connect. Any ideas why
@Helen,
What I meant exactly is: you can skip the SSH part. Do not skip steps 4 or 5, otherwise your setup will most likely fail. Regarding md5sum and cksum, I’d suggest reading the man page for those commands.
Cheers!
@Jude,
Are you sure you’re using bash and not dash(step 6)?
Cheers!
@Ruben,
Did the database started on boot? Try logging in as the oracle user, then running SQLplus as SYSDBA and typing startup.
Cheers!
On step nine
I used this to set up the display
$ DISPLAY=:0.0 ; export DISPLAY
I finally found a block of time where I can attempt this 11g install. In following your instructions, I have a few questions.
I downloaded the 11g zip file and unzip it into a directory on my machine. Your instructions don’t mention unzipping. I am guessing that is what I should do.
1.) I checked for my IP address and received the following: 192.168.1.103. Would this be valid? When I ran ifconfig; I had quite a few. So, I was trying to grab the address which appears similar to your instructions above.
2.)In Step 3: you start off with bott@note and then you are at user@note. How do you get from bott to user? I know that bott is replaced with my username. I’m running an X terminal on the same PC so I don’t think I need to do the xhost piece.
3.)In Step 4: when I type ssh @; the ssh is not recognized. How do I deal with this? When I get ssh to run; I believe the password I enter is my password not for “user”?
4.)Also, in Step 4: once the connection is made after entering the password; I’m supposed to see user@hardy prompt. At this prompt, I type sudo su – and then get prompted for a password. What is the password for pythian:?
5.)Still in Step 4: once I enter the password for pythian; the next prompt I see is root@hardy. How am I getting from “user@hardy” to “root@hardy”?
Can you clear things up for me?
I downloaded the 11g zip file and it downloaded onto my Desktop. I completed step 7 and created the /home/oracle directory.
When I try to unzip the file into /home/oracle, I receive an error message. The details for the error message state that I do not have permission to this directory.
I logged out and tried to login as the oracle user. When I enter the password; I get a message stating that the username and password are incorrect.
I went to my terminal window and type ls to see my directories. The home/oracle does not appear.
When I open File Manager in my GUI, the /home/oracle directory appears in my File System area. The zip file is in the Desktop area.
At this point, I’m not sure:
a.) why my username, oracle, and the password won’t work (they are both the same)
b.) how I can unzip my file into the /home/oracle directory
c.) how I can find my /home/oracle directory in the terminal window
Thanks for the help.
How do I verify that I’m using bash and NOT dash. But I know I did every step in step 6 and had EXACTLY the same output.
Also, I was wondering in Step 7:
I had typed line 14 and line 23 as one long line of code. I’m not sure if that is right.
Line 14:
useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
and
Line 23:
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
Any Ubuntu Guru’s out there that can help me out. It’s been weeks that I’ve tried to install Oracle 11g. Should I just start fresh from downloading to installation again?
@Helen,
Regarding your latest questions:
a) trying to log in as the oracle user will fail as we locked the account with passwd -l oracle. You should login as your user and then run sudo su - to become root, then su - oracle to become the oracle user (they you’ll have permission to write files on foldes belonging to that user.
b) you can unzip a file by installing the unzip package (use apt-get install unzip). Then, use unzip filename.zip.
c) if you’re logged in as the oracle user, typing cd will change your current directory to /home/oracle(or whatever you set as the oracle user home directory).
Cheers!
@Jude
To verify if you’re usig bash or dash, you should check the ouput of ls -l /bin/sh. I didn’t execute myself your useradd/usermod transformation, but I believe the syntax is correct. Line 23 seems OK as well.
Cheers!
!!!!!!!!! THANK YOU !!!!
I spent countless hours trying to install oracle10g / 11g on my Ubuntu desktop and I found your howto.
Thank you so very much, i am ready to learn linux and oracle.
If i every get my oracle dream job, I definitely have to mention to my employer that your howto is how I got started.
Thanks again.
when I type ls-l /bin/sh i get the output:
lrwxrwxrwx 1 root root 4 2008-07-25 09:58 /bin/sh -> bash
is that right?
i’m losing hope here.. :(
I might end up dropping ubuntu.
Hi Augusto,
Thanks for your tutorial. I am installing the oracle 11g on Ubuntu 8.04. server which is on my Toshiba laptop. Am new to both oracle and Ubuntu. My problem is when the OUI gets to finish the terminal i used to do the installation locks on:
rpm: To install rpm packages on Debian systems, use alien. See README.Debian.
error: cannot open Packages index using db3 – No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
After I rebooted my laptop i dont get Oracle among my main ubuntu menu.
Can you please help me resovle it
thx a lot
Dominic
@Jude,
Yes, that’s the expected output: sh being a symlink to bash. I can only suggest that you retrace your steps closely. After all, ‘The devil is in the details’ is what the the popular proverb says…
Cheers!
@Dominic,
Unfortunately, this howto doesn’t provide any means of having the Oracle software on the Ubuntu menu. I do suggest that you take a look at tools like TORA and SQL Developer.
Cheers!
Hi Bott,
I installed the DB fine, and run the last script ( update-rc.d oracledb defaults 99 ) fine?
But after that i was trying to use DBCA command as oracle user and is not letting me create the DB. Also the terminal i have used to do the installation is having this :
rpm: To install rpm packages on Debian systems, use alien. See README.Debian.
error: cannot open Packages index using db3 – No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
I dont know exactly if this is the reason for wich I can not create the DB
thx a lot
CHANDU
Hi Augusto,
Thanks for answering my question. I also have the same issues just as Chandu does.I installed the Oracle 11g fine, and run the last script ( update-rc.d oracledb defaults 99 )
But the terminal i have used to do the installation is having this :
rpm: To install rpm packages on Debian systems, use alien. See README.Debian.
error: cannot open Packages index using db3 – No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
after which the terminal locks. This then those not make it possible for me to creat the DB using DBCA command.
Can you help please.
Thx a Lot
Dominic
Hi Augusto,
Thank you for the info about logging as oracle. I will give it a try.
I’m having another issue with Ubuntu. I’m not sure if you would be able to help me out.
For some reason, I am unable to connect to the internet with my wireless card. Any thoughts as to how I can go about troubleshooting this?
Thanks.
I have uninstalled Oracle 11g and installed oracle 1og. I went through that STEP by STEP and did not encounter any issues. I have been able to create the DB as well. Thanks
Dominic
Excellent HOWTO.
For those running into
error: cannot open Packages database in /var/lib/rpm
You might want to try (as root):
# mkdir /var/lib/rpm
# rpm –rebuilddb
I am still getting the DISPLAY issue. I did set the DIPSPLAY=:0.0 as i am installing on my own machine but still didn’t work. I even tried with my IP address but it still gives me error. xclock works if i sign in as another but when i use oracle user the display does not seem to work. Anyone, Please help me with this.
I am installing oracle10gR2 on UBUNTU 8.04
Here the error that i get-
~/database$ ./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-09-03_09-27-32PM. Please wait …oracle@echoes:~/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 ‘:O’ as the value of the DISPLAY variable.
:O
:O
OUI-10025:Unable to start an interactive install session because of the following error:Can’t connect to X11 window server using ‘:O’ 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’
I appreciate the time and effort that you put into this tutorial. I do have one suggestion. Could you detail the Database creation and what each feature should be enabled? Also during the Database creation, received error message that Enterprise Manager cant be installed due to ports not being available. Is this a problem that you have seen before or know of a solution? I am not at my computer at the moment and dont have the exact error message at hand.
Hi,
If you get the error “Can’t connect to X11 window server” it is probably (correct me if I’m wrong) because you are trying to install the server on the same machine as you are trying to run the installer/get the 11g X installer. In his excellent howto, I suppose that Augusto uses 2 machines, both configured with Ubuntu 8.0.4: one as server and the other one as the client from which he is installing 11g
In our case we are doing all from the same machine. Instead of performing step nine, we simply rebooted the machine and logged on as the user “oracle” in de gdm interface. Open a terminal window, navigate to the “database” directory and run the “./runInstaller -ignoreSysPrereqs” command.
Hope this helps.
C.
hi,
tutorial is excellent. I was trying to install in my pc running in ubuntu. (32 bit)
But I’m struck coz after I executed step 8, and reboooooted, I’m no more able to login as anyuser (root, oracle)via terminal ctrt-alt-Fn. however, I’m able to logon via xserver terminal.
I believe this is since the kernel has been upgraded with step 5.
anyone got suggestions. It’s definetly a silly mistake as xserver-terminal logon works but the other doesn’t..
Echoes you need to add the following file:
cat > /etc/redhat-release << EOF
Red Hat Enterprise Linux AS release 3 (Taroon)
EOF
That should fix your problem.
As for mine, I can’t get X11 to work properly. I’ve tried to set the display but that doesn’t work. Is there anything else I should try?
Thanks.
echoes,
logon to the terminal as the user who can display xclock, then type:
hardy:~$ xhost +
you’ll get the below message
access control disabled, clients can connect from any host
now connect as root, su – oracle and xclock, it would work.
Thanks for the suggestions guys!!!
xhost+ solved the problem. Thanks a lot Oldbarrel.
Hello Friends…
For those of you struggling to know the type of SHELL you are using by default… Just use chsh command (chsh is actually a program) on your Command Terminal. This command not only shows you your default current SHELL program, but also enables you to change it in just one go… For Example -
The code
===================================================
root@ViNux:~# chsh
Changing the login shell for root
Enter the new value, or press ENTER for the default
Login Shell [/bin/dash]:
here it shows that the current Login Shell is dash. Just hitting the ENTER key will take you back to your prompt without changing the SHELL.
Now to change the SHELL from dash to bash, just do the following:-
1). Change the Shell to bash
==================================================
root@ViNux:~# chsh
Changing the login shell for root
Enter the new value, or press ENTER for the default
Login Shell [/bin/dash]: /bin/bash
root@ViNux:~#
Again executing chsh will show you your default (changed) Login SHELL, which now happens to be bash. Just have a look below-
2). Confirm the change you’ve made
===================================================
root@ViNux:~# chsh
Changing the login shell for root
Enter the new value, or press ENTER for the default
Login Shell [/bin/bash]:
–> But remember you need to be logged in as O/S user root.
Hope this helps.
Vicky.
And yes… You can use chsh command as any other normal O/S user as well. But in some cases you might be prompted to enter that user’s password, and I think it should not be a big deal for you, if you know it. Rest every thing goes same to same as mentioned above here.. :-)
Take care.
Vicky.
OMG, for some reason using “” to enclose string remarks makes things disappear on this blog. So, here is the complete post. Sorry for the inconvenience
Hello Friends…
For those of you, who are facing problems with xhost and DISPLAY,
I would suggest you to shutdown your system, reboot it and then Login using the Oracle user.
Once you are logged in open your command terminal and then start doing your rest of the installation. If for any reason this doesn’t works, login as ‘su – oracle’ and start moving forward with your Oracle installation (ofcourse, you surely need to have proper permissions on the folder containing your unzipped Oracle software binaries, i.e. the “database” folder)
Once you’ve installed Oracle software and want to work with tools like DBCA, NETCA and lsnrctl etc., to create or manage your Database, you might also have to add the following lines in the /home/oracle/.profile file
export ORACLE_BASE=(Path to your Oracle Base directory)
export ORACLE_HOME=(Path to your Oracle Home directory)
export PATH=(Path to you Oracle Bin Directory)
export ORACLE_SID=(SID of your oracle Database)
The above solved my issues, I hope it helps you as well.
Take care.
Vicky
Hey Augusto, excellent tutorial. Worked like a charm for 10g2 as well. I do have a wishlist of sorts, I was wondering if you or anybody knows of a step by step guide to installing oracle developer suite 10.2.0.1 on Ubuntu. Any help wil be greatly appreciated.
Thanks
Hamood
Augusto,
Thanks for the great tutorial. I followed it to the letter, including using the defaults, and it worked perfectly. Installed 11gR1 on Hardy 8.04 Server.
I used the startup scripts at http://radiofreetooting.blogspot.com/2008/06/installing-oracle-10g-on-ubuntu-hardy.html – another good tutorial which references yours.
I like the Enterprise Manager Web UI to start at boot-time, so in the startup scripts from the radiofreetooting site, a few simple mods will start it up at boot time:
1.) Set your ORACLE_SID environment variable at the top of the script, just under the commented-out header:
export ORACLE_SID=
2.) In the “start)” section, just below the other two lines starting with “su $ORACLE_OWNR…” place the following line:
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/emctl start dbconsole”
3.) In the “stop)” section, just *above* the other two “su $ORACLE_OWNR…” lines, place the following line:
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/emctl stop dbconsole”
That’ll give you a clean startup and shutdown of the EM Web UI every boot/restart.
Cheers!
Dave
Hey Vicky,
Thanks for the CHSH stuff. It worked for me and also easy to use.
Thanks.
SU.
For people having problem with Display (Thanks for the link Bart)- according to the reference, this is what i did:
- changed user to oracle:
$sudo su – oracle
- export DISPLAY variable to “:0″:
$ export DISPLAY=:0
- Assign x-host privileges
$ xhost local:oracle
Now it works fine.
Again, thank you very much, Bart
Umut
Thanks for this great tutorial I’ve installed Oracle 11g on Ubuntu 8.0.4.1.
My only issue is that after a while (few days) my machine is frozen. I can’t access it via SSH nor physically. It doesn’t respond. The only way to make it working is physically reboot it.
Any idea how I can find the cause of this issue?
Thanks.
Pingback: Intern News « Australia abroad
install successful. but when type sqlplus in console, got error.
sqlplus command not found ..
NEED HELP !!! also would like to know how to connect from windows ?
thx in advance
@mike,
Have you installed the Oracle client on your Windows box?
Cheers!
My install SEEMS to be OK, but I can’t establish a jdbc connection from my server. I created a user, zls, on my orcl instance and can log into sqlplus the following way: sqlplus zls/zls@orcl. However, if I try to do the following: “connect orcl” and then type the username/password at the prompts, the logon fails. I am also failing when I try to jdbc connect from my server (probably for this reason). The same holds true for scott/tiger. I can log on with the command line string, but not at the username/password prompts. Any ideas?
@Marcia,
User account scott is locked by default. You should execute ALTER USER SCOTT ACCOUNT UNLOCK; to be able to use it. Hope this information helps.
Cheers!
I’m getting below shared libray error for oracle user.
root@manojankk:/home/oracle# su – oracle
Your account has expired; please contact your system administrator
su: User account has expired
(Ignored)
.bash_profile executed
oracle@manojankk:~$ echo $LD_LIBRARY_PATH
/u01/app/oracle/product/11.1.0/db_1/lib:/lib:/usr/lib:/usr/local/lib
oracle@manojankk:~$ ls
ls: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
Hi,
I ‘m geeting below error when I’m trying to create a database using dbca command:
ls: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
Any help appreciated
Manoj
First of all, the tutorial is great! I can imagine the effort that went into it… everything worked fine up and until I try to run “./runInstaller” from the “/$ORACLE_HOME/database” directory and am getting the following after the TMP, SWAP, and DISPLAY checks pass:
Starting Oracle Universal Installer…
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-11-02_11-20-42AM. Please wait …sh: /u01/app/oracle/database/install/unzip: No such file or directory
I have tried everything I can think of…unzipping again to a different location, running the install script a different users, checking permissions on the directories (rw for all, rwx for owner and user). I even ran ‘unzip’ without any parameters and it worked fine. It doesn’t seem to be seeing the file it is suppoed top be unzipping.
Is there another way to perform this task outside of the ‘runInstaller’ script?
Thanks!!!
opus
Thanks alot bott, it works on my machine
Hello All,
I tried to use this tutorial to install Oracle 11g on Debian (amd64 version), and ran into I problem I can’t seem to be able to just google out. Namely halfway through the installation I get the followin error:
> OUI-10053:Unable to generate temporary script: /usr/share/oracle/inventory/orainstRoot.sh. Unable to continue install.
I’ve double checked, that there is enough space on disk and the priviledges are ok. Otherwise I’m implementing the tutorial. Any ideas what might be wrong?
Regards
Hi,
I just followed this wonderful tutorial again, installing Oracle 11g 32bit on Ubuntu 32bit on the second machine.
Thanks Augusto!
Pingback: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex
Excellent and flawless instructions! Thank you, you’ve made our lives a lot easier. Another successful install in Ubuntu 8.04.1!
Pingback: Installing Oracle 11g on Ubuntu 8.04 LTS (Hardy Heron)
I installed oracle 11g on ubutnu 8.04. Installation went fine. Listener is up, emctl dbconsole is running, emctl agent is running. But when I try to open web browser to get ot em, i get a blank page.
http://localhost:1521
http://localhost:1521/em
any help is appreciated.
thanks
i recently installed oracle database grid control (10.2.0.1) in my pc running on ubunty hardy. listing the steps here, might someone would find it helpful. I heavily depended on internet, python pages in particular to get it done. it’s actually a straight forward task if all the preparation has been done. however i had missed out certain things and faced issues and had to sit and find a workaround all the time.
If you already have a database installed like me (11g) then you would have taken care of all the kernel parameters and most of other setup required for the installation. If you do not have any database in you system yet and it’s not configured for any oracle installtion, then follow step 1 to step 9 as explained by augusto bott immediately.
11g grid control is not available yet. so the latest available as of now is 10g Grid Control Release 4 (10.2.0.4), which is also the only one that can use a 11g database as repository.
But you cannot directly install 10.2.0.4. Instead you got to install 10g Grid Control Release 2 (v10.2.x) and patch it up to 10.2.0.4, which also means you need to have a 10g database. if you already have a 10g database, well and good, you may use that as repository. the only one available in my pc was 11g, so I had to install the starter database available with grid control install…
if you got metalink access, check the grid control matix at doc id 412431.1
now lets get started:
step 1
in addition to step 1 to step 9 of Augusto’s steps you would have followed, you’ll need the library libdb.so.2 in /usr/lib for successful configuration of assistants – otherwise the installation of ‘Web Cache Configuration Assistant’ is bound to fail. check for it:- ls -ltr /usr/lib/libdb.so.2
if it’s not availble do the below steps:
a) the library is availble in the package compat-db-4.1.25-9.i386.rpm
download it: you may google for ‘download compat-db-4.1.25-9.i386.rpm’ or you can use the link http://rpm.pbone.net/index.php3/stat/4/idpl/1881575/com/compat-db-4.1.25-9.i386.rpm.html
b) install pax if you do not have it already
sudo apt-get install pax
c)unpack the rpm package (go to the directory where you download it and then)
cat compat-db-4.1.25-9.i386.rpm | rpm2cpio | pax -r
d) copy the file ‘libdb1.so.2′ unpacked in the current_directory/usr/lib to /usr/lib and also create a link namely libdb.so.2
cp current_directory/usr/lib/libdb1.so.2 /usr/lib
cd /usr/lib
ln -s libdb1.so.2 libdb.so.2
step 2
create directories for database, oms and agent installation. My oracle_base is /home/oracle/product. so I create a directory inside it as 10.2.0 .within that I created directories db10g, oms10g and agent10g
so the oracle_home for my new repository database is like /home/oracle/product/10.2.0/db10g. oms and agent directories are /home/oracle/product/10.2.0/oms10g and /home/oracle/product/10.2.0/agent10g respectively.
set up your profile for oracle_home, base and path of grid repository accordingly
step 3
download the grid control zip files from oracle.com and unzip it. Oracle Enterprise Manager 10g Grid Control Release 2 (10.2.0.1) for Linux x86
unzip Linux_Grid_Control_full_102010_disk1.zip
unzip Linux_Grid_Control_full_102010_disk2.zip
unzip Linux_Grid_Control_full_102010_disk3.zip
step 4
set up the DISPLAY variable. (you will need to provide remote access with accordingly (xhost). Augusto has explained it beautifully)
step 5
start the installer as
./runInstaller -ignoreSysPrereqs
and that’s it. it would install the repository then oms and the agent and prepare all configuration assistants one after the other.
with my 1GB ram, the installation took an hour and 30 minutes.
in the end, you would find the log listed with all the necessary information to get along with grid control activities.
Errors:
do not worry about the absence of glibc when you start the installer. Hardy already has libc6 and things should work fine. we are ignoring system pre req for this. just check the box to make it ‘verified’ and go ahead
during the installation, you will get a pop up saying that it’s not able to find the list of running process, click continue. then again it would say something similar to ‘cannot start an agent’ (well almost… i forgot the exact message) – this is since it’s trying to start opmn process, which is already running. So feel comfortable to click continue and you should get to the end of installation without issues.
if your oms or agent installation faces issues which looks prima facia difficult to resolve, the best option is to just reinstall these again later.
Cheers,
Oldbarrel
Thanks for helping out, Oldbarrel!
Thanks for these instructions. I installed oracle 11gr1 on ubuntu intrepid ibex. I also had oracle xe installed, so the installer balked at overwriting the /etc/oratab. This was not a big deal and I just added a line manually to the file.
you need run this command for install also:
# cd /home/oracle/database/install
# pwd
# /home/oracle/database/install
# mv unzip unzip+
# ln -s /usr/bin/unzip unzip
# ls
total 224
-rwxr-xr-x 1 oracle oinstall 28 2007-10-16 22:57 addLangs.sh
-rwxr-xr-x 1 oracle oinstall 76 2007-10-16 22:57 addNode.sh
-rwxr-xr-x 1 oracle oinstall 276 2007-10-16 22:57 attachHome.sh
-rwxr-xr-x 1 oracle oinstall 182 2007-10-16 22:57 detachHome.sh
drwxr-xr-x 2 oracle oinstall 4096 2007-10-16 22:57 images
-rwxr-xr-x 1 oracle oinstall 47926 2007-10-16 22:57 lsnodes
-rwxr-xr-x 1 oracle oinstall 2818 2007-10-16 22:57 oneclick.properties
-rwxr-xr-x 1 oracle oinstall 1798 2007-10-16 22:57 oraparam.ini
-rwxr-xr-x 1 oracle oinstall 6437 2007-10-16 22:57 oraparamsilent.ini
drwxr-xr-x 2 oracle oinstall 4096 2007-10-16 22:57 resource
drwxr-xr-x 2 oracle oinstall 4096 2007-10-16 22:57 response
-rwxr-xr-x 1 oracle oinstall 21642 2007-10-16 22:57 runSSHSetup.sh
lrwxrwxrwx 1 root root 14 2009-01-13 12:27 unzip -> /usr/bin/unzip
-rwxr-xr-x 1 oracle oinstall 102612 2007-10-16 22:57 unzip+
i did everything in the tutorial and when executing th runistaller i got this..
oracle@pvidal-desktop:~/database$ ./runInstaller -ignoreSysPrereqs
./runInstaller: line 86: /home/oracle/database/install/.oui: Permission denied
I just typed this : “ls -l” and here is the result of this:
oracle@pvidal-desktop:~/database$ ls -l
total 28
drwxr-xr-x 11 oracle dba 4096 2009-02-18 16:06 doc
drwxr-xr-x 5 oracle dba 4096 2009-02-18 17:13 install
-rw-r–r– 1 oracle dba 124 2009-02-18 16:06 README
-rwxrwxrwx 1 oracle dba 2911 2009-02-18 16:06 runInstaller
drwxr-xr-x 14 oracle dba 4096 2009-02-18 16:15 stage
-rw-r–r– 1 oracle dba 4835 2009-02-18 16:15 welcome.html
im not sure what happens plz help…
Paul S.
Hey Paul,
.iou is in install. You can switch to root
sudo su -
then make .iou executable
chmod +x /home/oracle/database/install/.oui
and try you installation again
Hope it helps
I have another problem
i have no .oui file in my install folder !
oracle@host:/data/oracle/database$ ls -l install
total 188
-rwxr-xr-x 1 oracle oinstall 28 2010-08-12 15:36 addLangs.sh
-rwxr-xr-x 1 oracle oinstall 76 2010-08-12 15:36 addNode.sh
drwxr-xr-x 2 oracle oinstall 4096 2010-08-12 15:36 images
-rwxr-xr-x 1 oracle oinstall 46448 2010-08-12 15:36 lsnodes
-rwxr-xr-x 1 oracle oinstall 2268 2010-08-12 15:36 oneclick.properties
-rwxr-xr-x 1 oracle oinstall 2387 2010-08-12 15:36 oraparam.ini
-rwxr-xr-x 1 oracle oinstall 6428 2010-08-12 15:36 oraparamsilent.ini
drwxr-xr-x 2 oracle oinstall 4096 2010-08-12 15:36 resource
drwxr-xr-x 2 oracle oinstall 4096 2010-08-12 15:36 response
-rwxr-xr-x 1 oracle oinstall 102612 2010-08-12 15:36 unzip
oracle@host:/data/oracle/database$
i dont know what to do
thanks 4 your help
Can anybody tell how to install oracle 11g on Ubuntu 8.04 LTS server edition for 64bit? I tried to install, but it result in lot or errors.
Thanks in advance
Charly
Hi All,
I am getting the following error while invoking dbca. Any thoughts highly appreciate.
Cheers
Joel
oracle@joel:~$ dbca
UnsatisfiedLinkError exception loading native library: njni11
Exception in thread “main” java.lang.UnsatisfiedLinkError: get
at oracle.net.common.NetGetEnv.get(Native Method)
at oracle.net.config.Config.getNetDir(Unknown Source)
at oracle.net.config.Config.initConfig(Unknown Source)
at oracle.net.config.Config.(Unknown Source)
at oracle.sysman.assistants.util.NetworkUtils.(NetworkUtils.java:237)
at oracle.sysman.assistants.util.step.StepContext.(StepContext.java:267)
at oracle.sysman.assistants.dbca.backend.Host.(Host.java:731)
at oracle.sysman.assistants.dbca.ui.UIHost.(UIHost.java:234)
at oracle.sysman.assistants.dbca.ui.InteractiveHost.(InteractiveHost.java:54)
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:160)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)
@Joel,
Please double-check if you have libaio properly installed as just looks like a JNI error (Java Native Interface).
Cheers!
Still installing… just wanted to thank Bob for xhost +. I strongly advise the author of the article to incorporate Bob’s workaround to that problem.
I have to go along with everybody else in saying What a great Howto, Augosto!
I have one comment+workaround and one issue.
I found that right near the end of running the installer, the root.sh script was failing – I suspect it is because it was wanting to edit the file /etc/inittab, which it seems is no longer present in Ubuntu 8.04. I fooled it by creating a inittab file copied from an older installation on a different machine, and the installer then ran to completion.
But I still have a problem – when I run dbca, it goes through 11 steps of twelve but the puts up an alert ‘ORA-27102: Out of memory’. I really do not believe that it /is/ out of memory.
The terminal window from which dbca is run shows shed loads of java stack trace stuff:
Locking assertion failure. Backtrace:
#0 /usr/lib/libxcb-xlib.so.0 [0xa8d00767]
#1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_lock+0x2e) [0xa8d0081e]
#2 /usr/lib/libX11.so.6 [0xa5915518]
yada yada but I do not see any reference to Out Of memory in there.
Nothing in …assistants/dbca/logs.
The SID is ‘mymeter’. Some sql scripts have been created in admin/mymeter/scripts and a shellscript file mymeter.sh, but that has evidently not yet been run, because it ends with a ‘add this entry in oratab’ message which I have not seen.
I do see an alert_mymeter.log file in admin/mymeter/bdump/, saying
Thu Apr 2 14:14:05 2009
Starting ORACLE instance (normal)
The Out of memory msg appears in
/u01/app/oracle/Home/admin/mymeter/create/CreateDB.log
If I try and run the CreateDB.sql script manually, (it is in /u01/app/oracle/Home/admin/mymeter/scripts/ , generated by dbca) I can’t get in:
SQL> connect SYS/&&sysPassword as SYSDBA
Enter value for syspassword: mySecret!
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
This seemed to be going so nicely, it’s a shame to be stuck here…
Hi,
if the dbca confirmation window is blank, try this:
Disable all Visual effects by setting Visual Effects to None.
(I had it set to Normal and had the same symptoms as above.)
On Ubuntu:
System -> Preferences -> Appearance.
Tab: Visual Effects
Thanks a lot!!
You helped me to successfully install Oracle 11 on Ubuntu 9.04.
Cheers…Keep up the good work!!
Pingback: Memasang Oracle 11g di VirtualBox « perihal
Pingback: Installing Oracle 11gR1 on Ubuntu 9.04 Jaunty Jackalope | Pythian Group Blog
Hi
Do you have the full list of package dependency for oracle 11g?
It would be very helpful for those who aren’t using Ubuntu but other distros
thanks
i installed ubuntu desktop 9.04 x64
>>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
fix it:
upt-get install sux
sudo sux -
sux – oracle
/tmp/OraInstall2008-11-02_11-20-42AM. Please wait …sh: /u01/app/oracle/database/install/unzip: No such file or directory
fix it:
cd ~/database
mv install/unzip install/unzip.backup
rm -rf install/unzip
ln -s /usr/bin/unzip install/unzip
After following all prep-steps as in the guide, I run installation including prereq-check.
Everything runs fine, exept tis error:
Actual Result: package glibc is not installed
Check complete. The overall result of this check is: Failed <<<<
Problem: Some recommended packages are missing (see above).
Since guide installs with ignoring prereq-check, can I really ignore glibc installation ?
In synaptic I found only glibc-source and doc.
since I am not a system-engineer, what shall I do with that ?
thanks for any tip, Laode
I am a true newbie on both linux and oracle on linux platform. This is a very helpful tutorial and finally I made it. Many thx!
i got error like this
Checking Temp space: must be greater than 80 MB. Actual 6685 MB Passed
Checking swap space: must be greater than 150 MB. Actual 253 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-07-17_12-19-56PM. Please wait …oracle@ubuntu:/media/Hari/Oracle/ORACLE11GLINUX$ 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.1.2:0.0′ as the value of the DISPLAY variable.
192.168.1.2:0.0
192.168.1.2: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.1.2: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’
what i do now? please mail me the correct solutions..
thanks in advance…
i am installing oracle 11g on ubuntu 9.04 version….
so please help me sir….
i am waiting for your reply mail….
Hi,
i used your description to install 11g on ubuntu 9.04 in a VirtualBox. All worked fine, you documented all very good an comprehensible. Thank you!
hi
i am new to ubuntu…i want to install the oracle 11g on ubuntu…all going well acording to the steps..then at step # 9..here the it asks me for password….i am confused wheather it is asking for root password or user passowrd..i tried different combinations but could not able to get the right password….it am saying again that i did all the steps which are present in the tetuorial so not getting that have given password to terminal while doing steps….because i donot know the logic behind many steps….plz help me out and tell me that he is asking for which password???
oracle@leo-desktop:~$ su – oracle
Password:
su: Authentication failure
..waiting for replay..
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 <<<<
i’ve got that error message while i’m installing oracle 11G on my ubuntu 8.10, what should i must do?
thanks
Hi,
before discovering this guide, I tried to install Oracle 11g on my Ubuntu Hardy, just by extracting the zip and running the installer (I was naive, I know). It ended in a disaster, of course.
Now, I’d like to install it again – this time using Your guide. Before that, I have to remove the broken install. But I don’t know what to do.
Can you please help?
Thank you
TG
Pingback: Die wichtigsten Links « Oracle 11g live
Dear sir,
it’s nice article. Can i used your article on ubuntu 9.04 and oracle 10.2 ?
Thanks before
Just followed this on Ubuntu 9.04 and everything worked quite nice. No problems to report. Thanks a lot!
guys i did all the steps:
now according to guide lines i m here
>sql
guys i m blind now…i dont know how to start oracle , make database and open it at my browser plz help me out
when i do
>sqlplus
it is saying shared memory not available help me plz
When you lock the passwd file with `passwd -l oracle’ you cannot access it with su (134.Bilal’s problem). You have to unlock it with `passwd -u oracle’.
Regards
Pingback: Installing Oracle BRM on Ubuntu « open-bss.com blog
Hi,
Its a good tutorial…
But I am not able to create database by using dbca as after 38% I am getting error.
ORA-01503:Create Controlfile fail
ORA-01565:error in identifying file ‘/u01/app/oracle/globaldb/system01.dbf’
ORA-27037:unable to obtain file status
at the same time when i look at the terminal it is giving me the message as..
rpm:To install rpm package on Debian System, use alien
erreo:Cannot open the package index in /var/lib/rpm
Plz anybody help me out to get rid of this problem because of this my whole installation is stuck foe database…
can anyone give me the solution for above problem plz plz….
Pingback: Installing Oracle 11g on Ubuntu 8.04 x86 - ivonko.com
This process has worked for me on many flavors of Oracle and Ubuntu. However, looks like Ubuntu 9.10 64 and Oracle 10.2 64 are a no-go due to linking problems
Pingback: links for 2009-11-25 « ?? ???;;;
I have problem
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)
Can u help me, Plss..
What can i do…
Same problem here on April 3, 2010. Any responses?
hi pythian, i so confuse…
in step six, i dont understand what mean : “Do not forget skip this step” ..can i skip this step???
Very nice howto, it also works on 11.2.0, for me at least as soon as I changed ORACLE_HOME to use that.
One question though: after I shut down oracle using the init script, I still have some processes that seem to be oracle’s:
diederick@myhost:~$ ps a | grep oracle
5868 pts/1 S+ 0:00 grep oracle
13885 pts/0 S 0:02 /u01/app/oracle/product/11.2.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/11.2.0/dbhome_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/dbhome_1/myhost.mydomain.com_testdb/sysman/log/emdb.nohup
13924 pts/0 Sl 0:31 /u01/app/oracle/product/11.2.0/dbhome_1/bin/emagent
18417 pts/0 S 0:00 su – oracle
26902 pts/0 Sl 2:22 /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -server -Xmx192M -XX:MaxPermSize=200M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 -Doracle.home=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/11.2.0/dbhome_1/myhost.mydomain.com_testdb/sysman -DEMSTATE=/u01/app/oracle/product/11.2.0/dbhome_1/myhost.mydomain.com_testdb -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_myhost.mydomain.com_testdb/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_myhost.mydomain.com_testdb/config/java2.policy -Djavax.net.ssl.KeyStore=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/11.2.0/dbhome_1/myhost.mydomain.com_testdb -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_myhost.mydomain.com_testdb/config/server.xml
How can I shut down every last bit of oracle without rebooting the machine?
I am having this error at ./runInstaller step. Can someone help please?
No protocol specified
Exception in thread “main” java.lang.NoClassDefFoundError
@kepada hari: dont forget.. do this step… System -> Administration -> Login Window on your client desktop (hardy)
hello world,
i found error like this on auto-start process:
“Failed to auto-start Oracle Net using /ade/vikrkuma_new/oracle/bin/tnslrctl”
any body can help? on my /etc/init.d/oracledb nothing text like that… who is ade vikrkuma_new?
I have troubles installing Oracle 11g R2 on my desktop machine. I am using Ubuntu 8.04 LTS. I have not sleep the entire night. Trying to figure out with no lucks. any helps and tips from the exports would be appreciated.
Please help…..
Thanks in advance!
Checking Temp space: must be greater than 80 MB. Actual 9267 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1953 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/OraInstall2010-08-27_06-58-26AM. Please wait …oracle@client01:/home/sithkong/Documents/Downloads/database$ No protocol specified
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)
Pingback: Carnets de Jean-Seb » Oracle sous Ubuntu 10.04
i followed the step line by line, but in the end, got this error cannot execute database/install/.oui
I have .oui in install
And it has execute permissions for all.
Can somebody help me please.
Hi, I had actualy downloaded the linux version for z, cursing oracle download page for the goof up.
Now getting the same exception as Ricky and all.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-14_09-02-28AM. Please wait …No protocol specified
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)
Looks like classpath/permission issue.
Please help
hi,
I was an engineer from ChinaWhen I oracle11g installed in ubuntu12.04,Following problems?Do you see any good solution?
Information: / usr / bin / ld: warning:-z lazyload is ignored.
/ usr / bin / ld: warning:-z nolazyload ignored.
/ usr / bin / ld: / home/xiaomu/software/oracle11g/server/sysman/lib / / libnmectl.a (nmectlt.o): undefined reference to symbol ‘B_DestroyKeyObject’
/ usr / bin / ld: note: ‘B_DestroyKeyObject’ is defined in DSO / home/xiaomu/software/oracle11g/server/lib/libnnz11.so so try adding it to the linker command line
/ home/xiaomu/software/oracle11g/server/lib/libnnz11.so: could not read symbols: Invalid operation
Information: collect2:
Information: ld Back 1
Information: make [1]: *** [/ home/xiaomu/software/oracle11g/server/sysman/lib/emdctl] Error 1
Information: make [1]: are leaving directory `/ home/xiaomu/software/oracle11g/server/sysman/lib ‘
Information: make: *** [emdctl] Error 2
Information: terminate the output from the derivative process.
Information: ———————————-
Information: operation throws an exception error: make
Exception Error Name: MakefileException
The exception error string: call makefile ‘/ home/xiaomu/software/oracle11g/server/sysman/lib/ins_emagent.mk’ target ‘agent nmhs’ error. For more information, please refer to the ‘/ home/xiaomu/software/oraInventory/logs/installActions2012-12-20_02-47-18PM.log’.
Exception Error Severity: 1
If you are going for best contents like myself, only visit this web page everyday for the reason that it provides quality contents, thanks