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


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

Pls give me Solution
Ramesh
Re: oracle error [message #206925 is a reply to message #206922] Sat, 02 December 2006 05:33 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
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.

Oracle
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

hi

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
Taj.
Previous Topic: ORA-28546
Next Topic: Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error)
Goto Forum:
  


Current Time: Fri Dec 06 16:19:28 CST 2024