Kick ass guide for installing Oracle on Ubuntu

by ashokgelal on January 7, 2009, 22 comments

One of the few complaints against any Linux OS – Difficult to install software which are not in the repository or in the standard .rpm/.deb format. Windows users enjoy double clicking an executable and then clicking NEXT button few times, Mac users just need to drag that .dmg file to the Application folder. Linux users feel themselves left out and find their own way playing with the Terminal, editing different system files, copying files from here to there and finally setting up some environment variables. Whew!

After 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. But again with this guide also the users need to open different files and edit them manually. It isn’t that much difficult but if you are like me who often needs to reinstall/upgrade Ubuntu for one reason or other, reading the whole guide and manually editing the system files is really time consuming and cumbersome. So, to save my time for future installation of Oracle database on my Ubuntu box, I wrote a couple of scripts (four scripts to be exact). Running these four scripts will install Oracle database and will give you a fresh database to start with. To facilitate visual-learners, I’ve also made two videos which have been embedded below. I will explain how to proceed briefly below:

1. Download all four scripts.and unzip them

Extract Oracle database downloaded from Oracle to a folder (such as in your home folder)
Open 2_OraInstaller.sh in a text editor and change the source/destination values. The default values assume that you have extracted the Oracle installer files in ~/oracle folder and you want to install Oracle db in /opt/oracle folder.
Open 4_OraInstaller.sh in a text editor and change the name of your database instance (dbSID). The default is oraIntrepid.
Fire up the Terminal and make all the files executable:

$chmod 755 ./1_OraInstaller.sh

$chmod 755 ./2_OraInstaller.sh

$chmod 755 ./3_OraInstaller.sh

$chmod 755 ./4_OraInstaller.sh

Make sure you have at least 3gb free space where you want to install your Oracle DB
Execute: $./1_OraInstaller.sh

You need to logoff and login once

Execute: $./2_OraInstaller.sh

This will install Oracle in silent mode. Please be patient as it will take some time and be very sure that YOU ARE CONNECTED TO THE INTERNET!!!

Execute: $./3_OraInstaller.sh

You need to restart you computer once at this point.

Execute: $./4_OraInstaller.sh

This will install Oracle database instance in silent mode. This will take about 15 mins so be very patient.

At this point your Oracle installation on your Ubuntu box is complete.

Here are two videos showing all the above steps:

Your browser should support iFrame to view this PDF document

Categories: Hardware, Installation, Linux, Software, System, Wallpapers / Tags: database, Installation, Intrepid Ibex, oracle, tutorial, ubuntu, video

wilson on January 22, 2009 at 1:08 pm

excellent guide and scripts. install was a doodle

sasha nikitin on June 10, 2009 at 3:25 am

Salut,
I’ve just made a clear install of latest Ubuntu and tried to install Oracle with you scripts. But I’ve come with several issues after the installation is complete. Please see the last minutes of the log:

~~~~~~~~~~~~
Enter SYS user password:

Enter SYSTEM user password:

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

Copying database files
37% complete
Creating and starting Oracle instance
62% complete
Completing Database Creation
100% complete
Look at the log file “/opt/oracle/cfgtoollogs/dbca/oraIntrepid/oraIntre.log” for further details.
[sudo] password for alex:
sed: can’t read /etc/oratab: No such file or directory
export ORACLE_SID=oraIntrepid
~~~~~~~~~~~~~
alex@skynet:~/oraInstaller$ sqlplus ‘/as sysdba’

SQL*Plus: Release 11.1.0.6.0 – Production on Wed Jun 10 13:10:25 2009

ERROR:
ORA-12162: TNS:net service name is incorrectly specified
~~~~~~~~~~~~

That’s how i’m unable to login to the database.
And seems that your script is not creating linux user /oracle’.

miltux on July 15, 2010 at 7:09 pm

try reboot your OS and ready.

Lawson on June 10, 2009 at 2:27 pm

Your script #3 broke my server! It never came back from a reboot….

Sekhar on October 8, 2009 at 7:09 am

Hi Ashok,,

Can you tell what theme you are using on your ubuntu.
Its looking cool man.

Thanks and Regards
Ratna Sekhar

dk on October 19, 2009 at 6:53 pm

Error running the second script:
database/install/response/ee.rsp not found

Oluwaseun on December 9, 2010 at 1:22 pm

iam also getting this error

please anybody … HELP !

mujtaba kori on January 26, 2010 at 2:11 pm

UnsatisfiedLinkError exception loading native library: njni10
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.<init>(Unknown Source)
at oracle.sysman.assistants.util.NetworkUtils.<init>(NetworkUtils.java:222)
at oracle.sysman.assistants.util.step.StepContext.<init>(StepContext.java:255)
at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:682)
at oracle.sysman.assistants.dbca.backend.SilentHost.<init>(SilentHost.java:125)
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:150)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)

mujtaba kori on January 26, 2010 at 2:14 pm

Error shown after running 4th file.
UnsatisfiedLinkError exception loading native library: njni10
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.<init>(Unknown Source)
at oracle.sysman.assistants.util.NetworkUtils.<init>(NetworkUtils.java:222)
at oracle.sysman.assistants.util.step.StepContext.<init>(StepContext.java:255)
at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:682)
at oracle.sysman.assistants.dbca.backend.SilentHost.<init>(SilentHost.java:125)
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:150)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)

Seun on December 9, 2010 at 1:20 pm

HI,

thanks for a wonderful help you have posted …

please iam getting an error … please check the listings below

thanks in anticipation of yo prompt response

Starting Oracle Universal Installer…

Checking Temp space: must be greater than 80 MB. Actual 53828 MB Passed
Checking swap space: must be greater than 150 MB. Actual 9536 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-12-09_08-16-06PM. Please wait …tolorun@omniotosho:~/oraInstaller$ [FATAL] [INS-10101] The given response file /home/tolorun/oracle/db/lin/database/install/response/ee.rsp is not found.
CAUSE: The given response file is either not accessible or do not exist.
ACTION: Give a correct response file location. (Note: relative path is not supported)

badri on February 10, 2011 at 10:02 pm

Hi Ashok,

Install went through successfully. Thank you very much for the scripts, worked like a charm!
Where to find the username and password?

- Badri

zack on April 4, 2011 at 2:39 am

when i run _oraInstaller.sh, I am getting this error
/home/administrator/oracle/runInstaller: line 52: /home/administrator/oracle/install/.oui: No such file or directory

zack on April 4, 2011 at 2:42 am

when i run _oraInstaller.sh, I am getting this error

teja on April 27, 2011 at 6:39 am

./2_oraInstaller.sh: line 120: /home/mohanteja/oracle/runInstaller: Permission denied
can anyone guide me y it is giving an error here…..

@jason_bourne009 on July 1, 2011 at 1:48 pm

getting this error after running 4th script

sid@ubuntu:~/Downloads$ ./4_oraInstaller.sh

##############################################################################
dbca is working in silent mode. Please be patient and have FEW cups of coffee.
##############################################################################

###########################################################
Seems everything is ok. Congratulations!!!
To get started try $ sqlplus '/as sysdba' and then sql> startup
If there is something wrong try with:
$ lsnrctl
LSNRCTL> status
LSNRCTL> stop
LSNRCTL> start
LSNRCTL> exit
$ sqlplus '/as sysdba'
sql>startup;

To share and discuss issues visit http://quicktweaks.com
##########################################################

sid@ubuntu:~/Downloads$ sqlplus '/as sysdba'
sid@ubuntu:~/Downloads$ sqlplus '/as sysdba';
sid@ubuntu:~/Downloads$ lsnrctl

@sphinxst on October 9, 2011 at 7:06 am

From the 1st glance there is 1 issue in the script: ./install/response folder does not exist on Oracle 11.2.0.2.0. As per my understanding, you need to use ./response/db_install.rsp. Inside, you will find parameters to set SE or EE version.

sahil on September 18, 2012 at 5:18 am

[root@visionCRM oraInstaller]# ./1_oraInstaller.sh
OMG! Did you sudo? Run the script without sudo.
please solve my issue

sahil on September 18, 2012 at 5:34 am

[root@visionCRM oraInstaller]# ./1_oraInstaller.sh

ashokgelal on September 18, 2012 at 9:48 am

replySent with Sparrow<p style=”color: #A0A0A8;”>

sahil on September 18, 2012 at 10:06 pm

means … i not understand….

ashokgelal on September 18, 2012 at 10:09 pm

replySent with Sparrow<p style=”color: #A0A0A8;”>

sahil on September 18, 2012 at 10:12 pm

<p style="color: #A0A0A8;">when i run ./1_oraInstaller.sh ,,, i found
OMG! Did you sudo? Run the script without sudo. error
can u give me the solution of this…or can u please tell me how to install oracle on linux server

ashokgelal.com

Coding in a silly or playful way

Kick ass guide for installing Oracle on Ubuntu

Forum Login