Shared Memory Realm Does Not Exist

[Ravi_59]

Hi

The instance is starting, but we get error
"Oracle Not Available,
ORA-27101:Shared memory realm does not exist"

so we are starting up the server using "database configuration assistant".

The oracle server is running on Win 2K OS.

Pls help if somebody has solution for this problem.

[Steven E. Protter]

Kind of wondering what this post is doing here.

The error indicates one of a few conditions in oracle.

Not enough shared memory.
Shared memory resources locked by root and inaccessible
Not enough shared memory segments.

I can fix that in Unix. Don't have a clue how to deal with it in Win2K

perhaps technet.oracle.com

SEP

[Sanjay Kumar Suri]

List down the steps used to start the database from command prompt.

sks

[Stephen Andreassend]

Have you set the ORACLE_SID variable?

[RAC_1]

Wrong forum.

Run oracle on hp-ux.
OR

reboot Win 2K


Anil

[Nicolas Dumeige]

This thread has to be move to Microsoft.
But Stephen is proposition sound goods to me.
Once, we had this problem. This has to do with the connection string. Try to connect with it all, or just with the SID positionned:
sqlplus scott/tiger@ORCL
export ORACLE_SID=ORCL ; sqlplus scott/tiger

Cheers,

Nicolas

[Mª del Mar]

Hi.
It's possible that you have the Oracle Service started but not the shared memory in fact.
Try to start the database from Oracle tools: server manager (if you have a version previous to 9) or sqlplus (if not)... with and startup command.

Cheers
Mar