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
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
sudo /etc/init.d/oracle-xe configure
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:
sudo usermod -a -G dba lordamit
3. Enable the listener mood for your user by typing in terminal:
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:
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:
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
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:
sudo chmod 777 /var/tmp/.oracle/
And start the listener by this command in terminal:
Input System as username, and iit123 as password
You are now all set up