Question by rajreddy: I’ve Redhat Linux AS 4 and installed Oracle 10g on that.I’m getting an error “ORA-01034: Oracle not available”
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.
Best answer:
Answer by xamayca.com
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
What do you think? Answer below!
