I have been struggling to install Oracle 11g Express Edition on Ubuntu 12.04.1 LTS version.
I have followed these steps:
Downloaded 11g express edition from Oracle's site
Created a new user 'oracle' under the group dba. Following steps are executed using this.
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package
sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
Created /sbin/chkconfig
file and added the entries as specified here
Created /etc/sysctl.d/60-oracle.conf
and added the entries as specified in same link as above.
Below steps:
ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener
sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb
(.deb generated in step 3)
sudo /etc/init.d/oracle-xe configure
(left the default values as it is)
Set the following env variables in ~/.bashrc
file
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
Below steps:
chown -R oracle:dba /var/tmp/.oracle
chmod -R 755 /var/tmp/.oracle
chown -R oracle:dba /tmp/.oracle
chmod -R 755 /tmp/.oracle
sudo service oracle-xe start
(I didn't see any issues in this step)
12 . sqlplus / as sysdba and got the following
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 3 09:41:58 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
Now when exectute any SQL statements on SQLplus, i end up with the following error
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
I have increased the swap memory as specified in here
free -m
total used free shared buffers cached
Mem: 1652 1596 56 0 53 1356
-/+ buffers/cache: 186 1466
Swap: 2943 0 2943
Can you guide me here? I am clueless.
Finally, after a day long struggle
These did the trick.
sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=2048m /dev/shm
Make sure that these are executed before the database is configured.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With