OraFAQ Forum: Server Administration » ORA-27101 SHARED MEMORY REALM DOES'NT EXIST

Home » RDBMS Server » Server Administration » ORA-27101 SHARED MEMORY REALM DOES'NT EXIST

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

ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #58547]

Tue, 16 September 2003 09:25

Jay
Messages: 127
Registered: October 1999

Senior Member

All of a sudden my oracle application has stopped functioning.When I try to log in I get the following messages:

ORA-27101 SHARED MEMORY REALM DOES NOT EXIST
ORA-01034 ORACLE NOT AVAILABLE

From the command line when I try to connect as sysdba and startup the following message appears:
"oracle instance terminated.Disconnection forced"

This looks really strange as the system was up and running until yesterday.Guys Please help.

Thanks
Jay

Report message to a moderator

Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #58550 is a reply to message #58547]

Tue, 16 September 2003 09:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

your database is not started.
do a clean reboot.

[i]
oracle instance terminated.Disconnection forced[/i]
may be becuase any of the background process crash.
look into alert.log for more info

Report message to a moderator

Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #58554 is a reply to message #58550]

Tue, 16 September 2003 16:53

Kartik Nair
Messages: 15
Registered: August 2003

Junior Member

Are you running Orale on UNIX? If so issue the following command

ps -ef | grep ora

If none of the background process is shown then probably the database is down. On the other hand if you see the all the bg process, then the SID name in the listener.ora does not match.

Correct the entry in the listener.ora file to match the database name (case matters !!), stop the listener,
restart the listener and try to connect to the database.

Cheers

Kartik.

Report message to a moderator

Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #58639 is a reply to message #58547]

Tue, 23 September 2003 05:32

dipin
Messages: 15
Registered: March 2003

Junior Member

what if the system is windows?

Report message to a moderator

Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #58646 is a reply to message #58639]

Tue, 23 September 2003 13:08

Kartik Nair
Messages: 15
Registered: August 2003

Junior Member

Is the database up & running???

On uinx:

$ ps -ef | grep ora

You should get a list of all the background processes and the listener.

On Windows look under Task Manager, Processes.

If the database is running then you have a problem with the listener configuration. Make sure the SID name used while creating the database and the one in the listener.ora matches (even the case should match).

Good luck!

Kartik.

Report message to a moderator

Previous Topic:	pfile,shutdown etc
Next Topic:	checkpoint

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:34:22 CDT 2024