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

I think it is memory issue. decrease the size of following parameters in your init.ora file and try to startup database on svrmgrl> prompt.

shared_pool_size
log_buffer
db_block_buffers


try it. if you still get same error try again and reduce the size of above mentioned parameters.


Thanks

Decreasing these values will not really help much, if at all.

julian,

I encountered with same problem in past i have 10 database working on my production server out of 10 4 database with JVM and i have 1G.B memory still sometime i am getting the same error cuse memory issue i alway rduce three parameters which i mentioned before it's not always tru that decreasing valu naver help at all.try it.

Minesh

I've encountered this problem in the past. I have never done it via SQL*Plus, only from the command line. What I did to solve the seemingly annoying problem is:

1) stop and then start the Oracle service
2) try to startup the database from svrmgrl> prompt.

Occasionally, you will be given an error message "Oracle service not available." Don't panic, just stop & re-start the service and this will allow you to start up the database.

I also remember seeing another Oracle error message "Oracle instance is up-you must first shutdown and ..."-well, in this case, shutdown and startup will do.

Hope this help.

P.S: Mine is Oracle 8.16 running on NT 4.0

I had the same error on Win NT Oracle 8.1.7. The problem:

One of my config files was linked to a non-existent file. Fixed the link and now everything is ok.

If (s)he is swapping, of course, they have to be decreased.