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: 21123
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: Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error)
Goto Forum:

Current Time: Wed Jun 28 16:12:47 CDT 2017

Total time taken to generate the page: 0.13100 seconds