OraFAQ Forum: Server Administration » database starting problem

Home » RDBMS Server » Server Administration » database starting problem (

) 1 Vote

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

database starting problem [message #168199]

Wed, 19 April 2006 04:39

v.ram81
Messages: 50
Registered: April 2006
Location: pune

Member

i installed oracle 9i on my pc .
installation was successful.
but when i tried to connect using sql*plus i get an error
ORA-01034:ORACLE NOT AVILABLE
ORA-27101:SHARED MEMORY REALM DOES NOT EXIST.

PLEASE HELP ME
THANKS REGARDS
RAM

Report message to a moderator

Re: database starting problem [message #168211 is a reply to message #168199]

Wed, 19 April 2006 05:30

binoyp
Messages: 1
Registered: April 2006

Junior Member

Hi,

Check your environment variables to make sure that ORACLE_HOME, ORACLE_SID set correctly. Also you may need to look at tnsnames.ora file to see whether the entry is correct. You better of modify the TNS entry for your new instance based on an existing working tns entry.

Hope this will help you to rectify the issue.

Thanks,

Philip

Report message to a moderator

Re: database starting problem [message #168833 is a reply to message #168199]

Sun, 23 April 2006 11:33

tech123
Messages: 6
Registered: April 2006

Junior Member

there are few possible reasons cause this issue.

Env variables.
init.ora parameters.

reffer below link
http://www.easywebtech.com/oracle/ORA-27101_SHARED_MEMORY_REALM.html

Report message to a moderator

Re: database starting problem [message #172407 is a reply to message #168199]

Tue, 16 May 2006 06:45

viplove
Messages: 9
Registered: May 2006

Junior Member

u can try the following:

set oracle_sid=(your sid name)
sqlplus /nolog
connect /as sysdba'
startup

it will open ur database.

viplove

Report message to a moderator

Previous Topic:	To get all the views pointing to a particular table
Next Topic:	Database version after applying Oracle Critical Patch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:40:10 CDT 2024