How To Install Oracle XE in Ubuntu 64 Bit

Posted on May 12, 2008 by Aldiantoro Nugroho

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:

About Aldiantoro Nugroho

full-time dreamer.
This entry was posted in howto, linux, ubuntu and tagged , . Bookmark the permalink.
  • Macps
    this is very important info! Thanks a lot!!
  • It worked perfectly on Ubuntu 10.04 64bits Desktop Edition, but I tried several times in Ubuntu 10.04 64bits Server Edition without success.. Have anyone got it working on server edition??

    The only thing I did other way is put the paths on the profile.d:
    sudo vim /etc/profile.d/oracle-xe.sh
    sudo chmod ug+x /etc/profile.d/oracle-xe.sh
  • ivanatpr
    if you get invalid login credentials in apex after doing this, add yourself the dba group (via usermod) and then do "sqlplus / as sysdba". This will connect you to the DB using OS authentication. Once you connect you can change the password for sys via an alter user statement.
  • Steven
    Worked like a champ, awesome; thanks for the work!
  • Venkat
    Thanks it worked perfectly on Ubuntu 9.10 Thanks again for the great article.
  • Anderson Fabiano
    Hi Matt W,

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

    Redownload the .deb file and run dpkg again.

    - Anderson
  • This IS a priceless and great guide. Thank you for publishing it.
  • tnagle
    Thank you! Worked like a charm on slicehost.com Debian Lenny 512 slice.
  • 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 ;-)
  • mayu
    Thanks everybody, because your answers help me to resolve my problems.
    Thank a lot, my oracle db works perfect.
  • 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!!!
  • Kris
    Thanks man, this really is the shit!
  • Pim
    Dude, you need a Nobelprice for peace, i was about to kill somebody over this and you (and fabio) solved it !
  • Rodrigo
    How To Ubuntu 64
  • 6m
    It also worked perfectly for me, on a debian distrib.
    Now, let's play with Oracle !

    thanx a lot !
  • cml.co
    Thanks, good guide. It Works fine with a ubuntu server 9.04
  • bambrikii
    many thanks!
  • loljak
    Thanks, The instructions work fine with a debian Lenny too. Great job.
  • venkat
    Thanks for the instructions. It worked perfectly on ubuntu 9.04.

    Thx
    Venkat
  • megalink
    Perfect on Ubuntu Jaunty 64bit edition.
    Thanx!
  • Alexander
    You advise me about
    > sudo apt-get install libc6-i386
    thanks a lot!
  • sei
    Perfect! Thanks so much for sharing your knowledge.
  • chris
    ok, sorry i forgot to execute

    > sudo apt-get install libc6-i386

    now its working fine ... thanks a lot!
  • chris
    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?
  • 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
  • Jbringolf
    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?
  • hugo
    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
  • I can find the prayer I want. I thank God for this website.r
  • Gerson Silveira
    Thank you very much. It worked exactly as you told.

    Thanks

    Gerson
  • Ranbir
    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
  • realist
    You rock, buddy!!!! Thx a million!!!!
  • Iveen Duarte
    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.
  • Gerben de Vries
    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
  • morph
    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 ;-)
  • M.B.
    Starting the database does not do anything, still can't access the home page from FF or Opera.
  • M.B.
    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?
  • Venka A
    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
  • 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!
blog comments powered by Disqus