Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Installation of Oracle Database 11g Express Edition on Ubuntu 12.04.1 LTS

I have been struggling to install Oracle 11g Express Edition on Ubuntu 12.04.1 LTS version.

I have followed these steps:

  1. Downloaded 11g express edition from Oracle's site

  2. Created a new user 'oracle' under the group dba. Following steps are executed using this.

  3. 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
    
  4. Created /sbin/chkconfig file and added the entries as specified here

  5. Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.

  6. Below steps:

    • ln -s /usr/bin/awk /bin/awk
    • mkdir /var/lock/subsys
    • touch /var/lock/subsys/listener
  7. sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)

  8. sudo /etc/init.d/oracle-xe configure (left the default values as it is)

  9. 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
    
  10. 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
    
  11. 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.

like image 898
Manikandan Kannan Avatar asked Jan 03 '13 10:01

Manikandan Kannan


1 Answers

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.

like image 64
Manikandan Kannan Avatar answered Jan 03 '23 13:01

Manikandan Kannan