Home / ubuntu / Questions / 198163
In Process
user91632
Asked: 2012-10-10 03:59:47 +0800 CST

How to install Oracle Express 11gR2?

  • 772

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

oracle

3 Answers

  1. 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

    • 16

  2. 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

    • 5

  3. 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 !

    • 1