Tuesday, July 20, 2010

How to install oracle XE on ubuntu 10.04 64 bit

Recently I had to go though the pain of installing oracle on Ubuntu again in my new laptop. Two years back I did the same installation on Ubuntu 7.10 and cost me two days to complete the installation. But this time things are rather easy.

So here we go.

Before installing
1. sudo apt-get install bc

Then I installed the packet.
sudo dpkg --force-architecture -i oracle-xe_10.2.0.1-1.0_i386.deb

Then I configured the system:
sudo /etc/init.d/oracle-xe configure

Then follow the below steps

1. export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
2. export ORACLE_SID=XE
3. export PATH=$ORACLE_HOME/bin:$PATH
4. sudo apt-get install ia32-libs
5. sudo /etc/init.d/oracle-xe start

If you get bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: No such file or directory error then killer might be missing step 4
sudo apt-get install ia32-libs

References :
[1] http://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/

Guide to install oracle using apt get
[2] http://www.webxpert.ro/andrei/2009/05/31/instal-oracle-10g-xe-on-ubuntu-server-904-jaunty-jackalope/

1 comment:

Unknown said...

nice and thank you....