Friday, March 15, 2013

Installing Oracle XE on Ubuntu 32-bit

                   For the people who want to install Oracle XE on the 32-bit Ubuntu system but are not able to do the same due to unavailability of the installer , here is some good news. I am sharing the Oracle 10g R2 XE ( express edition ) installer on my cloud space.

The Link : http://1drv.ms/1vMWia6

File size : 220670896
md5sum : 47a83df38f2cbcd78b9a1f110c1c5d92
sha1sum : be666229e036afa85dcc9437d48a418bf65c3468

Use the above link to download the deb installer file.

Note:- For successful installation, following requirements must be satisfied :-
a) 512 MB RAM
b) 1 GB swap-space
c) 1.5 GB of free space in the mount-point containing /usr/lib directory.



For installing the Oracle 10g XE R2 do the following :
1) Install the libaio1 package .
             sudo apt-get install libaio1

2) Install the Oracle 10g XE :
             dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb

3) Configure the installation:
             /etc/init.d/oracle-xe configure

Enter the following configuration information:
  • A valid HTTP port for the Oracle Application Express (the default is 8080) 
  • A valid port for the Oracle database listener (the default is 1521) 
  • A password for the SYS and SYSTEM administrative user accounts 
  • Confirm password for SYS and SYSTEM administrative user accounts  
  • Whether you want the database to start automatically when the computer starts (next reboot).  

4) Set-up the environment variables :
Add following lines to .bashrc of the user which you will using to access the Oracle 10g XE:
  • export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
  • export ORACLE_SID=XE 
  • export PATH=$ORACLE_HOME/bin:$PATH 

5) Start a new shell ( terminal window ) for the changes to take effect or execute the .profile to force the changes made in the same session.
         . ./.profile

6) Use the command "sqlplus sys as sysdba" and the password which you created while configuration to connect to the database.

Have a happy Ubuntu Experience...

Edit:- As the Ubuntu-one services have been stopped, the download link for the deb installer file is replaced with Microsoft One-Drive link . If anyone face problem in downloading from this link, please let me know in the comments.

1 comment:

  1. Excellent,it Worked .I was trying teh 64 bit steps on my 32 bit machine and kept on failing on libraries.
    then used the above steps and it was simple and worked simply without a single error.

    Thanks Manish.

    ReplyDelete