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 Ubuntu-one cloud space.

The Link : http://ubuntuone.com/2wvJRVBirvGD5zUpWCtP2X

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...

No comments :

Post a Comment