How To Install Oracle XE in Ubuntu 64 Bit

May 12th, 2008

While you’re thinking by installing 64 bit linux you’re standing in the edge of new technology era, it sucks knowing our 64 bit system is less supported than the old 32 bit system. We have to install 32 bit flash since Adobe didn’t have the 64 bit one. We have to install 32 bit oracle xe since Oracle also didn’t have 64 bit version.

And now I will try explain how to install oracle xe into the 64 bit system, ubuntu way. Of course we couldn’t follow the guide from oracle, since apt-get will detect our system architecture and we won’t get the 32 bit packages list.

Before we start, make sure you have the 32 bit library installed. It’s in reposity, all you have to do is

sudo apt-get install libc6-i386

The next thing to do is download the files needed. It’s libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb. You could use wget for this

wget -c http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe-universal_10.2.0.1-1.1_i386.deb.

After your downloads are finished, we continue to the main issue, forcing the package to be installed. You could try to install with usual dpkg -i first to make sure your system is really 64 bit.

sudo dpkg -i libaio_0.3.104-1_i386.deb

You’ll get error,

dpkg: error processing libaio_0.3.104-1_i386.deb (--install):
package architecture (i386) does not match system (amd64)
Errors were encountered while processing:
libaio_0.3.104-1_i386.deb

Added guide from Venka A

sudo apt-get install bc

To force the installation, do these

dpkg -i --force-architecture libaio_0.3.104-1_i386.deb
dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb

And after the installation is finished, you need to configure it

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

and edit your ~/.bashrc

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

And, voila, the oracle xe is ready. You could go to http://127.0.0.1:8080/apex from your browser.

References:

howto, linux, ubuntu · 45 Comments

Comments

45 Responses to “How To Install Oracle XE in Ubuntu 64 Bit”

  1. Dave’s Tech Blog » Blog Archive » Installing Oracle XE on Ubuntu 64bit on May 26th, 2008 3:07 am

    [...] trust myself to remember « Installing Oracle on UbuntuInstalling Oracle XE on Ubuntu 64bithttp://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/ Published in:Uncategorized |on May 26th, 2008 |You can leave a response, or trackback from your [...]

  2. addchild314 on June 11th, 2008 7:04 am

    Thanks so much for this guide! I have been trying to install compiere, which, of course, only runs with Oracle (for now). I spent hours trying to configure the full version of oracle, until I stumbled across this! It was so easy, then.

    Thanks again!

  3. Venka A on June 19th, 2008 12:14 am

    Great guide! I used this to install Oracle XE on an Ubuntu 8 AMD64 linux box. Just wanted to point out that I needed to add the BC package by running this command:

    sudo apt-get install bc

    before running these commands:
    sudo dpkg -i –force-architecture libaio_0.3.104-1_i386.deb
    sudo dpkg -i –force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb

  4. little brain on June 19th, 2008 8:17 am

    thank you :)
    I’ll add to the post

  5. M.B. on June 28th, 2008 10:26 am

    Hi…This tutorial is invaluable. I followed all the steps and installed Oracle 10g XE on an amd64 Ubuntu Feisty, one problem though.

    During the configuration, I chose NOT to start the db upon start up. While everything worked when I installed, once I rebooted, I can not connect to the DB home page from FireFox. I did a little diggin’ and it seems that the listener did not start. When I try to re-configure via:
    [b]sudo /etc/init.d/oracle-xe configure[/b]
    I get [b]Oracle Database 10g Express Edition is already configured
    [/b]
    Any idea how to solve this?

  6. little brain on June 28th, 2008 9:41 pm

    M.B
    thank you ;)
    have you start the db?

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

  7. M.B. on June 29th, 2008 5:03 am

    Starting the database does not do anything, still can’t access the home page from FF or Opera.

  8. little brain on June 29th, 2008 12:39 pm

    any spesific error?

  9. morph on July 3rd, 2008 4:01 am

    Hi.

    At first, thanks for the great tutorial.

    It worked great until the next reebot ;-) .
    Then I had the same problem like M.B.

    The only successfull way to solve the problem, was the following:

    dpkg -purge “oracle package name”

    and reinstall oracle with the the option “run on startup”.

    After that I was able to reconfigure it.

    For shure this is not the cleanest way to solve the problem, but after searching for hours the most effective ;-)

  10. A Quick 64 bit Update « Maclochlainn’s Weblog on July 27th, 2008 2:08 am

    [...] Pet peeves include: (1) The Microsoft patching progrm auto detects x64 and chooses to install IE x64 when Flash is 32 bit and inoperable with 64 bit browsers; (2) VMWare Workstation disallows installation of 64 bit OS when running on Vista Home x64 (appears to require Vista Business or Ultimate); and (3) the work arounds required to install Oracle XE on Ubuntu x64. [...]

  11. Gerben de Vries on August 22nd, 2008 9:35 pm

    Reconfiguring can be done by editing the file /etc/default/oracle-xe.

    Change true in the line: ‘CONFIGURE_RUN=true’ to false

    i.e.with: sudo gedit /etc.default/oracle-xe

  12. Iveen Duarte on September 20th, 2008 8:19 am

    Thanks for this amazing and useful tutorial, it worked like a charm, I now have Oracle XE running on my Ubuntu 8.04.1 AMD 64 box.

  13. Oracle c.d. | mabateus on November 21st, 2008 4:37 am

    [...] ale wersje 32bitowa bardzo ładnie działa pod 64bitowym linuksem. Podziękowania dla autora tego opisu. [...]

  14. i should be coding :: oracle xe 10gr2 on kubuntu 64-bit on November 23rd, 2008 8:48 am

    [...] needs to be reinstalled, but I can’t find an archive for it.And finally, when I resorted to using this excellent guide instead, I ran into this problem because of the earlier failed installation.dpkg: regarding [...]

  15. realist on November 27th, 2008 5:58 am

    You rock, buddy!!!! Thx a million!!!!

  16. Ranbir on January 10th, 2009 11:15 am

    Hi,

    I followed your instructions to a T and get the following error:

    TNS-12537: TNS:connection closed
    TNS-12560: TNS:protocol adapter error
    TNS-00507: Connection closed
    Linux Error: 29: Illegal seek

    I’ve searched for a few hours on the “Illegal seek” message which most forums out there blame on the /etc/hosts file not having the following reference:

    127.0.0.1 localhost.localdomain localhost

    uname -a gives me:

    2.6.24-21-generic #1 SMP Tue Oct 21 23:09:30 UTC 2008 x86_64 GNU/Linux

    any ideas?

    thanks.

    Ranbir

  17. Gerson Silveira on January 31st, 2009 11:50 pm

    Thank you very much. It worked exactly as you told.

    Thanks

    Gerson

  18. Spider on March 2nd, 2009 12:54 pm

    I can find the prayer I want. I thank God for this website.r

  19. Matt W on April 2nd, 2009 3:42 am

    short read in buffer_copy (backend dpkg-deb during `./usr/lib/oracle/xe/app/oracle/product/10.2.0/server/jdbc/lib/ojdbc14_g.jar’)
    Errors were encountered while processing:
    /home/matwol/Desktop/oracle-xe-universal_10.2.0.1-1.1_i386.deb

  20. Confluence: TQM-Team CC USIM on April 7th, 2009 10:01 pm

    Oracle…

    TQM Oracle Datenbank Oracle ist zur Zeit auf dem tqmweb10 in der kostenlosen und abgespeckten Variante OracleXE installiert Oracle starten /etc/init.d/oraclexe start Nachfolgend die Schritte, die früher (alter tqmweb09) notwendig waren bzw…….

  21. hugo on April 14th, 2009 2:56 am

    thank you, worked like a charm.
    I am on Ubuntu 8.10 with lib_aio1 installed. It said lib_aio conflicted with lib_aio1, went on anyway and installed ok !

    hugo

  22. Jbringolf on May 14th, 2009 7:35 am

    Not having a problem getting ORacle-xe to run under Ubuntu AMD64 but cannot seem to get PHP5 and OCI8 to work with it. Seems all installs involve InstantClient and not the full XE installed. Anyone have success with AMD64 Ubuntu 9 Oracle-xe 10 and PHP5 with oci?

  23. Fábio T. da Costa on May 24th, 2009 8:05 am

    To solve the problem of oracle starting, just use this commands:

    sudo /etc/init.d/oracle-xe enable
    sudo /etc/init.d/oracle-xe start

  24. chris on June 4th, 2009 11:20 pm

    Hi there,

    i did all the steps from above and am stuck now with the problem that the listener does not start. i cannot even execute lsnrctl in the command line.

    $ sudo /etc/init.d/oracle-xe start
    Starting Oracle Net Listener.
    Starting Oracle Database 10g Express Edition Instance.
    Failed to start Oracle Net Listener using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr and Oracle Express Database using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus.

    $ lsnrctl
    $ bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl: No such file or directory

    or:

    $ sudo /etc/init.d/oracle-xe status
    $ bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl: No such file or directory

    even if i go directly into the bin-dir and execute
    $ ./lsnrctl
    i get the same error.

    This seems pretty weird, does anybody got an idea?

  25. chris on June 5th, 2009 12:16 am

    ok, sorry i forgot to execute

    > sudo apt-get install libc6-i386

    now its working fine … thanks a lot!

  26. sei on July 8th, 2009 10:23 am

    Perfect! Thanks so much for sharing your knowledge.

  27. Alexander on July 8th, 2009 11:18 am

    You advise me about
    > sudo apt-get install libc6-i386
    thanks a lot!

  28. megalink on July 22nd, 2009 11:55 am

    Perfect on Ubuntu Jaunty 64bit edition.
    Thanx!

  29. venkat on August 11th, 2009 12:52 am

    Thanks for the instructions. It worked perfectly on ubuntu 9.04.

    Thx
    Venkat

  30. loljak on August 20th, 2009 1:49 am

    Thanks, The instructions work fine with a debian Lenny too. Great job.

  31. Anonymous on August 22nd, 2009 11:10 am

    [...] 10g.RC2 (10.2.0.1) | Ubuntu 9.04 – Ubuntu Forums

  32. bambrikii on August 29th, 2009 9:10 pm

    many thanks!

  33. cml.co on September 3rd, 2009 6:16 am

    Thanks, good guide. It Works fine with a ubuntu server 9.04

  34. 6m on October 21st, 2009 9:34 pm

    It also worked perfectly for me, on a debian distrib.
    Now, let’s play with Oracle !

    thanx a lot !

  35. Rodrigo on November 5th, 2009 4:32 am

    How To Ubuntu 64

  36. Pim on November 8th, 2009 5:32 pm

    Dude, you need a Nobelprice for peace, i was about to kill somebody over this and you (and fabio) solved it !

  37. Kris on November 18th, 2009 6:27 am

    Thanks man, this really is the shit!

  38. Jürgen Kill on December 8th, 2009 5:58 pm

    Vielen Dank (Thanks) für diese Anweisung.

    Läuft hervorragend. Allerdings Vorsicht beim einem Kernelwechsel…dann muss die DB neu installiert werden, also vorher sichern!!!

  39. mayu on December 16th, 2009 10:05 am

    Thanks everybody, because your answers help me to resolve my problems.
    Thank a lot, my oracle db works perfect.

  40. Drazen on December 17th, 2009 3:28 pm

    I love you man! Hope Santa is nice to you this year. You deserve it for making life easier.

    Oracle though… I think Santa has a lump of coal for Larry Ellison ;-)

  41. tnagle on January 5th, 2010 8:19 am

    Thank you! Worked like a charm on slicehost.com Debian Lenny 512 slice.

  42. Gil Standen on January 7th, 2010 1:01 pm

    This IS a priceless and great guide. Thank you for publishing it.

  43. Anderson Fabiano on January 15th, 2010 4:27 am

    Hi Matt W,

    short read in buffer_copy … … …
    Is caused by a corrupted .deb file.

    Redownload the .deb file and run dpkg again.

    - Anderson

  44. Venkat on January 15th, 2010 11:23 am

    Thanks it worked perfectly on Ubuntu 9.10 Thanks again for the great article.

  45. Installing Oracle Express on 64 bit Ubuntu | Freddy on January 22nd, 2010 11:31 pm

    [...] http://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/ [...]

Leave a Reply