General
cancel
Showing results for 
Search instead for 
Did you mean: 

Shared Memory Realm Does Not Exist

Ravi_59
Occasional Visitor

Shared Memory Realm Does Not Exist

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.
6 REPLIES
Steven E. Protter
Exalted Contributor

Re: Shared Memory Realm Does Not Exist

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Sanjay Kumar Suri
Honored Contributor

Re: Shared Memory Realm Does Not Exist

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

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Stephen Andreassend
Regular Advisor

Re: Shared Memory Realm Does Not Exist

Have you set the ORACLE_SID variable?
RAC_1
Honored Contributor

Re: Shared Memory Realm Does Not Exist

Wrong forum.

Run oracle on hp-ux.
OR

reboot Win 2K


Anil
There is no substitute to HARDWORK
Nicolas Dumeige
Esteemed Contributor

Re: Shared Memory Realm Does Not Exist

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
All different, all Unix
Mª del Mar
Occasional Visitor

Re: Shared Memory Realm Does Not Exist

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
Mar