ORA-27101: Shared memory realm does not exist

10 pts.
Tags:
Memory
ORA-27101
Oracle error messages
I'm getting the ora-27101:shared memory realm does not exist error message. What should I do?

Answer Wiki

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

More information is needed here.

What is your database version?
Is this error being thrown along with ora-01034?
When does this error occur?
During installation, when trying to startup the database?
After installation, when invoking SQL*Plus?
When clients attempt a remote connection to the database?

operating system would also be useful.

Things to check:
- If the error started after modifying some database parameters, restore original parameters, and try again.
- Check environment variables to see if ORACLE_HOME and ORACLE_SID are defined and are correct.
- Check that the oracle_home is defined correctly in listener.ora (without an extra “/” at the end of the path)

——————————————————-

There are several possible solutions that are discussed here.
Good Luck!
-Flame
********************************************

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
  • Subhendu Sen
    However there is no details like OS/ environment, but generally, be sure that, oracle_home & oracle_sid both are correct/ it should not have trailing slash and make sure required services/ instance up.
    29,210 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