22

I need a Step By Step guide for Installing Oracle Database Express Edition version 11g Release R2 on Ubuntu Desktop 12.04.1 LTS 64 bit Edition

1
  • I have installed oracle express 10.2 on ubuntu 14.04, it works well, but seems oracle express 11.2 didn't release any package for ubuntu ...
    – Eric
    Feb 15, 2016 at 6:58

3 Answers 3

16

Uber ultimate guide to installing of Oracle 11g XE on modern Debian like distro you can find at (VERY HUGE with high amount of workarounds, that is why I can't paste article here):

Another valuable sources (hey! these are not links from top 20 web search! I spend 3 evening on reading these blogs, they are really good, but mostly duplicate above forums.oracle.com link):

One thing that kill a lot of my time is ORA-00845: MEMORY_TARGET not supported on this system error which I fixed by d.hatena.ne.jp blog tips:

$ sudo vi /u01/app/oracle/product/11.2.0/xe/config/scripts/init.ora
$ sudo vi /u01/app/oracle/product/11.2.0/xe/config/scripts/initXETemp.ora 

#memory_target=418381824
pga_aggregate_target=200540160
sga_target=601620480

Another error that I fix and that doesn't mentioned by above links is:

  System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
  Log messages written to /u01/app/oracle/diag/tnslsnr/desktop/listener/alert/log.xml
  Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
  TNS-12555: TNS:permission denied
   TNS-12560: TNS:protocol adapter error
    TNS-00525: Insufficient privilege for operation
     Linux Error: 1: Operation not permitted

  Listener failed to start. See the error message(s) above...

when start listener by:

  /bin/su -s /bin/bash oracle -c '/u01/app/oracle/product/11.2.0/xe/bin/lsnrctl  start'

I fix it by commenting line:

#      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

in /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora.

Next I read Getting Started to unlock HR test user which automatically created during installation of Oracle 11g XE...

Rest of the docs can be found at Database Express Edition Documentation

4
  • This answer is good enough for a knowledge-base entry. The one thing that remains is: Please fix the grammar and lose the leet-speak!
    – aquaherd
    Feb 27, 2013 at 21:04
  • 1
    Sorry for language, I am not a native English speaker...
    – gavenkoa
    Feb 27, 2013 at 21:34
  • I make some changes, hope you like text more...
    – gavenkoa
    Feb 27, 2013 at 21:41
  • 1
    I found the post on forums.oracle.com to have fantastic info. But it's not particularly well formatted, and it could be better organized. I wrote an article based on it, but I made some additions (and subtractions) and improved formatting. Installing Oracle on Ubuntu
    – mdahlman
    Jul 17, 2013 at 20:10
5

I used this guide to install it on Ubuntu Server 12.04 and it worked perfectly.

http://meandmyubuntulinux.blogspot.ca/2012/05/installing-oracle-11g-r2-express.html

1
  • 3
    Welcome to Ask Ubuntu! Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference.
    – Peachy
    Oct 28, 2012 at 6:29
1

I see here that you can download a Linux x64 edition : Oracle Download.

Once you get this .zip, open a terminal and type :

unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

You should see a RPM package. Since Ubuntu is based on Debian, you will need Alien. If you don't have it, type the following instructions in a terminal (by pressing Ctrl+Alt+T) :

sudo apt-get update
sudo apt-get install alien

Once it's installed, type this :

alien -i oracle-xe-11.2.0-1.0.x86_64.rpm

Done !

4
  • 2
    Doesn't work for me. Alien does finish the installation, but then there's no service, no (Oracle) user and nothing running!
    – pugmarx
    Jan 18, 2013 at 20:29
  • 1
    Didn't work me either. My opinion, and it's as good as any opinion for now, is that it's since the oracle installation is very complex and alien is aimed at simple software. Nov 27, 2013 at 22:17
  • 1
    Your instruction is not enough to install Oracle on Ubuntu. Clearly you didn't test it.
    – josircg
    Apr 1, 2014 at 20:12
  • poissbly you forgot this part.. You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
    – ShoeLace
    Mar 4, 2016 at 10:05

You must log in to answer this question.