Home » RDBMS Server » Server Administration » ORA-27101 SHARED MEMORY REALM DOES'NT EXIST
ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #72691] Tue, 16 September 2003 09:31 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
All of a sudden my oracle application has stopped functioning.When I try to log in I get the following messages:
ORA-27101 SHARED MEMORY REALM DOES NOT EXIST
ORA-01034 ORACLE NOT AVAILABLE

From the command line when I try to connect as sysdba and startup the following message appears:
"oracle instance terminated.Disconnection forced"

This looks really strange as the system was up and running until yesterday.Guys Please help.

Thanks
Jay
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #72693 is a reply to message #72691] Fri, 19 September 2003 04:08 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi,

do you have any messages in your alert.log file regarding the problem ?
Sometimes it is only because you have not set the environment correctly (ORACLE_HOME, ORACLE_SID).
regds
Uwe
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73003 is a reply to message #72693] Tue, 13 January 2004 06:17 Go to previous messageGo to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
hi
facing from same problem.please help me

regards
raj
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73128 is a reply to message #73003] Tue, 10 February 2004 20:01 Go to previous messageGo to next message
sudhanshu
Messages: 5
Registered: April 2002
Junior Member
THIS PROBLEM ARISES DUE TO WRONG ENRTRY IN TNSNAMES.ORA FILE OR SOME TIME SPACE PROBLEM.

RGDS,
SUDHANSHU.
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73320 is a reply to message #72691] Tue, 23 March 2004 11:59 Go to previous messageGo to next message
Mariusz
Messages: 1
Registered: March 2004
Junior Member
Do you start the "oracle DBA Studio" on SYS as SYSDBA and start database! Login to sqlplus and problem is dosent not exist!

regards

Mariusz
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73359 is a reply to message #73128] Thu, 01 April 2004 10:29 Go to previous messageGo to next message
Reynaldo Souza
Messages: 1
Registered: April 2004
Junior Member
And could you please give me a hint how can I solve this problem?

The file tnsname.ora has no wrong entry.

Thanks...

Reynaldo.
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73361 is a reply to message #72693] Thu, 01 April 2004 23:49 Go to previous messageGo to next message
Aziz Benkhattab
Messages: 1
Registered: April 2004
Junior Member
hi,
It seams that is depends on value of process param in init.ora file. (put it less than 150)

follow up this link, there is , i think, a nice response.

http://www.jlcomp.demon.co.uk/faq/ORA-27101.html
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73385 is a reply to message #73359] Wed, 07 April 2004 17:35 Go to previous messageGo to next message
Huong Giang
Messages: 1
Registered: April 2004
Junior Member
How to tnsname.ora ? Thanks
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73392 is a reply to message #72691] Tue, 13 April 2004 05:31 Go to previous messageGo to next message
Kevin
Messages: 45
Registered: February 2000
Member
what does "how to tnsnames.ora?" mean? anyway, I ran into this problem and increased the shared pool size, which fixed the problem. I guess there are other issues that can cause 27101, but that is what worked for me.
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73395 is a reply to message #72691] Wed, 14 April 2004 04:35 Go to previous messageGo to next message
Jarmo
Messages: 1
Registered: April 2004
Junior Member
The solution for me was to change all SID references in .ora -files to same (lower) case (instead of some references in ALLCAPS and some lowercase).
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73422 is a reply to message #73395] Fri, 23 April 2004 06:28 Go to previous messageGo to next message
Eric Galluzzo
Messages: 1
Registered: April 2004
Junior Member
Thank you! This did the trick for me too. Much obliged.

The odd thing is that Oracle just set this all up for me via the installation program with mostly default options, so you'd think it would work. Last time I installed Oracle (same version, same OS), it all worked first try. Odd.
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73467 is a reply to message #72691] Wed, 05 May 2004 07:28 Go to previous messageGo to next message
sajid
Messages: 18
Registered: April 2000
Junior Member
All of a sudden my oracle application has stopped functioning.When I try to log in I get the following messages:
ORA-27101 SHARED MEMORY REALM DOES NOT EXIST
ORA-01034 ORACLE NOT AVAILABLE
From the command line when I try to connect as sysdba and startup the following message appears:
"oracle instance terminated.Disconnection forced"

This looks really strange as the system was up and running until yesterday.Guys Please help.

Thanks

Sajid
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #73535 is a reply to message #73361] Tue, 18 May 2004 06:24 Go to previous messageGo to next message
Daren Telohs
Messages: 1
Registered: May 2004
Junior Member
That was the solution I was looking for.

Cheers!
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #74335 is a reply to message #73467] Tue, 16 November 2004 23:31 Go to previous messageGo to next message
prashant
Messages: 122
Registered: September 2000
Senior Member
The reason is that the instance was not started, please start the instance manually.

thanks
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #426743 is a reply to message #74335] Mon, 19 October 2009 04:54 Go to previous messageGo to next message
mausami13
Messages: 1
Registered: October 2009
Junior Member
When you get this error message ->
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

check that oracle service has been started -
For Windows machine go to run -> type services.msc -> start the respective oracle sevice .
Evan after this the same error comes then manually start the service in command prompt.

For Windows machine go to run -> type cmd

Type the following commands
C:\set oracle_sid = sidname
C:\sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Oct 19 14:58:50 2009

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: sys/sys as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 237856796 bytes
Fixed Size 75804 bytes
Variable Size 80416768 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
Database mounted.
Database opened.
SQL>


Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #426775 is a reply to message #426743] Mon, 19 October 2009 10:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Mausami13,

Thanks for your details. Before replying any thread please check last updated date.

You have replied your old thread. "Wed, 17 November 2004 11:01"

Babu
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #516534 is a reply to message #426743] Tue, 19 July 2011 03:07 Go to previous messageGo to next message
himacsoft
Messages: 14
Registered: May 2011
Junior Member
Dear Sir,

Thank you very much for your information.

My problem solved based on your kind information.

Best regards
Varadharaj A
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #516672 is a reply to message #516534] Wed, 20 July 2011 00:18 Go to previous messageGo to next message
himacsoft
Messages: 14
Registered: May 2011
Junior Member
Dear sir,

I'm using Oracle 8i Enterprise Edition. OS is Windows 2003 server.
Everyday when i try to connect my database using Internal user, i m getting messege "Shared Memory Realm Does Not Exist" Please help me solving my problem.
Have a nice day
regards
Varadharaj
Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #516676 is a reply to message #516672] Wed, 20 July 2011 00:53 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
using Oracle 8i Enterprise Edition. OS is Windows 2003 server

Not supported and not tested combination.

What happen to your "My problem solved based on your kind information."?

Regards
Michel
Previous Topic: Oracle Database Server(2 Merged)
Next Topic: ORA-15024: discovered duplicately numbered ASM disk
Goto Forum:
  


Current Time: Thu Mar 28 15:43:00 CDT 2024