Home » RDBMS Server » Networking and Gateways » oracle error
oracle error [message #206922] Sat, 02 December 2006 05:24 Go to next message
Messages: 8
Registered: September 2005
Location: coimbatore
Junior Member
we are getting following error
Please giveme the solution

ORA-01034:ORACLE not available
ORA-27101:Shared memory realm does not exist

Pls give me Solution
Re: oracle error [message #206925 is a reply to message #206922] Sat, 02 December 2006 05:33 Go to previous messageGo to next message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-01034 ORACLE not available

Cause: Oracle was not started. Possible causes include the following:

The SGA requires more space than was allocated for it.

The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.

ORA-27101 shared memory realm does not exist

Cause: Unable to locate shared memory realm.

Action: Verify that the realm is accessible.
Re: oracle error [message #206983 is a reply to message #206922] Sun, 03 December 2006 00:11 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


when you get above error.

May be possible ur services is running and ur database is shutdown..

so first try to connect oracle database.
and give "startup" command.

if after connecting you get "connected to idle instance"

hope this helps
Previous Topic: ORA-28546
Next Topic: oracle spawns new listener (Oracle 10GR2)
Goto Forum:

Current Time: Sat Aug 19 21:21:38 CDT 2017

Total time taken to generate the page: 0.21864 seconds