Oracle provides Oracle Database 10g Express Edition for Linux, free to develop, deploy, and distribute. It is available for  Debian, Mandriva, Novell, Red Hat and Ubuntu.Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine. Download it here

Download the corresponding .deb package from the site. Then install it by running the command

$ dpkg -i <package name>

You have to add the existing user to the dba group to get it working. So move to System->Administration->Users and Groups and add the user to dba group(Selecting the user and moving to Advanced tab).

Then run on terminal the following command to configure it.


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

This will show options. Except for the password press enter.

Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

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

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

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]:n

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"

Then go to http://127.0.0.1:8080/apex to see the administartion page. Give system as username and above entered password.

If you want to create a table/database. Go to Application-> Oracle Database 10g Express Edition-> Run SQL Command Line in Ubuntu Menu. Then give the following command to connect to the database.[ Make sure that Oracle is allready started by clicking on Start Database option.]

connect / as sysdba

It will show connected.

 

---

Add this page to your favorite Social Bookmarking websites