how to install oracle 10g express edition in ubuntu

[ths tutorial is still not finished. If you still want to continue with it.... do it in your own risk]
let us make it very much short . this is for the 32 bit os. these are the things you will need for the installation:

libaio1 [may be. i will explain it later.] you may download the .deb file from here.
oracle 10g express edition. download it from the official oracle website. [download the universal edition]

ok if we have these two .deb files we can start our installation.

1. double click the oracle 10g installation file. it will check some dependencies. if some files are missing it will let you know. depending on that you have to install some more packages. it is almost certain that you will need libaio1 package. if it is required then just install it from the deb file you just downloaded. if there are no dependencies to be satisfied then install the package.

2. after the installation is finished you need to configure it. for that open the terminal and type

Code:


/etc/init.d/oracle-xe configure

it will ask for some port numbers. just press enter. it will keep the default port. it will also ask for the password. give it and then confirm it. then it will ask to whether to start it at startup or not. I would recommend no.

3. Now you have to add it to the bash. in the terminal type

Code:


sudo gedit ~/.bashrc


at the end of the file add

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


now restart your pc.

4. At the time of login you will see a new account. dont worry by seeing it. now after logging into your normal account move to system>administration>user and groups. there select and enable that new account and set a password for that. now click on the manage group option. you will see a list of groups . select dba and click on properties. check your account and that new account (probably it will be named as oracle).

5. reboot it again. now login into that new account or your own account and start the database by applications>oracle database(something like that)>start database.
you can now access the database. for testing paste this link to the browser

http://127.0.0.1:8080/apex

6. for giving sql command just type the following in the terminal

Code:


sqlplus sys as sysdba


it will ask for the password. give it

All right then, you are all done. enjoy

[for more information there is another similar post in this section given by amit. You may see that]

just in case, in the url
http://127.0.0.1:8080/apex

you need to input username : "system"
and password as the password you chose to gave.

reboot it again. now login into that new account or your own account and start the database by applications>oracle database(something like that)>start database.
you can now access the database. for testing paste this link to the browser

Also, you need to start the listener. In terminal, type

Code:

lsnrctl start


if it gives you any error like this:

Code:


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-JUL-2010 14:48:07

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
  Linux Error: 1: Operation not permitted



just write in terminal

Code:


sudo chmod 777 /var/tmp/.oracle/


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

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!

BIT0129-tabassum wrote:Thanks a lot!!!
I have successfully installed Oracle 10G XE in my UBUNTU 10.10

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!

I assume that you were so busy expressing your joy, you didn't notice the last post before you posted.

I installed Oracle 10G following the instarction of your (Amit) blog, But after installing..I have faced that problem and I replied here to have a solution.

Any why, exactly, do you think that this topic was made?

I saw the heading earlier but I didn't go through it.

So you followed the instruction I wrote and you are asking question to Alim.

Indeed, hilarious.

perhaps you didn't notice this part in this topic:

BIT0103-Ovid wrote:
[ths tutorial is still not finished. If you still want to continue with it.... do it in your own risk]
let us make it very much short . this is for the 32 bit os. these are the things you will need for the installation:

I noticed Alim's 1st line. But I asked my problem related question here seeing your reply -

BIT0122-Amit wrote:

Also, you need to start the listener. In terminal, type

Code:

lsnrctl start


And your question belongs to that topic, not here.

edit:
Two tutorials, same subject. Both unlocked. one unfinished.

I wonder why one is not locked.... yet.

The mistake happened because I didn't go through the topics, I just saw it first..and ask about my problem.

I didn't get that the solved topic is "Installing Oracle 10G in ubuntu 10.04 LTS"
This topic should be locked then, people will be confused seeing two topics like me.
May I lock this topic?

Topic has been locked due to unfinished and incorrect process.
Go through this link to Install Oracle 10G express edition in ubuntu.