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
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
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))
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
I used this guide to install it on Ubuntu Server 12.04 and it worked perfectly.
I see here that you can download a Linux x64 edition : Oracle Download.
Once you get this .zip, open a terminal and type :
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