Ubuntu – How to install Oracle Express 11gR2

oracle

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

  • Related Question