Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Server Utilities » 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
Report message to a moderator
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: 251
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
Report message to a moderator
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
Report message to a moderator
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.
Report message to a moderator
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
Report message to a moderator
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.
Report message to a moderator
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
Report message to a moderator
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
Report message to a moderator
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.
Report message to a moderator
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).
Report message to a moderator
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.
Report message to a moderator
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
Report message to a moderator
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!
Report message to a moderator
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
Report message to a moderator
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>
Report message to a moderator
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 message
gentlebabu
Messages: 1398
Registered: December 2005
Location: India, Hyderabad
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
Report message to a moderator
Previous Topic:Import errors
Next Topic:Import stalled with 'SQL*Net message from client' wait event
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 13:01:14 CST 2009

Total time taken to generate the page: 0.21259 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.