Has this database worked before ? If so, did you make any changes ?
There are more than one possible cause to this, such as incorrect SGA settings, ORACLE_SID or ORACLE_HOME not properly set, it could also happen when migrating the database...
Have a look at the following pages, hopefully you will find an answer there.
<a href="http://arjudba.blogspot.com/2008/04/ora-01034-ora-27101-shared-memory-realm.html">Oracle in World </a>
<a href="http://www.dba-oracle.com/sf_ora_01034_oracle_not_available.htm">ORA-01034: ORACLE not available tips</a>
<a href="http://forums.oracle.com/forums/thread.jspa?messageID=1845760">Thread: ORA-01034 & ORA-27101 at Oracle forums</a>
Last Wiki Answer Submitted: November 29, 2008 2:39 am by carlosdl63,535 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
I did install the Patch set and patch to upgrade the Oracle 10.2.0.0 to 10.2.0.4. After installation of the patchset.. it was working fine. After installation of the patch and following the post installation instructions in the Readme.
The DB is not starting up. It says the same error as above.
I did install the Patch set and patch to upgrade the Oracle 10.2.0.0 to 10.2.0.4. After installation of the patchset.. it was working fine. After installation of the patch and following the post installation instructions in the Readme.
The DB is not starting up. It says the same error as above.
ORACLE environment variable are set properly.
Please advice.