topic Re: Shared Memory Realm Does Not Exist in Operating System - HP-UX

Shared Memory Realm Does Not Exist

Ravi_59 — Wed, 21 Apr 2004 00:23:05 GMT

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.

Re: Shared Memory Realm Does Not Exist

Steven E. Protter — Wed, 21 Apr 2004 00:31:35 GMT

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

Re: Shared Memory Realm Does Not Exist

Sanjay Kumar Suri — Wed, 21 Apr 2004 00:53:07 GMT

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

sks

Re: Shared Memory Realm Does Not Exist

Stephen Andreassend — Wed, 21 Apr 2004 07:42:01 GMT

Have you set the ORACLE_SID variable?

Re: Shared Memory Realm Does Not Exist

RAC_1 — Wed, 21 Apr 2004 07:49:07 GMT

Wrong forum.

Run oracle on hp-ux.
OR

reboot Win 2K

Anil

Re: Shared Memory Realm Does Not Exist

Nicolas Dumeige — Wed, 21 Apr 2004 07:52:27 GMT

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

Re: Shared Memory Realm Does Not Exist

Mª del Mar — Thu, 22 Apr 2004 01:25:42 GMT

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