How to Setup Oracle 10G XE in Ubuntu

Hi there

First of all, collect the oracle 10G express edition debian installer from oracle.

then at first install the debian library called libaio1_0.3.107-3ubuntu2_i386

Code:

sudo apt-get install libaio1

then, install the oracle 10G express edition by double clicking on it.





1. Configuring Oracle
open terminal(you can open it directly by pressing ctrl+ alt + T), and type

Code:

sudo /etc/init.d/oracle-xe configure

press enter.

it will ask for ports, first enter 8080 and then enter 1521

then, it will ask for password. We are going to use iit123

you will not be able to see the password when you type it.

It will again ask you for the password for confirmation.

Input iit123 again.

It will ask for whether to start Oracle on boot. Type n and press enter.


After configuring it will show that Installation completes successfully.



2. Configuring Oracle permission For your user:

Lets assume your username in Ubuntu is lordamit. open terminal and type:

Code:

sudo usermod -a -G dba lordamit

3. Enable the listener mood for your user by typing in terminal:

Code:

sudo chmod g+w /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

4. Set the Environment variables set for everyone by typing in terminal:

Code:

sudo ln -s /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh /etc/profile.d/oracle_env.sh

5. open nls_lang.sh by typing this in terminal:

Code:

sudo gedit /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh

Change #!/bin/sh to #!/bin/bash in nls_lang.sh like this screenshot



6. set your username oracle active and give it password by typing in terminal:

sudo passwd oracle

We are going to use iit123 as password here too.



7. Final configurations:

open terminal, and type

Code:

sudo gedit ~/.bashrc

go to the end of file and paste the following lines just like this:

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

MAKE SURE THAT THE TEXT YOU PASTED LOOKS LIKE THE TEXT FILE IMAGE HERE. NO extra lines or Spaces!!

save and close it.

8. finally, give the permission to listener by giving this command in terminal:

Code:

sudo chmod 777 /var/tmp/.oracle/

Now, you can start oracle like this:


And start the listener by this command in terminal:

Code:

lsnrctl start

Now, you can go to this address:
http://127.0.0.1:8080/apex
from browser
Input System as username, and iit123 as password

You are now all set up