Re-install oracle-xe on Ubuntu

Posted: September 27, 2008 in HowTo, Oracle, Tips
Tags: , ,

Quite confuse when you want to re-install oracle-xe on Ubuntu. Struggling for several hours googling, I found this tip:

1. Run “sudo dpkg -P oracle-xe-universal” to get Ubuntu remove all the files as well as configuration files.

2. Delete folder: “/usr/lib/oracle/xe”

3. Restart the machine

4. Install the oracle-xe package.

5. Run “sudo /etc/init.d/oracle-xe configure" to have oracle-xe be setup

6. Access the nice Oracle web interface by pointing your Firefox to: http://127.0.0.1:8080/apex to check if everything went fine...

7. Have fun…

^^

MinhTran

Comments
  1. cs02rm0 says:

    Very useful post, thanks!

  2. har says:

    You helped me a lot!
    Thanks!

  3. Martin says:

    Thanks a bunch mate! Saved my day

  4. dbametrix says:

    Hi,

    Excellent sharing. Thanks for same.

    Regards,
    Dbametrix
    http://www.dbametrix.com

  5. oldlight says:

    May you guys find peace of mind….

    ^^

  6. I was having the error below because I did not have the idea to add this “-P” parameter. Thanks a lot for the tip!

    The install cannot proceed because a database instance named ‘XE’ appears to be
    configured on the system. Delete the instance, remove the entry corresponding
    to this instance from the oratab file (/etc/oratab), and retry the installation.
    dpkg: error processing /var/cache/apt/archives/oracle-xe-universal_10.2.0.1-1.1_i386.deb (–unpack):
    subprocess new pre-installation script returned error exit status 1
    Errors were encountered while processing:
    /var/cache/apt/archives/oracle-xe-universal_10.2.0.1-1.1_i386.deb
    E: Sub-process /usr/bin/dpkg returned an error code (1)

  7. Jeff C says:

    Thank you, thank you, thank you.

    I have been trying for the past 24 hours to re-install Oracle XE on Ubuntu because I did not have the host name right the first time I did it. And you know how picky Oracle can be about host names.

    Anyway, I could never reconfigure the re-installation because it always said that “Oracle has already been configured”. Even though that configuration was now wrong. This fixed it. Thanks again.

  8. kowser says:

    You just saved my time

  9. mario lopez says:

    2. Delete folder: “/usr/lib/oracle/xe”

    2.1 adicionalmente borre el oratab

    sudo rm /etc/oratab

    esto con la finalidad de no encontrar error en la instalacion

    3. Restart the machine

    por lo demas excelente, buena ayuda, felicitaciones

  10. Ashish says:

    Yes ,its very usefull blogs .!!!!!!!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s