15 pts.
 Oracle 10g Instance not starting Up
Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

Software/Hardware used:
ASKED: November 29, 2008  2:03 AM
UPDATED: December 1, 2008  8:03 PM

Answer Wiki:
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  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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.

 15 pts.