Configuring Oracle Database 10g in Ubuntu - Oracle

Before you can properly use the database, you need to configure it for its first use. Follow the steps below:

1.) In the terminal command line. Login as root:

codex-m@codex-m-desktop:~$ sudo -s -H

2.) Run the configuration command:

root@codex-m-desktop:/home/codex-m# /etc/init.d/oracle-xe configure

2.) You will then need to specify an HTTP port that will be used for Oracle application express: type 8080

3.) You will need to specify a port that will be used for database listener: type 1521

4.) You also need to specify a password for database accounts. Please remember this and write it down in a safe location.

5.) If you see the message: “Do you want Oracle database 10G express edition to start on boot". Type "n" for no. Most of the time you type no if you are not going to use Oracle on a daily basis; otherwise choose yes.

The configuration can take some time to complete, so be sure not to close the terminal until you see the message: “Installation Completed Successfully.” See the screenshot below:

Starting Oracle Database 10g Express for the First Time

After successful installation, you still need to confirm that you can run and start the Oracle database. Do the following steps:

1.) Go to Applications – Oracle database 10g Express Edition and then click “Go to Database Homepage”.

2.) Login using the following credentials:

Username: System
Password: {the password you used during the configuration}

3.) If things are working well, you should see the dashboard of the database, as shown here:

Note: In this installation, your system will automatically create an Ubuntu username known as “Oracle”. You can view it every time you restart your computer. This username does not have root privileges and you can use this for Oracle related transactions in your system.

If you have problems starting Oracle for some unknown reason, log out with your current Ubuntu username and login as “Oracle” to start the database session.