Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am intalled the Oracle database have followed this steps [link|http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html?showComment=1357195285714#c4393074524447658792] .

1.Downloaded 11g express edition

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 Starting Oracle Database 11g Express Edition instance. //this line is a space

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 |http://meandmyubuntulinux.blogspot.in/2011/09/installing-1-gb-swap-without.html]

free -m

total used free shared buffers cached Mem: 3901 3428 473 0 182 1988 -/+ buffers/cache: 1258 2643 Swap: 5066 0 5066

what the solution for this error ? ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0

please help me.

share|improve this question
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.