Install Oracle 10g XE on ubuntu

1) download oracle  oracle-xe-universal_10.2.0.1-1.0_i386.deb from the oracle official website


Then

sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb



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

It will ask the value for some option like

Specify the HTTP port that will be used for Oracle Application Express [8080]:7070


By default the port number is 8080, be care full make sure the same port is not used by any other process, In my case tomcat is already on 8080 so i changed to 7070.

Similarly :
Specify a port that will be used for the database listener [1521]:1521

Then Specify the Password and confirm password  and restart the datatabase like

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:y








It Will restart the oracle and now oracle ready to use

You can try it from SQL command line or from http://127.0.0.1:7070/apex

In the above link change the port number accordingly ,what ever you mentioned in the configuration file

from the command line  of SQL, give the command

connect system/manager   i.e

Note: The default database name of 10g is xe.