Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed the Oracle database following the steps mentioned in this blog.

  1. Downloaded 11g express edition

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

  3. Unzipped and then converted the rpm to the Ubuntu package by running:

    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 there.

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

  6. Running the commands:

    ln -s /usr/bin/awk /bin/awk
    mkdir /var/lock/subsys
    touch /var/lock/subsys/listener
  7. .deb generated in step 3:

    sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb
  8. Left the default values as it is:

    sudo /etc/init.d/oracle-xe configure
  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/`
    export ORACLE_BASE=/u01/app/oracle
    export PATH=$ORACLE_HOME/bin:$PATH
  10. Running the commands:

    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. Starting Oracle Database 11g Express Edition instance:

    sudo service oracle-xe start 
  12. sqlplus / as sysdba and got the following:

    SQL*Plus: Release Production on Thu Jan 3 09:41:58 2013
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    Connected to an idle instance.

Now when exectuting 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 here

$ free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066
share|improve this question
please give a solution.i am in a big problem – Praneeth Pj Mar 13 '13 at 13:40

You will need to do this before you configure oracle.

sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=2048m /dev/shm

Further details are in another post on the same blog that you referrred.

share|improve this answer

Follow the link below,its easy and simple.It worked fine for me.

share|improve this answer
Although this may provide a working solution, it is considered best practice to provide (at minimum) a brief description of what's involved, so that if (for whatever reason) the link becomes unavailable, the answer will remain useful. – hmayag Oct 3 '15 at 21:00

i found this blog:

it contains detailed steps to achieve target.

share|improve this answer
Please summarise the steps in your post - the link may die some day – Zanna Jul 11 at 10:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.