Installing Oracle Express Edition 10g R2 on Ubuntu / BlankOn

This article is just an English version of another article of mine here. This article will explain briefly how to install Oracle XE 10g R2 on Debian GNU/Linux based distro such as Ubuntu, BlankOn, etc. The easiest way to install Oracle in Ubuntu/BlankOn is using apt-get or Synaptic. But first we have to add a new entry for Oracle repository in /etc/apt/sources.list because Oracle is not included in Ubuntu official repos. Here's the way to do this step by step:

1. Edit repo's configuration in /etc/apt/sources.list using your favorite editor, in this article I use vim so from a terminal run this command:

sudo vim /etc/apt/sources.list

and add this line to the end of that file

deb http://oss.oracle.com/debian unstable main non-free

2. Run apt-get to update your repo's index, still from terminal run

sudo apt-get update

3. Install Oracle XE using apt-get

sudo apt-get install oracle-xe oracle-xe-client

4. Now, we have to configure our new Oracle server by issuing this command from a terminal

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

At this step we have to answer a few question, just hit enter to use default value.

5. Installation is now finished, we can access Oracle web based interfaced by pointing our browser to http://localhost:8080/apex. Enter 'system' (without quote) as username and your password.

6. If you enter your username and password correctly, you will log in to the administrator page like this

Okay, that's it. Now you have your own Oracle server ready to explore.