Install Oracle 10g XE in Ubuntu 10.04 64-bit
This is an aggregate instruction on how to install Oracle 10g XE in Ubuntu 10.04 64-bit. As I’ve updated my system to 64-bit this is that I found:
First of all we need to be sure that we have installed the 32 bits libraries.Open the terminal and run the following command
sudo apt-get install libc6-i386
After this we do the following. We have to download Oracle 10g XE.We download it from Oracle official site.
We also have to download an extra deb package. For that we to the following
wget -c http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb
When we got this two packages. We have to force the installation of oracle.
dpkg -i --force-architecture libaio_0.3.104-1_i386.deb
Extract the deb file, open Oracle-xe-universal_10.2.0.1-1.0_i386/DEBIAN/control and remove the dependency for libc6 so you end up with:
Depends: libaio (>= 0.3.96) | libaio1 (>= 0.3.96)
Then cd to the directory that contains the extracted folders and do a dpkg-deb --build oracle-xe-universal_10.2.0.1-1.0_i386 && sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb
When the installation is ready. We need to configure it
sudo /etc/init.d/oracle-xe configure
and we edit the ~/.bashrc
gksudo gedit ~/.bashrc
Add the following lines and save the file
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE
export PATH
Fix some issues you could add your user to DBA group
sudo usermod -a -G dba your_username
also fix issue that DBA group can not start listener
sudo chmod g+w /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
After this Gnome menu links “Start Database” and “Stop Database” should work.
If you like enable database auto start then
sudo nano /etc/default/oracle-xe
and change line
ORACLE_DBENABLED=false
to
ORACLE_DBENABLED=true
And get enviroment variables set correctly
sudo nano /etc/profile
add line end of file
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
then
sudo cp /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh_original
sudo nano /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh
and change first line
#!/bin/sh
to
#!/bin/bash
