| ORA-27101 SHARED MEMORY REALM DOES'NT EXIST [message #72691] |
Tue, 16 September 2003 09:31  |
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  |
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 #73422 is a reply to message #73395] |
Fri, 23 April 2004 06:28 |
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 |
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 #426743 is a reply to message #74335] |
Mon, 19 October 2009 04:54 |
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>
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
