How To : Install and configure Oracle Database Express Edition on Linux

Seasons Greetings!

Coming straight to the point, fortunately we have a debian installer for Oracle Database Express Edition for installation on Linux. In this How- to we go through the steps to install Oracle Database Express Edition and then connect it to Oracle SQL developer. In case you need a How to on installation of Oracle SQL developer on linux (for which debain package is not available), you can read our previous post here.

To install a debian package for Oracle Database Express Edition 10g on Linux mint is a piece of cake. You can download the deb package from http://www.oracle.com/technetwork/database/express-edition/downloads/102xelinsoft-102048.html . You need to create account on Oracle if you don't have it already.

Once the download is complete, double click on the file and the package installs automatically. You may need to enter super user password for authentication if you are logged in as any other user.

After this comes the real twist. Because the browser wont budge to let you open the database homepage. You need to tweak some settings for that.

Follow the below steps precisely depending on system specific changes. I have postedd the expected output of the script as well so that you may face no trouble.

*****************************************************************

vishal-Inspiron-1545 vishal # /etc/init.d/oracle-xe configure

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 to accept the defaults.
Ctrl-C will abort.

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

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

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

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"

*****************************************************************

Now that the database is configured on our Linux machine, you need to go to database home page to do further settings.

Go to Menu > Oracle express edition > Goto database homepage.

Login with User-name as SYSTEM and mention the password that you have entered while configuration in previous step. And do all the setting as mentioned in the guide. It would be unnecessary and redundant if I post the same steps here. Moreover I think the Guide is a excellent step by step teacher for anyone.