Hello, there! With another Ubuntu release, it has come the time to update our series of posts on how to install Oracle 11g on Ubuntu. If you’ve been following, we’ve been publishing updated howtos since Ubuntu 7.04:
- Installing Oracle 11g on Ubuntu 8.04 Hardy Heron LTS
- Installing Oracle 11g on Ubuntu 7.10 Gutsy Gibbon
- Installing Oracle 11g on Ubuntu 7.04 Feisty Fawn
In fact, in this article I refer several times to previous posts regarding some configuration aspects and why I chose particular values. Also, note that this series of posts is a work in progress and we were able to improve this series with your help. So please do post comment below as your collaboration is very much appreciated.
In this post, we’ll see the steps needed to install Oracle 11gR1 on an Ubuntu 8.10 Intrepid Ibex box all the way to creating your very first database. I’ve been working very hard to ensure that at every new post, the results you get when executing this procedure are as deterministic as possible, leading to a successful setup.
Please keep in mind that this is not a supported architecture, so pay special attention to the order in which I do things. Don’t rush and try to merge steps, as it took me a lot of attempts to make this setup work properly. There are some reboots and also there’s a specific order you need to do things, so please follow the instructions step-by-step and verify the the results of every single command.
Preparation
Let’s get down to it, shall we? The first thing to do is to get some files. We need an ISO image of Ubuntu (a CD/DVD will do) and one of Oracle 11gR1. Get Ubuntu 8.10 Server here; and Oracle 11gR1 here. (It’s free, but you have to register on the Oracle website to download it.)
It’s a good idea to check the md5sum of each image after downloading from the Internet.
- Here is the md5sum I calculated on the Oracle package:
a2ec9975a91e1228c8292ed9799dc302 ubuntu-8.10-server-i386.iso
I’m using VMWare Server for this article, since it’s very handy when you have to repeat the whole procedure several times until you get the proper sequence; also because it is free as in “free beer” (but not as in “free speech”—see https://vmware.com/products/server/). If you prefer, you can use a physical machine, Xen (https://www.xen.org/) or VirtualBox (https://www.virtualbox.org/) but I’m not covering those here.
I’ve installed a plain-vanilla x86 Ubuntu instance with 512 MB of RAM, but instead of creating a disk with the suggested defaults, I’ve created one single virtual disk with 16 GB instead, so I can be sure not to run out of disk space. During the installation, you should choose guided partitioning and no encrypted home directory, unless you know what you’re doing. Also, as we’re going to do everything remotely in this HOWTO, you will want to request the installation of a OpenSSH server in the last steps of the installation.
On the first boot, let’s check if we have everything we need, such as connectivity and sudo acccess.
[email protected]:~$ ssh [email protected] (...) [email protected]'s password: Linux ibex 2.6.27-7-server #1 SMP Fri Oct 24 07:37:55 UTC 2008 i686 (...) [email protected]:~$ sudo -l [sudo] password for pythian: User pythian may run the following commands on this host: (ALL) ALL [email protected]:~$ logout Connection to 192.168.x.y closed.
If you don’t have access to the box, review your installation, network addresses, etc. Let’s continue by updating every single package on the box:
[email protected]:~/Desktop$ ssh [email protected] [email protected]'s password: (...) [email protected]:~$ sudo su - [email protected]:~# apt-get update Hit https://security.ubuntu.com intrepid-security Release.gpg Ign https://security.ubuntu.com intrepid-security/main Translation-en_US (...) Get:7 https://security.ubuntu.com intrepid-security/multiverse Packages [14B] Get:8 https://security.ubuntu.com intrepid-security/multiverse Sources [14B] Fetched 6551B in 0s (7776B/s) Reading package lists... Done [email protected]:~# apt-get dist-upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done The following packages will be upgraded: (...) 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 24.7MB of archives. After this operation, 24.6kB of additional disk space will be used. Do you want to continue [Y/n]? y (...) Running postinst hook script /sbin/update-grub. Searching for GRUB installation directory ... found: /boot/grub Searching for default file ... found: /boot/grub/default Testing for an existing GRUB menu.lst file ... found: /boot/grub/menu.lst Searching for splash image ... none found, skipping ... Found kernel: /boot/vmlinuz-2.6.27-7-server Found kernel: /boot/memtest86+.bin Updating /boot/grub/menu.lst ... done (...) Processing triggers for libc6 ... ldconfig deferred processing now taking place [email protected]:~#
Since we had a kernel upgrade, reboot before continuing:
[email protected]:~#reboot (...) The system is going down for reboot NOW! [email protected]:~# Connection to 192.168.x.y closed by remote host. Connection to 192.168.x.y closed. [email protected]:~/Desktop$
After rebooting to change the kernel, let’s install all the required packages to continue:
[email protected]:~/Desktop$ ssh [email protected] [email protected]'s password: (...) [email protected]:~$ sudo su - [sudo] password for pythian: [email protected]:~# apt-get install gcc make binutils gawk x11-utils rpm alien ksh lsb-rpm Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: (... long list ...) Suggested packages: (... another long list ...) The following NEW packages will be installed: (... even longer list ...) 0 upgraded, 54 newly installed, 0 to remove and 0 not upgraded. Need to get 29.3MB of archives. After this operation, 93.0MB of additional disk space will be used. Do you want to continue [Y/n]? Get:1 https://us.archive.ubuntu.com intrepid/main gawk 1:3.1.6.dfsg-0ubuntu1 [500kB] Get:2 https://us.archive.ubuntu.com intrepid/main libdrm2 2.3.1-0build1 [260kB] (...) Setting up build-essential (11.4) ... Processing triggers for libc6 ... ldconfig deferred processing now taking place [email protected]:~#
Now we have all the packages we need, so let’s make sure we have all the requirements to run the Oracle Universal Installer as it was not designed to run on Ubuntu, but rather on Redhat-like systems). First, make sure Bash is your default replacement for sh:
[email protected]:~# cd /bin [email protected]:/bin# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2008-11-02 21:33 /bin/sh -> dash [email protected]:/bin# ln -sf /bin/bash /bin/sh [email protected]:/bin# ls -l /bin/sh lrwxrwxrwx 1 root root 4 2008-11-02 22:34 /bin/sh -> bash [email protected]:/bin#
Let’s create some users:
[email protected]:/bin# cd [email protected]:~# pwd /root [email protected]:~# addgroup oinstall Adding group `oinstall' (GID 1001) ... Done. [email protected]:~# addgroup dba Adding group `dba' (GID 1002) ... Done. [email protected]:~# addgroup nobody Adding group `nobody' (GID 1003) ... Done. [email protected]:~# usermod -g nobody nobody [email protected]:~# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle [email protected]:~# mkdir /home/oracle [email protected]:~# chown -R oracle:dba /home/oracle [email protected]:~# ln -s /usr/bin/awk /bin/awk [email protected]:~# ln -s /usr/bin/rpm /bin/rpm [email protected]:~# ln -s /usr/bin/basename /bin/basename [email protected]:~# mkdir /etc/rc.d [email protected]:~# for i in 0 1 2 3 4 5 6 S ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done [email protected]:~# mkdir -p /u01/app/oracle [email protected]:~# chown -R oracle:dba /u01 [email protected]:~#
Copy the unpacked Oracle 11gR1 to the box we’re working on:
[email protected]:~/Desktop$ scp -r database [email protected]: [email protected]'s password: (...)
And put our installation files in place:
[email protected]:~$ sudo su - [email protected]:~# mv /home/pythian/database /media/database [email protected]:~# chown -R oracle:oinstall /media/database [email protected]:~#
Let’s change some system-wide configuration files, starting with /etc/sysctl.conf:
[email protected]:~# cd /etc [email protected]:/etc# cp sysctl.conf sysctl.conf.original
Edit it, adding the following lines to the bottom of the file:
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 = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 262144
Then, let’s modify /etc/security/limits.conf:
[email protected]:/etc# cd /etc/security/ [email protected]:/etc/security# cp limits.conf limits.conf.original
Add the following lines to the bottom of the file:
oracle soft nproc 2047 oracle hard nproc 16383 oracle soft nofile 1023 oracle hard nofile 65535
The last one, for now, is /etc/pam.d/login:
[email protected]:/etc/security# cd /etc/pam.d [email protected]:/etc/pam.d# cp login login.original
Edit login, adding to it:
session required /lib/security/pam_limits.so session required pam_limits.so
I’m not completely convinced that a reboot is needed here (you probably could get away with sysctl -p as root and logging in again as your user) but I do recommend it, just to make sure we are on the same page. Doing so guarantees that we’ve cleaned up our memory and loaded at boot time all the changes we just did.
Oracle installation
Once our VM is back online. it’s time to become user oracle and to fire up the Oracle Universal Installer. Don’t forget to allow incoming connections on your X server with xhost +192.168.x.y. The IP address 192.168.w.z is the IP address of your X server.
[email protected]:~$ whoami pythian [email protected]:~$ sudo su - [sudo] password for pythian: [email protected]:~# su - oracle [email protected]:~$ export DISPLAY=192.168.w.z:0.0 [email protected]:~$ cd /media/database [email protected]:/media/database$ ./runInstaller -ignoreSysPrereqs Starting Oracle Universal Installer... Checking Temp space: must be greater than 80 MB. Actual 12037 MB Passed Checking swap space: must be greater than 150 MB. Actual 729 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-11-04_12-02-58AM. Please wait [email protected]:/media/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production Copyright (C) 1999, 2007, Oracle. All rights reserved.
The installer may throw errors at some point:
Locking assertion failure. Backtrace: #0 /usr/lib/libxcb-xlib.so.0 [0xa35067c7] #1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_unlock+0x31) [0xa3506891] #2 /usr/lib/libX11.so.6(_XReply+0x254) [0xa354e494] (...)
I ignored it and moved on with the installation. You should be able to finish your installation just as I did. The following screen will be presented:
I’ve selected group dba:
And asked the installer to proceed with the whole Enterprise Edition:
Note that we changed the name and location of our ORACLE_HOME to oraibex and /u01/app/oracle/product/11.1.0/oraibex:
Some of the product-specific prerequisite checks will fail, but we check each checkbox so the last column reads “User Verified” on all unchecked rows:
We will install software only now, nothing else:
And change the privileged OS groups to dba:
It will show us a summary, but the Next is greyed out, so we hit Install
And it will begin installing:
And we get a cup of tea:
And another cup of tea:
Until it asks us to execute a couple of scripts as root:
In case you’ve never done this before and want to know what it looks like, here’s the output I got:
[email protected]:~$ ssh [email protected] [email protected]'s password: (...) [email protected]:~$ sudo su - [sudo] password for pythian: [email protected]:~# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory to 770. Changing groupname of /u01/app/oraInventory to dba. The execution of the script is complete [email protected]:~# /u01/app/oracle/product/11.1.0/oraibex/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/oraibex 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. [email protected]:~#
At the end of the installation, the Oracle Universal Installer is kind enough to ask us for confirmation before leaving (you can click on “Installed Products” and review what was installed before leaving the installer:
Now, take note of two things, our ORACLE_BASE and our ORACLE_HOME as we’ll use them later:
ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/oraibex
We now have only the database software, but no database created yet. Let’s get moving and install the few extra packages needed to complete our installation. Please note that on several attempts, I’ve installed all the packages in the earlier step, but all those attempts failed; that’s why we’re installing it just before we actually need it (dbca will fail without those and the database won’t be created):
[email protected]:~# apt-get install libaio1 lesstif2 libmotif3 Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libxp6 The following NEW packages will be installed: lesstif2 libaio1 libmotif3 libxp6 0 upgraded, 4 newly installed, 0 to remove and 0 not upgraded. Need to get 1941kB of archives. After this operation, 4772kB of additional disk space will be used. Do you want to continue [Y/n]? Get:1 https://us.archive.ubuntu.com intrepid/main libxp6 1:1.0.0.xsf1-2 [16.7kB] Get:2 https://us.archive.ubuntu.com intrepid/multiverse libmotif3 2.2.3-2 [1283kB] (...) Setting up libaio1 (0.3.107-1ubuntu1) ... Processing triggers for libc6 ... ldconfig deferred processing now taking place [email protected]:~#
Create our startup/init script:
[email protected]:~# cat /etc/init.d/oracledb #!/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/oraibex 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
We will make it executable and tell the OS we want it started at boot time:
[email protected]:~# chmod a+x /etc/init.d/oracledb [email protected]:~# update-rc.d oracledb defaults 99 update-rc.d: warning: /etc/init.d/oracledb missing LSB style header 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 [email protected]:~#
Note: Do NOT reboot now.
Creating a database
Let’s install our first database with DBCA (DataBase Configuration Assistant).
[email protected]:~# su - oracle [email protected]:~$ export DISPLAY=192.168.w.z:0.0 [email protected]:~$ export ORACLE_HOME=/u01/app/oracle/product/11.1.0/oraibex [email protected]:~$ export PATH=$PATH:/u01/app/oracle/product/11.1.0/oraibex/bin [email protected]:~$ dbca (...some time will pass before you see anything -- be patient...) Locking assertion failure. Backtrace: #0 /usr/lib/libxcb-xlib.so.0 [0x9fc957c7] #1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_unlock+0x31) [0x9fc95891] (...)
Now, wait for a few moments, as dbca can take up to a couple of minutes to show this initial screen:
That’s right, we want to create a database:
A general Purpose or TransactionProcessing database, next:
And our SID will be intrepid:
But we don’t want to configure Enterprise Manager just now:
We want to use the same password for both SYS and SYSTEM accounts:
Nothing fancy, just plain filesystem for storage:
Let’s use the suggested template:
But no recovery area or archiving:
We don’t want the sample schemas or to execute any custom scripts at this time:
You can tune this if you want, but I’d suggest leaving it as-is unless you know what you’re doing:
As well as sticking with the suggestion of keeping the enhanced default security settings:
I don’t want any automatic unattended tasks running:
Check your filesystem layout, then hit Next:
Yes, we want it to go ahead and create the database. Hit Finish this time.
It will show what it’s about to do. Check it out, then hit OK when ready.
And it will get to work, creating your first database:
Go get another cup of tea:
And another:
And keep watching the screen until you see something like this:
At this point, you’ll have an empty database created.
Testing
Time to check it out. First test: we shut it down and restart it.
[email protected]:~$ export ORACLE_SID=intrepid [email protected]:~$ . oraenv ORACLE_SID = [intrepid] ? The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/oraibex is /u01/app/oracle [email protected]:~$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 6 14:35:24 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> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Global Area 238530560 bytes Fixed Size 1299116 bytes Variable Size 125832532 bytes Database Buffers 109051904 bytes Redo Buffers 2347008 bytes SQL> alter database mount; Database altered. SQL> alter database open; Database altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [email protected]:~$
Next, we make it start on boot:
[email protected]:~# cat /etc/oratab # # This file is used by ORACLE utilities. It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database. # A colon, ':', is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:: # # The first and second fields are the system identifier and home # directory of the database respectively. The third filed indicates # to the dbstart utility that the database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # intrepid:/u01/app/oracle/product/11.1.0/oraibex:N [email protected]:~#
See that N on the line starting with intrepid? Change it to Y:
intrepid:/u01/app/oracle/product/11.1.0/oraibex:Y
Here’s what happens when you run /etc/init.d/oracledb:
[email protected]:~# /etc/init.d/oracledb start Starting Oracle: LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 12-NOV-2008 15:39:25 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.1.0/oraibex/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.1.0.6.0 - Production Log messages written to /u01/app/oracle/diag/tnslsnr/ibex/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibex.baia)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 12-NOV-2008 15:39:28 Uptime 0 days 0 hr. 0 min. 3 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/diag/tnslsnr/ibex/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibex.baia)(PORT=1521))) The listener supports no services The command completed successfully Processing Database instance "intrepid": log file /u01/app/oracle/product/11.1.0/oraibex/startup.log OK [email protected]:~#
So after every reboot, you’ll be able to login to your database:
[email protected]:~# su - oracle [email protected]:~$ export ORACLE_SID=intrepid [email protected]:~$ . oraenv ORACLE_SID = [intrepid] ? The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/oraibex is /u01/app/oracle [email protected]:~$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 12 15:41:38 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> select sysdate from dual; SYSDATE --------- 12-NOV-08 SQL>
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.
Don’t forget to let us know how you make out with this. Cheers!
117 Comments. Leave new
hi!
at creating table:
after dbca comm: No protocol specified
@darky,
Here’s a sample output on the VM I built (and rebuilt several times while writing this article):
[email protected]:~$ export ORACLE_SID=intrepid
[email protected]:~$ . oraenv
ORACLE_SID = [intrepid] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/oraibex is /u01/app/oracle
[email protected]:~$ sqlplus ‘/as sysdba’
SQL*Plus: Release 11.1.0.6.0 – Production on Wed Nov 19 08:34:14 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> create table sys.dont_do_this_on_sys (a number);
Table created.
SQL> insert into sys.dont_do_this_on_sys (a) values (1);
1 row created.
SQL> insert into sys.dont_do_this_on_sys (a) values (2);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from sys.dont_do_this_on_sys;
A
———-
1
2
SQL> drop table sys.dont_do_this_on_sys;
Table dropped.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[email protected]:~$
Please double-check your installation steps as you probably missed something – hard to tell exactly what…
Cheers!
Thanks for the great document Bott!!. I managed to get Oracle 11 up and running on my laptop. There were few hiccups during the process.
1) I had to use export DISPLAY=:0.0 instead of export DISPLAY=:0.0 as I did the installation on my laptop.
2) I got a blank pop up window as the final confirmation of the database creation and had to disable compiz (metacity –replace) in order to get it visible.
Apart from that I’ve noticed the following error messages on the shell during the installation, which seems to be harmless for the time being
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
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
Thanks again for the great document. It helped a lot.
Cheers,
Jay
Bravo!!! Excellent!!! Marvelous!!!
Wow! I can’t believe that installing Oracle could be this easy. I’ve been trying to do this for a long time. Just last week I saw your post but it was only for Hardy. So, I installed Oracle 10XE. When I visited your site again, saw the link to this post. I immediately uninstalled XE and tried 11g and IT WORKED!!! I’ve no words to thankyou for your effort. Showing output for every single command, showing every screenshots on the way. Noone could have done better than this. Thankyou so much for this great guide. Would you mind if I print a copy of this page?
Few suggestions:
There is a small typo above. Instead of:
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
It should be
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Also, where you said Note: Do not restart. I had to restart my system as dbca stuck there forever. After a restart it took only 2 mins to start.
I would like to see this tutorial also for a standalone PC/Laptop. People like me like to test Oracle in their own machine instead of a server.I think it is not that difficult to install in a standalone PC/Laptop after reading this, but it will help those who are already familiar with Oracle but are new to Linux.
Thank you so much again.
PS: This could be my first ever comment online where I’ve given honest feedback and where I’ve provided my real name and emailID just to honor your great effort ;-)
Ashok,
I definitely do the same testing on my laptop. I am trying to figure out how to get zenoss working with Oracle vice MySQL. What I do when testing anything on my laptop is use a VM (VMware or Virtualbox) that way you can scrap it and do it again and actual ssh into the VM (like you normally would for a server anyway.
Great tutorial!
@ashok, @iteachguru,
If you want to run that on a local machine, you probably can skip all the
sshparts but keep theexport DISPLAYas this tutorial was designed with empty/default environment variables in mind.Also, thanks for noticing that ‘missing exit’ but there’s no typo in there: instead of typing ‘exit’ to quit
sqlplus, I typedcontrol + D. This leads to the same result: it quits since it received an EOF char.Cheers!
Hi bott, I follow your tutorial and then i have trouble at this point:
[email protected]:~$ export DISPLAY=192.168.w.z:0.0
[email protected]:~$ cd /media/database
[email protected]:/media/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
didn’t seem to work for me. I used the following link to solve the “unable to open display issue”
https://rossov.com/2006/02/10/xhost-unable-to-open-display/
[email protected]:~$ xauth extract /tmp/xauth.key $DISPLAY && chmod 644 /tmp/xauth.key
[email protected]:~$ su – oracle
Password:
[email protected]:~$ xauth merge /tmp/xauth.key
xauth: creating new authority file /home/oracle/.Xauthority
[email protected]:~$ xhost +
access control disabled, clients can connect from any host
[email protected]:~$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Thank you so much for the great tutorial.
Thanks Rafi! I was having trouble with the display as well. I used your instructions with one extra step due to an error. Also, I used these instructions on Ubuntu 9.10. Thank you to everyone involved on the page – it is VERY useful.
[email protected]:~$ xauth extract /tmp/xauth.key $DISPLAY && chmod 644 /tmp/xauth.key
[email protected]:~$ sudo su – oracle
[sudo] password for ongroup:
[email protected]:~$ xauth merge /tmp/xauth.key
[email protected]:~$ xhost +
xhost: unable to open display “”
(this is the error I received)
[email protected]:~$ export DISPLAY=:0.0
[email protected]:~$ xhost +
access control disabled, clients can connect from any host
[email protected]:~$ cd /media/database/
[email protected]:/media/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 257333 MB Passed
Checking swap space: must be greater than 150 MB. Actual 11515 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-03-20_01-15-32PM. Please wait …[email protected]:/media/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
@Rafi,
Please notice you need to explicitly allow connections to be accepted on the machine running the
X server. This usually means “your workstation”. You might need to check Menu System -> Administration -> Login Window (check the Security tab), but this is usually achieved just by executingxhost +ip_address. Theexport DISPLAYcommand shall be issued on the machine you’re about to run theOracleinstaller so when starting, it knows “where” to show the interface.Cheers!
[…] The ORACLE-BASE Blog has a dynamic duo of articles—one each on installing Oracle 11.1 and installing Fedora 10. (I’m a little late mentioning it, but this item is a fine complement to Augusto Bott’s latest article: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex). […]
Thanks so much. I made it at last!
I’m using X (gnome-core and gdm) on the same machine, so I did this, a bit different to your guide:
1. Test if X-server is active, the result is that it is not:
[email protected]:~$ xclock
Error: Can’t open display:
2. Log in to Gnome desktop with an administrator account, go to System >> Administration >> Login window >> Security and untick the box next to ‘Deny TCP connection to X server’
3. Log out of Desktop, log in again with user oracle. Open terminal window and run these commands (I do not remember where I copied these from)
[email protected]linapp04:~$ xclock
Error: Can’t open display:
[email protected]:~$ export DISPLAY=:0
[email protected]:~$ xhost +localhost
localhost being added to access control list
[email protected]:~$ xclock
By this time we can see a clock on our desktop. ^C to exit to terminal. After this I was able to start Oracle Universal Installer exactly like guided above!!
Thanks again. Cam on!
Very good guide indeed! Works precisely as described without any hitch. Even for an old hand at installing Oracle (like me) that makes it very helpful. I certainly would have had a few bumps in my install experience otherwise. Please keep up the good work, it is much appreciated!
I have a windows home vista edition that I have installed a VMWare Server and installed Ubuntu Desktop edition into it. Can I install 11gRel1 into this Desktop edition? I saw one of your posts where you stated that you could.
How hard is it to uninstall the desktop and install the server?
thanks.
You can install it on the desktop edition without problems. I’ve an Ubuntu Desktop 8.10 box and I’ve got Oracle 11g running following the instructions of this wonderful how-to
:-)
@DJEhresmann,
Installation on the Ubuntu Desktop edition should be not different at all so I don’t think you need to reinstall Ubuntu Server edition on your VM. Check Tam’s comments above (Nov 29th) and that shall help you.
Cheers!
Your Installer Manual Worked Like a Charm, EXCELEEENTEE
I Used the Ubuntu Client version instead of Server, did not do anything different, so yes the client version also works perfectly.
one note, did not use the 64 bits version but the 32 bits version available at OTN, but followed the same manual. Works like a charm
I can’t thank you enough for this wonderful tutorial and great effort. I installed Oracle 11gR1 32bit over Ubuntu 8.1 Desktop version on a partition and dual boot with vista which worked perfectly! I had a few issues with the Display but I was able to work around by following some of the feedback above. I noticed that the oracle user was locked, once unlocked everything with the Display worked just fine. I skipped every instruction that had to do with (ssh section) as suggested above Bott since it was a local machine install. One last note, I did not have a dedicated partition for swap file, I defined a swap file instead using the dd command, with the 2.6 Linux kernel, swap files are just as fast as swap partitions. Again thanks for the time and efforts for making such a detail instructions to install the products.
Last installed oracle 8.1.6.0 (8iR2 on HPUX); almost 10 years ago. Followed the directions and worked without a hitch. Did use microsoft’s hyper-v server instead of vmware. Looking forward to “oracling” around with the db.
Thanks for the guide and all the hard work!
Hi,
Thanks for guidelins, I recently migrated to ubuntu 8.10 from windows XP. I am trying to setup my development environment on ubuntu.
I am installing oracle 11g by following this blog,
but while setting up X-server, I am getting following error,
Code:
[email protected]:~$ export DISPLAY=:0
[email protected]:~$ xhost +localhost
No protocol specified
xhost: unable to open display “:0”
I tried all suggestion mentioned in above link, but it does not help.
Any help/ pointers appreciated.
Thanks,
Sachin
Ubuntu NewBie
I solved my issue, Thanks for nice/ step by step guidelines.
I used
> sux – oracle
to switch user.
@Sachin,
I’m glad things worked out for you! The only problem I could see with your
export DISPLAYis thesyntax. I’d suggest tryingexport DISPLAY=:0.0. Please notice the extradotandzero, mentioned on the HOWTO, but not present on your comment.Cheers!
[…] Instalando Oracle 11g no Ubuntu 8.10 Intrepid Ibex By helderam https://www.pythian.com/blogs/1355 […]
Dear Sirs,
after I install Oracle software have some error and Database tell me created but is not truth.
I’ve another problem when I launch installer go out right window with all button and labels but if I select deinstall product go out an empty pop-up window.
Warnings (Assertion failure) that go out when I launch runInstaller are follow:
[email protected]:/media/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 210485 MB Passed
Checking swap space: must be greater than 150 MB. Actual 15257 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-12-14_11-15-17AM. Please wait …[email protected]:/media/database$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.
Locking assertion failure. Backtrace:
#0 /usr/lib/libxcb-xlib.so.0 [0x7fe3702869fc]
#1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_unlock+0x24) [0x7fe370286ab4]
#2 /usr/lib/libX11.so.6(_XReply+0x268) [0x7fe3706d4698]
#3 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so(XineramaQueryScreens+0xab) [0x7fe370bd22ab]
#4 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so(xineramaInit+0x4c) [0x7fe370bbf41c]
#5 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so(awt_init_Display+0xee) [0x7fe370bbf57e]
#6 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so(Java_sun_awt_X11GraphicsEnvironment_initDisplay+0x9) [0x7fe370bbf749]
#7 [0x7fe3815fef9b]
Locking assertion failure. Backtrace:
#0 /usr/lib/libxcb-xlib.so.0 [0x7fe3702869fc]
#1 /usr/lib/libxcb-xlib.so.0(xcb_xlib_lock+0x17) [0x7fe370286b77]
#2 /usr/lib/libX11.so.6 [0x7fe3706d38c0]
#3 /usr/lib/libX11.so.6(XGetVisualInfo+0x2e) [0x7fe3706ca08e]
#4 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so [0x7fe370bbe777]
#5 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so [0x7fe370bbe9b1]
#6 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so(awt_init_Display+0x189) [0x7fe370bbf619]
#7 /tmp/OraInstall2008-12-14_11-15-17AM/jdk/jre/lib/amd64/xawt/libmawt.so(Java_sun_awt_X11GraphicsEnvironment_initDisplay+0x9) [0x7fe370bbf749]
#8 [0x7fe3815fef9b]
please help me!!!
About redirect xhost solved problem in local server (no remote connection but only use su – command to change user root to oracle and oracle to root for oracle installation):
I solved problem to redirect xhost follow commands work for me:
Like root user enable to export to other users:
[email protected]> DISPLAY=:0.0; export DISPLAY; xhost +;
connect like oracle user
[email protected]> su – oracle
redirect display and export
[email protected]> DISPLAY=:0.0 ; export DISPLAY
Another mode is
Like root user enable to export to other users:
[email protected]> DISPLAY=:0; export DISPLAY; xhost +;
connect like oracle user
[email protected]> su – oracle
redirect display and export
[email protected]> DISPLAY=:0 ; export DISPLAY
thank you very much Mr for your HOWTO it was very helpful
I want just you help please about somethings :
I fellow all the steps and I had the same results but my problem now is how can I connect to the database using the web interface
I used the URL given in ( /u01/app/oracle/product/11.1.0/oraibex/install ):
URL Enterprise Manager Database Control – (orcl) :
https://yassir-laptop:1158/em
but it didn’t work
I used also the https://yassir-laptop:1521/em/ the same problem
second problem :
I don’t know how to use OHS with oracle 11g
because in 10g we install CD Companion but here I can’t found it
please help me Mr !!!
thank you
best regard
@Vicenzo,
Are you sure you’re following the instructions on this HOWTO? I noticed you might not be using the proper binarios (are you using amd64?). Please double-check the instructions from the beginning as there is more than one version available to download from the Oracle website.
Cheers!
@Yassir,
Please notice that on this HOWTO we don’t setup EM, so I can only try to guess what might be wrong since you didn’t follow the instructions on this article step-by-step (as they were written). Believe me when I say I spent a great deal of time to write those instructions: so you guys get an increased chance of success by getting the very same results I did.
That said, have you checked if the Enterprise Manager is actually running when you tried to open that
httpaddress? You can try to fire it up with$ORACLE_HOME/bin/emctl start dbconsoleas theoracleuser.As for OHS, I’m sorry but I can’t help you there as I’ve never even used that. I usually stick with
sqlplusandsqldeveloper.Best of luck!
Good afternoon Augusto Bott,
I’m sure that this versione is an AMD64 in CD I open document that specify installation in compliance linux system for oracle 11gR1.
I don’t know reason about strange behavior of windows pop for example to unistall packets of oracle installation or installed component.
The strange thing is that when ended installation server (no oracle db) go out follow errors strange is last line where is write “32 PROC-32” but documentation in cd talk about amd 64 platform and downloaded from Oracle site:
Oracle Database 11g CRS Release 11.1.0.6.0 – Production Copyright 1996, 2007 Oracle. All rights reserved.
2008-12-14 09:54:23.117: [ OCROSD][905623264]utgdv:2:ocr loc file cannot be opened
2008-12-14 09:54:23.117: [ OCROSD][905623264]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2008-12-14 09:54:23.117: [ OCRRAW][905623264]proprinit: Could not open raw device
2008-12-14 09:54:23.117: [ default][905623264]a_init:7!: Backend init unsuccessful : [33]
2008-12-14 09:54:23.119: [ CSSCLNT][905623264]clsssinit: error(32 PROC-32: Cluster Ready Services on the local node is not running Messaging error [9]) in OCR initialization
Kind Regards
Vincenzo
@Vincenzo,
So indeed you’re not using 32-bit versions of the binaries mentioned on this article: please notice at the preparation stage (at the beginning of this HOWTO) we mention using 32-bit binaries for both the OS and the database. Also, those error messages seem to be related to a RAC setup, right? That said, I’m not sure I might be able to help as for such a setup as there might be some substantial differences from the instructions on this article (and as such, unfortunately those are not covered in this HOWTO). Still, I do wish you luck on your quest.
Cheers!
Stuck on display. I’m running Hummingbird on my VISTA box talking to my ubuntu server via X-Windows. I’ve exported my DISPLAY after logging into oracle and I can start xterm, xclock and nedit without problems, but the .runInstaller just stops after displaying the passed checks… nothing else happens…
Any help is appreciated.
Hi,
Thank you very much for this step-by-step guide. Helped me a lot.
The installation went smooth except for 2 error messages:
Exception String: Error in invoking target ‘all_no_orcl’ of makefile ‘/u01/app/oracle/product/11.1.0/OraDb11g/rdbms/lib/ins_rdbms.mk’. See ‘/u01/app/oraInventory/logs/installActions2008-12-20_06-59-27PM.log’ for details.
Exception String: Error in invoking target ‘install’ of makefile ‘/u01/app/oracle/product/11.1.0/OraDb11g/ctx/lib/ins_ctx.mk’. See ‘/u01/app/oraInventory/logs/installActions2008-12-20_06-59-27PM.log’ for details.
I opted to continue during the error messages and the installation completed successfully. The database is up and running successfully. I am not sure what effect the errors mentioned above will have. Any suggestions as to how I can fix them?
Thanks again.
Sriram.
@Sriram,
I suggest looking into the logs you mentioned on your comments (
/u01/app/oraInventory/logs/installActions2008-12-20_06-59-27PM.log) as these might contain more specific information.Cheers!
@Chuck,
Please double-check for any firewall or anti-virus software that might be intercepting TCP communications between you Ubuntu and Vista boxes.
Cheers!
Well, I turned off my Desktop PC’s firewall and I checked the UFW entries in syslog. There were some strange errors from my PC’s IP address. So I used ufw and granted full access to that IP address to the server. Restarted the server, etc. and I still can’t get the Java screens up. No more errors in the syslog though ;-).
When I do a ps I can see a java session out there running that wasn’t there before, but no screens.
Chuck
I tried installing remotely from a Ubuntu laptop but had a similar experience. I finally had to install Kubuntu desktop on the server and the installation went fine from then on. Didn’t really want the overhead of the GUI on the server but at least I still have the Ubuntu server backend.
@Chuck,
I assume you already did a troubleshooting session and ruled out your X server as the cause of the problems, right? If you can indeed run other programs such as
xclockorxterm, then the only thing I could do would be wishing good luck on your quest: please double-check every single step from the beginning as I executed this whole procedure step by step as described over a dozen times (and repeated a few times after I got the proper sequence of commands right).Cheers!
Hello …
Thank you for giving wonderful directions. I appreciate your detailed instructions and help to the DB world!!
Regards!!
Thanks for this tutorial is perfectly working, i have totally access through sqlplus, but have anyone a guide for apex and/or sql developer working steps tu put them online, after these oracle installations steps?.
I’m not able to do so.
[…] switching to Ubuntu, I tried to install Oracle but no luck until I found this guide from Augusto Bott . He has really written an excellent guide on installing Oracle on different versions of Ubuntu. […]
Hi,
It isn’t a bad job,
Thanks,
on this my website page you can found my solution and a script to resolve some problem:
https://fucinatecnica.blogspot.com/2009/01/install-oracle-sql-developer-on-ubuntu.html
ciao
mb!!!
It works not so fine with the 64-bit version of oracle.
There you get the linking errors for extproc32 und ctxhx.
The linking had problems with compiler flags (cannot find lagtsh). Any idea ?
INFO: gcc -m32 -o /opt/oracle/product/db111/rdbms/lib/extproc32 -L/opt/oracle/product/db111/rdbms/lib32/ -L/opt/oracle/product/db111/lib32/ -L/opt/oracle/product/db111/lib32/stubs/ /opt/oracle/product/db111/rdbms/lib32/hormc.o /opt/oracle/product/db111/rdbms/lib32/homts.o -lagtsh -lpthread -lclntsh `cat /opt/oracle/product/db111/lib32/sysliblist` -Wl,-rpath,/opt/oracle/product/db111/lib32 -lm `cat /opt/oracle/product/db111/lib32/sysliblist` -ldl -lm -L/opt/oracle/product/db111/lib32
INFO: /
INFO: usr
INFO: /
INFO: bin
INFO: /
INFO: ld
INFO: :
INFO:
INFO: cannot
INFO:
INFO: find
INFO:
INFO: –
INFO: lagtsh
INFO:
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 ‘/opt/oracle/product/db111/rdbms/lib/ins_rdbms.mk’. See ‘/opt/oracle/oraInventory/logs/installActions2009-01-21_09-30-24PM.log’ for details.
look at Sriram Says:
December 21st, 2008 at 4:46 pm
I have the same problem with my 64bit Ubuntu. The error message I get is :
/etc/inittab does not seem to contain default runlevel information.
Actually there is no inittab file at all. Any idea on how I can bypass this ?
@hsthst,
Please double-check that you are indeed using the correct combination of OS (32/32 or 64/64) as the necessary steps with any kind of 64 bit binaries can be quite different. Also, please keep in mind you cannot install a 64 bit version of any application/service on a 32 bit OS.
Cheers!
@Stelios,
The behaviour you’re describing is the most strange thing… I’ve installed Oracle on Ubuntu several times with different versions of Oracle 10 and 11, since Ubuntu 6.x – never encountered such a problem. Googling around, I realized that Ubuntu indeed used to have a inittab – it was replaced by ‘upstart’ on recent Ubuntu releases.
Hi,
When I issued the below command, I got the message that these are already installed…
[email protected]:~# apt-get install libaio1 lesstif2 libmotif3
and then when I tried to invoke dbca, I don’t see any message and the cursor returns to the command line. And, the dbca is not invoked. how can I fix this? Any help is appreciated.
Thanks
How long does this take? On a vm, it’s been ~2 hrs and still at 11%. It’s been on 11% for a long time.
Here’s the output to terminal:
#11 [0xb2785217]
#12 /tmp/OraInstall2009-01-27_10-19-48AM/jdk/jre/lib/i386/client/libjvm.so [0xb792bd8c]
#13 /tmp/OraInstall2009-01-27_10-19-48AM/jdk/jre/lib/i386/client/libjvm.so [0xb7a3ffd8]
#14 /tmp/OraInstall2009-01-27_10-19-48AM/jdk/jre/lib/i386/client/libjvm.so [0xb792bbbf]
#15 /tmp/OraInstall2009-01-27_10-19-48AM/jdk/jre/lib/i386/client/libjvm.so(JVM_DoPrivileged+0x32d) [0xb798934d]
#16 /tmp/OraInstall2009-01-27_10-19-48AM/jdk/jre/lib/i386/libjava.so(Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0x3d) [0xb77202cd]
#17 [0xb278d4db]
#18 [0xb2787a64]
#19 [0xb2785217]
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
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
The only change I made was to ssh in as oracle for the oracle install portion.
Any ideas why this is happening?
Oh…I am also using xubuntu. I prefer xfce over gnome. That shouldn’t make a difference right?
Hi,
Thanks a lot for this post.
It is useful and helpful.
I use it and now Oracle Database is running on my Ubuntu.
—
Taleb DAHAN
Great Post!
Used it to install 10g R2 on Ubuntu 8.10.
Need to install HTTP apache services that are on the companion cd. Using oracle with a product called razuna which needs to modify the DAD.conf that is part of the apache add on EM. Any recommendation where I can find some tutorial on how to install the companion cd?
Thanks
@Dan,
Nope – as long as you have the basic Xorg packages in place (and related libraries to your Oracle install), you should be fine regardless of what’s your GUI choice.
Cheers!
thanks for this guide, I managed to get oracle up and running last night on ubuntu desktop, however I found that bash started behaving in a strange manner afterwards, and on reinstallation it seems to be around the point where we run
apt-get install libaio1 lesstif2 libmotif3
(but might be a few steps earlier)
the symptom is that, if we try to run a shell script which doesn’t have the
#!/bin/bash
line at the begining, the session just hangs, if we issue
bash ./scriptname
this works
Any ideas ? The problem manifests itself in real life when issuing
. oraenv
as this has a call to dbhome, which hangs
@chupachups,
Please double-check you
/bin/shsymlink (fromdashtobash) as a typo at that step might cause you all sort of weird problems later.Cheers!
hi augusto
I did check that on the first install, it points to /bin/bash as expected, and the same thing on the second attempt too
NB, on the 2nd attempt I checked the situation after every major change, and the system was working after the symb link change, as I said it was somewhere around the 2nd apt-get install
I’m gonna try a 3rd attempt and see if I can confirm its the apt-get or whether it is something to do with the root run scripts
None of you guys have the problem ? Thats strange as my ubuntu is a completely fresh install + update
hey augusto, I found out that my problem isn’t anything to do with oracle
it seems that it is somehow related to putty (my windows terminal application), or openssh-server
if I run the script on my linux server directly instead of putty under windows, the hang doesn’t occur
anyone seen this before ?
Dear Sirs,
I believe this is a great guide in installing 11g on Ubuntu.
Well, getting to the point. I am kind off Newbie to the world of Linux.
I am getting the following error message while installing 11g on my PC. So, no remote stuff”
Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo” and the installer never starts.
System: AMD 64 X4
OS: UBUNTU server 8.1 64
db: 11g 64 bit
[email protected]:/home/sreeharsha/software$ ls
database linux.x64_11gR1_database_1013.zip
[email protected]:/home/sreeharsha/software$ cd database/
[email protected]:/home/sreeharsha/software/database$ ./runInstaller -ignoreSysPrereqs
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 37664 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2138 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…
—————–
Problem 2
I am not quite clear about the instruction export DISPLAY=:0.0 Based upon the syntax, can I assume it as export DISPLAY=powerhouse:0.0? as powerhouse is my machine name.
—————-
Looking forward in hearing from you as soon as possible
Hi,
First of all, many thanks for the effort put in to develop such a great guide. Really makes life easier :)
On my installation attempt, its repeatedly failing at the lagtsh thing (pointed out by another fellow earlier).
Any clues ?
Moreover, if I ignore that and continue, it fails again saying that it couldnt locate /usr/lib/libpthread_nonshared.a
Help wanted…
raghav..
thank you!
I too got the blank confirmation screen as the last step of dbca.
I too was able to issue command ‘metacity –replace’ on local client to fix the issue. Notice the two dashes, the original poster only used one.
thanks to both of you!
Neil
thank you for this guide
Hi,
I’ve been trying to follow these directions to install 10g in 8.10 server but I get the following. Any thoughts?
Thanks,
-Bill
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-02-16_10-11-00PM. Please wait …[email protected]:/media/database$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-02-16_10-11-00PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-02-16_10-11-00PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.(Unknown Source)
at java.awt.Component.(Unknown Source)
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.(OiifmGraphicInterfaceManager.java:222)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiic.OiicInstaller.getInterfaceManager(OiicInstaller.java:436)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:926)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
Exception in thread “main” java.lang.NoClassDefFoundError
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.(OiifmGraphicInterfaceManager.java:222)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiif.oiifm.OiifmAlert.(OiifmAlert.java:151)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:984)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
@sreeharsha:
I had the same problem as you. Here is how I fixed it:
First, open a Terminal at the computer in which you are trying to install Oracle 11g. Do not log as root yet.
Type:
[email protected]:~$ xauth list
You will see something like:
hollowbastion/unix:0 MIT-MAGIC-COOKIE-1 179a224f5cc6f25b876210e92df3c485
localhost.localdomain/unix:0 MIT-MAGIC-COOKIE-1 179a224f5cc6f25b876210e92df3c485
Now, change to root:
[email protected]:~$ sudo su –
Type again:
[email protected]:~$ xauth list
if you see something like:
xauth: creating new authority file (…)
then it means that the xauth list was not found for root and it was just created. Of course, it is empty now. You will need to add all the entries to the xauth list. To do that you will have to type:
xauth add hollowbastion/unix:0 . 179a224f5cc6f25b876210e92df3c485
xauth add localhost.localdomain/unix:0 . 179a224f5cc6f25b876210e92df3c485
The values of the entries you are adding depend on the values you got from the first step. Please note the 179a224f5cc6f25b876210e92df3c485 is the value I got from my OS. You should have a different value here. However, the syntax for the command is the same. Just change that value so it matches with the one you have. Also, note the ‘ . ‘ between the name and the hex value.
Now, change to oracle:
[email protected]:~# su – oracle
Type again:
[email protected]:~$ xauth list
The xauth list for oracle should be empty. Repeat the same process to add all the entries to the xauth list of oracle.
Try to run the Oracle 11g Installer again (using the same commands that appear in the guide) and the problem should be fixed.
By the way, if you are installing Oracle 11g without using a remote console, you should use:
[email protected]:/media/database$ export DISPLAY=:0.0
Hope that helps!
-Priscilla.
Augusto:
Thank you for your very detailed instructions. After I resolved some issues I was having with Xwindows, I was able to complete an install on Ubuntu 8.10 server.
-Mark
I’ve been struggling with the Installation for a long time. I kept getting the error “cannot open display”. I finally figured it out, so I’ll post my solution in case anyone else is having the same problem.
I’m using Kubuntu 8.10 32bit
the code i used…
su –
password:
su – oracle
export DISPLAY=:0.0
X will now run, and the installation can continue…
What is the reason for using ssh?
How do I find out what my x and y values are for 192.168.x.y?
Thanks to you my install went great! Just one question: Some windows that came up (for instance, the window that showed db creation progress) were empty. Any ideas as to why?
Thanks,
Karen
Hi,
thanks for the install guide!
One small thing, you point to the 64 bit version of the Oracle installer, which is not apparent when downloading the file. Unless you take a very close look to the filename. You might want to mention that in the guide.
Hi,
Another successful Oracle11g installation on ubuntu intrepid. Thanks a lot!!!
[…] minutes. I guess I have to thank Augusto twice, just for this post! I’ve also followed his “Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex” post to install the Oracle […]
Another one who finally made it. Some slight things that didn’t work (DISPLAY variable) but it’s up & running now!
Why didn’t the pics on this page display?
Thanks a bunch for putting this all together!
Worked like a champ for me, thanks for putting this up. Only thing I’d add is a section on setting up the .bash_profile or .bashrc file for the oracle account to set the ORACLE_SID, ORACLE_HOME and other environment variables.
Is anyone maintaining this? I also would like the assistance of the images as none of them show up.
I’m at the final section where I will be running the test and I’m wondering what will be the next step in configuring APEX?
This is awesome!… few hiccups on installing it on ubuntu 8.10 server on a Dell D830 Laptop, But in the end, it worked out well.
I had to install package libaio1 to address error ¨UnsatisfiedLinkError exception loading native library: njni11¨ when starting dbca.
to install libaio1 do:
apt-get install libaio1
The article is very useful.
But I cannot see the images it’s a pity they would make for a better reading experience.
Thanks for sharing this info.
Hi David. Thanks for the word. Some images got lost in the transition to the updated-look blog, but—good news!—we have them, and they’ll be back in place before long.
setup not suscessfull! :(
Awesome tutorial and fun too! :-) … works like a charm! I used Ubuntu Server (and virtual box) Intrepid but I installed the GUI before
>sudo apt-get install xserver-xorg xfonts* gnome
Will take some time downloading, but helps a bit if you came from Windows/MS-SQL environment like me ;-)
Thank you so much for the time you invested on this “How To”.
Hi
Will this work with Kubuntu 64-bit on a notebook to install Oracle 11g 64-bit.
Thanks
Stan
I hope you guys are working on one of these for 9.04…I’ve just updated, and use this set of resources like a crutch when trying to get Oracle installed on Ubuntu.
From my own efforts using the 8.10 instructions, it seems that the sh->bash re-linking causes Gnome to fail to start up. Haven’t tried the oracle install itself yet, might give that a shot and try reverting the re-linking step after successful install.
@Eric,
Yes – we’re working on a 9.04 version of this tutorial. Stay tuned!
Hi,
Another successful Oracle11g installation on ubuntu intrepid. Thanks a lot!!!
—————————————–
[the key is : cat /etc/oratab… N=>Y]
~~~~~~~
I used these steps on my freshly installed jaunty with few modifications like ‘export DISPLAY=:0.0″ and adding sample schemas….
worked just fine…
THX ALOT.
Greetings.
Much appreciated…used the exact same steps for jaunty as well and it works brilliantly.
Regards
Cheers…
Greate , well done. finish install 11.1.0.6 on ubuntu 9.0.4 with no error.
Thx ALOT.
Hi! I just have to do this, but my problem is, that I need to manage my virtual X server from a Win XP. So could someone help, me on how to export the display to Xming?
Thanks a lot!! Works great with Ubuntu 9.04 – Jaunty Jackalope! ;-)
Hi
This is excellent…. I just configured my oracle 11g on 8.10, its working fine. I had some problems initiating the oui as export DISPLAY didnt worked for me. So, referred Oracle OTN forums and copied .Xauthority file from other user to oracle user’s home and did chown & chmod so that oracle user can access. Then export DISPLAY again and this time I was able to run xclock and initiated the OUI successfully.
Next, I have installed oracle 11g client on my laptop running Ubuntu Hardy that went fine, but I am facing issue connecting to my Oracle server just configured, any help would be appreciated.
Regards
Amit
Everything went smoothly for me until the very end. When I run oracledb start i get:
TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Log messages written to /u01/app/oracle/diag/tnslsnr/smbserver/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=smbserver)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
Linux Error: 110: Connection timed out
I dont seem to have a listener.ora file or anything. Did I miss something? It doesnt seem to know the HOST name in the last part. I am installing on Ubuntu 8.10 Desktop edition.
Thanks.
Great post! I tried the same steps with the 9.0.4 Ubuntu Server. Mostly works. First issue was the link for extproc failed but installing libaio-dev (which includes libaio1) fixed that issue. However, extproc32 link also failed as well as the 32-bit version of ins-ctx. Have not figured these out yet bit I don’t use these components so I don’t really care.
@Kevin,
A new version, for Ubuntu 9.04 is on the works, about to be published. Keep tuned!
This works for 10.2 on 9.04 with minor differences in the actual GUI install.
A note on 64bit versions of 9.04, when installing 10.2 the universtal installer requires 32bit libc to be installed otherwise you will get the .oui error mentioned in some of the posts above.
Trying to get this working for 64bit 9.04 with 64bit oracle 11GR1.
Following the instructions, I get an error right away when I run the installer. Right after it runs the tests it says “Preparing to launch Oracle Universal Install from yada yada Please wait …”
And then I get the following error:
“sh: /media/database/install/unzip: No such file or directory”
Guessing that it was a 32bit program I installed “ia32-libs” and got past the error.
Finally sorted the 64-bit Oracle issue (failing to build libagtsh.so and extproc32/ctxhx which depend on that.
In ${ORACLE_HOME}/lib32/stubs, you need to update libc.so and libpthread.so.
in libc.so, change:
GROUP ( libc.so.6 /usr/lib/libc_nonshared.a )
to
GROUP ( /lib32/libc.so.6 /usr/lib32/libc_nonshared.a )
and in libpthread.so change
GROUP ( /lib/libpthread.so.0 /usr/lib/libpthread_nonshared.a )
to
GROUP ( /lib32/libpthread.so.0 /usr/lib32/libpthread_nonshared.a )
Must be to do with where Ubuntu puts its 32-bit libraries compared with Redhat?
Hope that helps.
[…] 8.10 – Intrepid Ibex […]
Works well! Good work! With your help i managed it to install Oracle 11g on a Debian 5.0 machine, there are only a few minor differences.
I’am planning to write an article about it on my website and i will post a big link to your excellent explanation!
I successfully completed an 11gR2 installation toinght on my Ubuntu 9.04 desktop.
One additional package was needed during installation:
sudo apt-get install libstdc++5
Thanks for the guide!
Very nice install, worked a treat on Ubuntu 9.0.4 server. Thanks you !!
This worked great for installing 11g2 on Ubuntu Karmic Koala 9.10.
A few things had to be changed, path names and such are slightly different. But it was still pretty painless.
Confirmation screen shows up blank like a few others.
System->Preferences->Appearance->Visual Effects = None
Good work, very helpful!!
I am getting linking errors.
Exception Name: MakefileException
Exception String: Error in invoking target ‘install’ of makefile ‘/app/oracle/product/11.2.0/dbhome_1/ctx/lib/ins_ctx.mk’
What packages did you install?
probably too late for you, but for the record:
https://forums.oracle.com/forums/thread.jspa?threadID=1077139&tstart=0
Laurent
Hello,
Thanks so much for this wonderful guide! I’m having one problem that only one script shows up at the end of the install (/u01/app/oracle/product/10.2.0/oraibex/root.sh). The orainstRoot.sh script is not shown.
Also, the oraInventory directory always gets created under /home/oracle even though I’ve set ORACLE_BASE and ORACLE_HOME vars in /etc/profile as well as /etc/profile.d/oradb.sh. Have tried this install several times now! Please help!!
Thanks,
Raj
@penguin
hi penguin, can you tell me, what did you have to change in order to install the latest oracle 11g R2 on Ubuntu 9.10?
I am getting this error message:
“./runInstaller: line 137: /media/database/install/.oui: No such file or directory”
I don’t see any .oui file under any of the database folders, how/when should this be created?
thanks.
Hi again,
thanks for this VERY HELPFUL guide.
Since it was not just my first time to install Oracle on Linux, but also first time to install Linux, so I couldn’t have managed without this manual! :)
Today I finally got everything working, it took 5 hours from scratch to install Ubuntu 9.10 + ssh + desktop + updates + Oracle 11g R1 warehouse database for educational purposes.
There were some things that didn’t match the guide but bits of data from many different comments also came in handy. And of course Google.
Have to create my own “manual” now to guarantee that next time would be more fluent.
[…] weiteren Versuch startete ich mit dieser Anleitung auf pythian.com. Der Autor verwendete hierbei allerdings eine ältere Ubuntu-Version und auch der […]
Hello everyone!
For those who have problems with remote display, I quickly avoided the problem as follows:
on workstation:
ssh -X [email protected] /home/oracle/software/database/runInstaller
or
ssh -X [email protected] /opt/oracle/product/11.2.0/dbhome/bin/dbca
I hope you will appreciate!:-)
regards
Fabio
p.s.: maybe you can find my guide useful: https://notesondm.blogspot.com/2009/12/how-install-oracle-database-11g.html
I’m getting this error trying to install oracle 10g on Ubuntu 9.10 (64 bit):
“./runInstaller: line 52: /media/database/install/.oui: No such file or directory”
The file exists and the permissions are fine.
Did anyone with the same problem resolve it? Peep, looks like you had the problem and the next day you were done installing… please help :)
If any one is having link errors with the ins_ctx.mk file you can try installing the libstdc++.so.5 library. I had this problem and when I ran the ‘make’ command manually it compalined that this library could not be found.
Cheers
@Aaron
export $ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
su oracle $ORACLE_HOME/bin/dbca
@Aaron
try also ./dbca instead of dbca
[…] Installing the server and setting up ssh Tunneling X over SSH I also setup a SAMBA share on the server. This is not directly relevant to the Oracle setup but I’ve included a link to it here as it serves to complete the picture of the state of the server before I started the installation. It also has a section on mounting a USB stick on the server, which may be relevant when it comes to transferring the Oracle files onto the server. Whilst I’m mentioning links, I should acknowledge the helpful information I got from here and especially here. […]
Thanks for a really comprehensive guide. I’ve used this as a basis for working out how to deploy 11g Release 2 on Ubuntu 9.10.
The steps for this are at :
https://mikesmithers.wordpress.com/2010/03/14/installing-oracle-11gr2-on-ubuntu-9-10
tanx for this
Hi I want to install Oracle SOA Suite 11g on Linux environment. But im not sure which distribution I should use.I read somewhere that ubuntu is not suported by SOA suite. Will you please help me out in this?
Any idea to install 10g or 11g standard edition on ubuntu lucid lynx.
[…] # https://www.pythian.com/news/1355/installing-oracle-11gr1-on-ubuntu-810-intrepid-ibex/ […]
Thank You – Success first time with 11gR2 installed on Ubuntu Linux 10.04 (64bit) following your instructions
[…] Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex […]
hi
Im trying to install oracle 11gR1 32bit on ubuntu linux 11.04 32bit and it looks like i need glib version ATLEAST=2.3.4-2.19. so I downloaded version libstdc++5_3.3.6-21ubuntu1_i386.deb since it said Atleast. But the system doesn’t seem to be verifying that requirement. Can anybody please help me.
I tried to sign up to your RSS however it doesnt appear to be working. Ill come back later.