ORA-27101: shared memory realm does not exist

[irehman]

Okay I have 8.1.7 installed on Win 2K Pro it was working just fine, I have not changed anything, All the services are running fine, but when I tried to connect I got Folloing error.

ORA-27101: shared memory realm does not exist


Thanks in Advance

[pando]

from sqlplus windows or dos?

[irehman]

Both...

[sambavan]

check and make sure that your environment had been set properly. i.e ORACLE_SID and ORACLE_HOME


Sam

[irehman]

Everything seams to be fine, but still the same error.

[sambavan]

Choose the database configuration assistant and look into updating your database to 8.1.7. This could occour when you have a wrong oracle_home, or oracle_sid set. Or on the case where your database was created on a different version and the you are trying to use the higher listner version or so...

Need more information:

1. Is this a fresh install or an upgrade?
2. Others

Sam

[irehman]

Fresh install, I did it yesturday. It was working fine but today I'm getting all these errors.

I 'm trying to connect to pre configured Database that comes with the CD, so no upgrade or manual configuration was done.

[sambavan]

Try the above one by one and see whether you were able to solve it:

1.Chnage SQLNET.AUTHENTICATION_SERVICES= (NTS) in
%ORACLE_HOME%/network/admin/sqlnet.ora file and see whether you were able to succeed.

2. Check your registry and see

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\...\ORA_ORCL_AUTOSTART = FALSE

and Try changing it to TRUE and see whether you were able to succeed.



Curtesy to Metalink

Sam

[mike73]

Sam,

I think I run to this problem too after I aplly the patches for 8.1.7 . this is upgrade from 8.1.6 to 8.1.7

can you tell me what happened here ???

thanks

[irehman]

Well since it was a demo database I just deleted it and recreated it, now it works fine. Thanks