I've had this before a couple of times -- especially when I've upgraded
or done something to invalidate the Windows service that should be
running.

The first thing you should do is check your database services -- the
start mode, etc. I usually just delete my service and create a new one.
Sometimes you can stop and start the listener and this will fix it, and
sometimes you have to recreate the Windows service.

Hope that helps,
Barb




Mrs. Barbara E. Parker
Senior DBA
Helpdesk Manager
Assistant IAM
Comm: 850-452-0350
DSN: 922-0350
barbara.e.[Email address protected]




-----Original Message-----
From: Chris Ermlich
[mailto:oracledba-ezmlmshield-x48402880.[Email address protected]
Sent: Friday, January 04, 2008 8:31
To: LazyDBA Discussion
Subject: RE: ORA-27101 SHARED MEMORY REALM DOES NOT EXIST

Seems to me the instance is either not up and running or the client
can't find it.
Is the SID configured in the tnsnames.ora ?

Can you tnsping SID ?

-----Original Message-----
From: Roopa Konathala [mailto:oracledba-ezmlmshield-x19421668.[Email
address protected]
Sent: Friday, January 04, 2008 7:37 AM
To: LazyDBA Discussion
Subject: ORA-27101 SHARED MEMORY REALM DOES NOT EXIST


Hi,

Help me out in solveing for the below error

ORA-27101 SHARED MEMORY REALM DOES NOT EXIST

Thanks & Regards
Roopa Konathala



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page