Installing Oracle 10G in ubuntu 10.04 LTS

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:

Code:


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


then 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

I have checked and double checked the instructions myself. I went to the
trouble of uninstalling Squirrel and then reinstalling it again so that
i can take the screenshots in each steps. If it does not work for you,
there is probably something wrong. And remember, starting database is a
lengthy process. Wait at least 2 minutes before you panic and start
shouting "HELP! it is not working!! I can't connect!!" .

Go to http://127.0.0.1:8080/apex and see if your page loads. If it does
not load, It means your oracle database is still being opened, mounted,
instantiated etc etc.

In case you want to uninstall it, there is a folder called uninstall inside the squirell installa
Input System as username, and iit123 as password

You are now all set up


NOTE:

I have checked and double checked the instructions myself. I went to the
trouble of uninstalling Squirrel and then reinstalling it again so that
i can take the screenshots in each steps. If it does not work for you,
there is probably something wrong. And remember, starting database is a
lengthy process. Wait at least 2 minutes before you panic and start
shouting "HELP! it is not working!! I can't connect!!" .

Go to http://127.0.0.1:8080/apex and see if your page loads. If it does
not load, It means your oracle database is still being opened, mounted,
instantiated etc etc. Still if you can't connect.. you probably did something wrong. Post the details under this topic, and we will see what we can do for you.

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

please give the line in text format

oops... sorry :">
edited and given.

rep+

ami install korci.. but how chalaite hoi akhon dekhi nai.... kivabe chalanu jai, arokom akta post dorker ..

bit0112-rokon wrote:ami install korci.. but how chalaite hoi akhon dekhi nai.... kivabe chalanu jai, arokom akta post dorker ..

take a look here

Thanks a lot!!!
I have successfully installed Oracle 10G XE in my UBUNTU 10.10 Very Happy

But when I gave the command

Code:

  lsnrctl start

it says command not found :S But I can log in to oracle as sys.Can't understand whats the problem!

thx alot..