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…

Note:– If the above Ubuntu-one link doesn’t work, use this Microsoft One-Drive link

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: