ORA-27101: shared memory realm does not exist

[Minesh]

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

[julian]

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

[Minesh]

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

[John T. Le]

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

[rwpayne]

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.

[julian]

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