Oracle 10g Instance not starting Up

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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Raj666
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following