OraFAQ Forum: Server Administration » ORA-27101: shared memory realm does not exist

Home » RDBMS Server » Server Administration » ORA-27101: shared memory realm does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-27101: shared memory realm does not exist [message #242473]

Sat, 02 June 2007 09:07

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

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #242476 is a reply to message #242473]

Sat, 02 June 2007 09:22

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #242477 is a reply to message #242476]

Sat, 02 June 2007 09:39

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

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #242481 is a reply to message #242477]

Sat, 02 June 2007 11:52

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.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #242486 is a reply to message #242481]

Sat, 02 June 2007 12:23

sskdba2005
Messages: 7
Registered: June 2005
Location: Bangalore

Junior Member

Before starting itself getting this message. can you help for further steps to do.

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist [message #242487 is a reply to message #242473]

Sat, 02 June 2007 12:32

BlackSwan
Messages: 26766
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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 11:10:07 CST 2024