Ubuntu – How to install Oracle Express 11gR2


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

Best Answer

  • 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 

    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
      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:


    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

  • Related Question