How to install Oracle XE 10g on Ubuntu 10.04 64bit

Once I had a hard time installing Oracle XE -10g on Ubuntu 64bit machine. Since there is no 64bit version of Oracle-XE 10g we have to add some extra lib's for Oracle to work. Following are the steps to install.

1) Download oracle-xe-universal_10.2.0.1-1.1_i386.deb from here.

2) Download libaio_0.3.104-1_i386.deb lib package from here.

3) In command line terminal go to the directory where above 2 files are downloaded.

4) Type : sudo apt-get install bc

5) Then force to install the library : dpkg -i --force-architecture libaio_0.3.104-1_i386.deb 

6) Force to install Oracle XE : dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb

7) After the installation is complete you need to configure the setup :  sudo /etc/init.d/oracle-xe configure

    -- While configuring you will be asked to assign the port numbers (default port numbers are prompted you can give the same).

    -- You will be asked to set a password for SYS and SYSTEM. Never ever give the password as "admin" you will not be able to log in after oracle is started.

       (It was the lesson I learned after struggling couple of hours, interesting that oracle doesn't support the password 'admin' :-) ). 

       Remember to give a password with more than 8 characters.

8) After configuration is complete you have to set environment variables for Oracle.

    -- Open your bashrc : sudo gedit /etc/bash.bashrc

    -- And add the following variables and save the file :

        ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

    PATH=$PATH:$ORACLE_HOME/bin
    export ORACLE_HOME
    export ORACLE_SID=XE    export PATH

9) It's done!! Now, to start the server : sudo /etc/init.d/oracle-xe start  (you can use start, restart, stop arguments also)

10) To start with 'sqlplus' enter the following in command line: sqlplus sys as sysdba

     Or you can go to the admin console from the  browser: http://127.0.0.1:8080/apex

--------

11) If you want to completely remove oracle : sudo dpkg -P oracle-xe-universal