« 
 »
31 05 2009

Install Oracle 10g XE on Ubuntu Server 9.04 Jaunty Jackalope

Posted by: andreiash in Database, Linux, Oracle

xe_logoBest way to have a easy to access XE database and APEX on top of it is to put them on a Ubuntu Server virtual machine that I start just when I need.

Installation of 10g Express Edition should not take more than 10 minutes and the steps are below:

1. Prepare the swap space
If you have less than 1GB memory run the following commands to create swap space:

$ sudo dd if=/dev/zero of=/swpfs1 bs=1M count=1000
$ sudo mkswap /swpfs1
$ sudo swapon /swpfs1

2. Add new Aptitude source and get the GPG key for Oracle
2.1. First modify /etc/apt/sources.list file:

$ sudo vi /etc/apt/sources.list

2.2. Append following line:

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

2.3. Save and close the file. Next import GPG key:

$ wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

2.4. Update package database:

$ sudo apt-get update

3. Install Oracle 10g XE:

$ sudo apt-get install oracle-xe

4. Post-install configuration
4.1. You must configure Oracle TCP/IP port and other parameters. Simply type the following command:

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

4.2. Add environment variables in .profile

$ cd ~
$ vi .profile

Add the following lines:

export ORACLE_SID=XE
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export PATH=$PATH:$ORACLE_HOME/bin

Good luck,
Andrei

Related posts:

  • Oracle APEX 3.1 installation on Oracle Database 10g XE
  • Ubuntu 9.10 Karmic Koala released
  • Disadvantages of using Oracle Database 10g XE (Express Edition)
  • Oracle Database 11g Release 2 available on Windows… finally
  • Install subversion for VPS (cPanel) under CentOS
    • Tags: , , , , ,

    This entry was posted on Sunday, May 31st, 2009 at 9:32 am and is filed under Database, Linux, Oracle.You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

    17 Responses to “Install Oracle 10g XE on Ubuntu Server 9.04 Jaunty Jackalope”
    1. hamza says:
      June 10th, 2009 at 4:56 pm

      i did this steps on ubunto desktop 9.04, the installation completed, but post installation steps didnt,

      $ sudo /etc/init.d/oracle-xe configure –> sudo: /etc/init.d/oracle-xe: command not found

      your advice please

    2. andreiash says:
      June 10th, 2009 at 5:41 pm

      are you sure that installation was successful ?
      Just do the apt-get install once again to make sure it was.

    3. loetmann says:
      August 25th, 2009 at 2:51 am

      thanks a lot for this short tutorial. It´s great since I love to separate my development environments in virtual machines. But since you installed it in the server edition I guess you have not prepared X11 in order to run a javascript-capable browser like FireFox to switch HTTP Access to “Availlable from local server and remote clients”

      How did you manage this issue?

      Regards

    4. Dhanjai says:
      September 2nd, 2009 at 12:42 pm

      Excellent! This is very helpful

    5. deepak says:
      September 28th, 2009 at 4:39 pm

      hi andre !
      i read ur guidelines. But i didn’t figured out my problem. I have oracle-xe*…..*.deb package of oracle.
      and i tried command like $sudo dpkg -i oracle*
      But it end with command errors want installation stopd working.
      I really appreciate ur efforts if u can help me.

    6. andreiash says:
      October 1st, 2009 at 12:26 am

      what exactly are these errors saying?

    7. camestres.com » Links for 19/11/2009 says:
      November 19th, 2009 at 1:07 pm

      [...] Install Oracle 10g XE on Ubuntu Server 9.04 Jaunty Jackalope » Andrei DANEASA’s Blog – [...]

    8. Figo says:
      November 30th, 2009 at 10:07 pm

      Hi Andrei,
      Upon following your tutorials to install 10g EX… at #2.4….update package database, mine failed to fetch the packages giving me the following message at the end:

      W: Failed to fetch http://oss.oracle.com/debian/dists/unstable/Release Unable to find expected entry main/binary-amd64/Packages in Meta-index file (malformed Release file?)

      E: Some index files failed to download, they have been ignored, or old ones used instead.

      could you pls help find why b’cos #3 is failing too. Thank you.

    9. andreiash says:
      November 30th, 2009 at 11:10 pm

      there is no such folder “binary-amd64″.
      As there is no official support for XE and also Ubuntu Server, please ask this on XE oracle forum. Guys from development are always keeping an eye on forums and you can get a good answer there.

      If you’ll make it work please share the answer with me here.

    10. andreiash says:
    11. Figo says:
      December 1st, 2009 at 1:40 am

      Hi,
      Ok and thanks for your response.

    12. kenjiru says:
      December 1st, 2009 at 1:59 am

      Hello Andrei,

      I’m trying to install Oracle 10g XE on Ubuntu 9.10 32bits, but I’m getting the following error:
      Setting up oracle-xe-universal (10.2.0.1-1.0) …
      Executing Post-install steps…
      sh: Can’t open /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/install/sqlnet/setowner.sh
      -e You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.

      There is no file /etc/init.d/oracle-xe configure, I guess the installation stops at the setowner.sh.

      Any idea what to do?

      Thanks!

    13. andreiash says:
      December 1st, 2009 at 9:41 am

      are you sure the file oracle-xe is not there? maybe you don’t have permissions. “configure” is a parameter passed to that executable.
      and don’t forget sudo

    14. kenjiru says:
      December 1st, 2009 at 5:02 pm

      I was trying to install the .deb downloaded from the oracle website, not the one from the repository. I’ll give it another try when I’ll have a decent wireless connection.

      Thank you for help.

    15. Who??? says:
      December 29th, 2009 at 7:47 pm

      THANKS ANDREIASH,…. GREAT TUTORIAL!!!!!!!!!! ); :) ;)
      I FINALLY installed Oracle 10g XE!!!!!!!!! ;) ;)

    16. Raphael says:
      January 1st, 2010 at 5:30 pm

      I have installed successfully but anytime i try to login with the credentials i specified during the installation, it denies me access.
      This is with the console and the web interface.
      Pls help me out!

      Thanks

    17. andreiash says:
      January 22nd, 2010 at 11:41 pm

      I have no idea why this is happening. It might have something to do with your packages, like you missed to install a package and now you’re getting a strange error.

    Leave a Reply