OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » oracle error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle error [message #206922]

Sat, 02 December 2006 05:24

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

Report message to a moderator

Re: oracle error [message #206925 is a reply to message #206922]

Sat, 02 December 2006 05:33

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: oracle error [message #206983 is a reply to message #206922]

Sun, 03 December 2006 00:11

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.

Report message to a moderator

Previous Topic:	ORA-28546
Next Topic:	Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 05:34:30 CDT 2024