Kick ass guide for installing Oracle on Ubuntu
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
2. Extract Oracle database downloaded from Oracle to a folder (such as in your home folder)
3. 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.
4. Open 4_OraInstaller.sh in a text editor and change the name of your database instance (dbSID). The default is oraIntrepid.
5. 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
6. Make sure you have at least 3gb free space where you want to install your Oracle DB
7. Execute: $./1_OraInstaller.sh
You need to logoff and login once
8. 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!!!
9. Execute: $./3_OraInstaller.sh
You need to restart you computer once at this point.
10. 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:
No related posts.
wilson Says:
excellent guide and scripts. install was a doodle
Posted on January 22nd, 2009 at 1:08 pm
sasha nikitin Says:
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
Copyright (c) 1982, 2007, Oracle. All rights reserved.
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’.
Posted on June 10th, 2009 at 3:25 am
Lawson Says:
Your script #3 broke my server! It never came back from a reboot….
Posted on June 10th, 2009 at 2:27 pm
Sekhar Says:
Hi Ashok,,
Can you tell what theme you are using on your ubuntu.
Its looking cool man.
Thanks and Regards
Ratna Sekhar
Posted on October 8th, 2009 at 7:09 am
dk Says:
Error running the second script:
database/install/response/ee.rsp not found
Posted on October 19th, 2009 at 6:53 pm