Ubuntu – How to install Oracle Express 11gR2

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

• https://forums.oracle.com/forums/thread.jspa?threadID=2301639

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

• http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bits
• http://meandmyubuntulinux.blogspot.com/2012/05/installing-oracle-11g-r2-express.html
• http://meandmyubuntulinux.blogspot.com/2012/06/trouble-shooting-oracle-11g.html
• http://mikesmithers.wordpress.com/2011/11/26/installing-oracle-11gxe-on-mint-and-ubuntu/
• http://www.len.ro/work/oracle-11g-release-2-xe-on-ubuntu-12-04/
• http://mikesmithers.wordpress.com/2012/09/25/ora-00845-memory_target-error-installing-oracle-xe-on-mint-and-ubuntu/
• http://blog.oracle48.nl/oracle-11g-amm-memory_target-memory_max_target-and-dev_shm/
• http://d.hatena.ne.jp/t2y-1979/20111017/1318858143
• http://sysadminnotebook.blogspot.com/2012/10/installing-oracle-11g-r2-express.html

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