Home » RDBMS Server » Server Administration » ORA-27101: shared memory realm does not exist
ORA-27101: shared memory realm does not exist [message #242473] Sat, 02 June 2007 09:07 Go to next message
sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore
Junior Member

Hi friends,

Need help to resolve this bug.

While login with sys as sysdba. Unable login even with the normal user like scott,..

ORA-27101: shared memory realm does not exist

Saravanan
Re: ORA-27101: shared memory realm does not exist [message #242476 is a reply to message #242473] Sat, 02 June 2007 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Oracle is NOT running so start it.
Please read & FOLLOW the posting guidelines as stated in the #1 STICKY post at the top of the forum.
icon9.gif  Re: ORA-27101: shared memory realm does not exist [message #242477 is a reply to message #242476] Sat, 02 June 2007 09:39 Go to previous messageGo to next message
sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore
Junior Member

Hi,

Thanks for the prompt response.

Hope after sqlplus run successfully with the respective user oracle can start its instance.

Oracle encounter the above mentioned error while login with sys as sysdba.

Thanks and Regards
Saravanan
Re: ORA-27101: shared memory realm does not exist [message #242481 is a reply to message #242477] Sat, 02 June 2007 11:52 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Hi , Your db is not started that's why you are getting this error. This is not related to sysdba login.
Re: ORA-27101: shared memory realm does not exist [message #242486 is a reply to message #242481] Sat, 02 June 2007 12:23 Go to previous messageGo to next message
sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore
Junior Member

Before starting itself getting this message. can you help for further steps to do.
Re: ORA-27101: shared memory realm does not exist [message #242487 is a reply to message #242473] Sat, 02 June 2007 12:32 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>can you help for further steps to do.
Use CUT & PASTE to show us rather than you describing what you think is happening.
Please read & FOLLOW the posting guidelines as stated in the #1 STICKY post at the top of the forum.
http://www.orafaq.com/forum/t/59966/74940/
What OS name & version?
Which version of Oracle to 4 decimal places?
Other than the error message we know nothing what you are doing.

My car does not go.
Tell me how to make my car go.

[Updated on: Sat, 02 June 2007 12:36] by Moderator

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #242529 is a reply to message #242473] Sun, 03 June 2007 11:50 Go to previous message
kandhireddy
Messages: 4
Registered: May 2007
Junior Member
Database is not up, have u done any changes in the os level. Check the alert log file and update the error message in alert_log file.

Elobarate more on the

Operating System
Version
Database Version

Thanks
Karunakar
Previous Topic: doubt on tablespaces
Next Topic: Can I give Schema's their own Individual Tablespace?
Goto Forum:
  


Current Time: Fri Dec 09 06:01:59 CST 2016

Total time taken to generate the page: 0.09312 seconds