I've Redhat Linux AS 4 and installed Oracle 10g on that.I'm getting an error "ORA-01034: Oracle not available"
Tuesday, March 22nd, 2011 at
22:02
I’ve Redhat Linux AS 4 and installed Oracle 10g on that.I’m getting an error "ORA-01034: Oracle not available"
Till yesterday, it was working fine, but today when i started my database by " sqlplus ‘/as sysdba’ ; i got this error.
can somebody help me in this regard.
Tagged with: Linux • oracle • oracle 10g • regard • sqlplus
Filed under: Redhat
Like this post? Subscribe to my RSS feed and get loads more!
Your ORACLE_SID may not be set correctly, or your may machine may have rebooted and your database was not automatically started. At the command line, as an oracle user do:
$ echo $ORACLE_SID
$ps -ef|grep pmon
$ who -b
a – will tell you if your sid is set correctly (or at all)
b – will tell you if your database appears to be up and running
c – will tell you if your machine rebooted recently
If machine reboots are taking your database down, you may wish to create/modify the scripting that will allow the database to start automatically (or you may just need to change you oratab file for this database).
HTH