ORA-27101: shared memory realm does not exist

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

from sqlplus windows or dos?

Both...

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


Sam

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

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

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.

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

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

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