Installing Oracle 11g R2 Express Edition on Ubuntu 64-bit

This are the steps I took to install Oracle 11g R2 Express Edition on an Ubuntu 12.04 LTS (Precise Pangolin) Server and are based on the tutorial found here:

Download the Oracle 11gR2 express edition installer from the link given below:

http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

( You will need to create a free oracle web account if you don't already have it )

Unzip it :

unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

Install the following packages :

sudo apt-get install alien libaio1 unixodbc vim

The Red Hat based installer of Oracle XE 11gR2 relies on /sbin/chkconfig, which is not used in Ubuntu. The chkconfig package available for the current version of Ubuntu produces errors and my not be safe to use. So you'll need to create a special chkconfig script, below is a simple trick to get around the problem and install Oracle XE successfully:

sudo vi /sbin/chkconfig

(copy and paste the following into the file )

#!/bin/bash
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
file=/etc/init.d/oracle-xe
if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo >> $file
echo '### BEGIN INIT INFO' >> $file
echo '# Provides: OracleXE' >> $file
echo '# Required-Start: $remote_fs $syslog' >> $file
echo '# Required-Stop: $remote_fs $syslog' >> $file
echo '# Default-Start: 2 3 4 5' >> $file
echo '# Default-Stop: 0 1 6' >> $file
echo '# Short-Description: Oracle 11g Express Edition' >> $file
echo '### END INIT INFO' >> $file
fi
update-rc.d oracle-xe defaults 80 01
#EOF

Save the above file and provide appropriate execute privilege :

chmod 755 /sbin/chkconfig

Oracle 11gR2 XE requires to set the following additional kernel parameters:

sudo vi /etc/sysctl.d/60-oracle.conf 

(Enter the following)

# Oracle 11g XE kernel parameters
fs.file-max=6815744
net.ipv4.ip_local_port_range=9000 65000
kernel.sem=250 32000 100 128
kernel.shmmax=536870912

(Save the file)

Note: kernel.shmmax = max possible value , e.g. size of physical RAM ( in bytes e.g. 512MB RAM == 512*1024*1024 == 536870912 bytes )

Verify the change :

sudo cat /etc/sysctl.d/60-oracle.conf

Load new kernel parameters:

sudo service procps start

Verify:

sudo sysctl -q fs.file-max
-> fs.file-max = 6815744

Increase the system swap space : Analyze your current swap space by following command :

free -m

Minimum swap space requirement of Oracle 11gR2 XE is 2 GB . In case, your is lesser , you can increase it by following steps in one of my previous posts.

make some more required changes :

sudo ln -s /usr/bin/awk /bin/awk
sudo mkdir -p /var/lock/subsys
sudo touch /var/lock/subsys/listener

Convert the red-hat ( rpm ) package to Ubuntu-package :

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

(this may take a long time)

Go to the directory where you created the ubuntu package file in the previous step and enter following commands in terminal :

sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb 

Do the following to avoid getting MEMORY TARGET error ( ORA-00845: MEMORY_TARGET not supported on this system ) :

sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=2048m /dev/shm

(here size will be the size of your RAM in MBs ).

The reason of doing all this is that on a Ubuntu system /dev/shm is just a link to /run/shm but Oracle requires to have a seperate /dev/shm mount point.

To make the change permanent do the following :

create a file named S01shm_load in /etc/rc2.d :

sudo vi /etc/rc2.d/S01shm_load

Then copy and paste following lines into the file :

#!/bin/sh
case "$1" in
start) mkdir /var/lock/subsys 2>/dev/null
touch /var/lock/subsys/listener
rm /dev/shm 2>/dev/null
mkdir /dev/shm 2>/dev/null
mount -t tmpfs shmfs -o size=2048m /dev/shm ;;
*) echo error
exit 1 ;;
esac

Save the file and provide execute permissions :

chmod 755 /etc/rc2.d/S01shm_load

This will ensure that every-time you start your system, you get a working Oracle environment.

You can now proceed to the Oracle initialization script

sudo /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).

Before you start using Oracle 11gR2 XE you have to set-up a few more things :

a) Set-up the environmental variables, add following lines to the bottom of /etc/bash.bashrc :

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

b) execute your .profile to load the changes:

source /etc/bash.bashrc

Start the Oracle 11gR2 XE :

sudo service oracle-xe start

The output should be similar to following :

user@machine:~$ sudo service oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
user@machine:~$

And you're done :)