ORA-01034: ORACLE not available ORA-27101:?

Hey guys?

ERROR: Array ( [code] => 1034 [message] => ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory ) 1

I have the following error, when i try to retrieve data from oracle database. It was working fine all these time, but all the sudden i got this message. Andy Idea, how to fix this. I am posting this question I am using linux.

And I am not sure how to check my ORACLE_SID value. Does any one knows how to check the oracle sid value? Command for that..

Any hints or Ideas;


Suresh

log into sever manager or sqlplus ...connect as internal and then issue the startup command. you can optionally specify the startup command with the PFile argument

ORACLE_SID is suppose to be set as an environment variable. so just give type set at your shell prompt and it should tell you whether its set or not.

hth,

Jiggee

What is difference betweeon ORACLE_SID AND ORACLE_HOME?

I only see the ORACL_HOME UNDER env values.


How do i setup the ORACLE_SID VALUES?

I dont remeber exactly how to specify env variables in linux but its done with the help of the export(linux shell )command. just google on it and you will find tons of info. give this a shot...

export ORACLE_SID=<your_sid>; //you might require quotes...also you might wanna declare that in one of your profile files so you dont have to set it evertime.


as far as the differenece is concerned oracle home points to where oracle is installed while oracle sid points to a specific instance name of a database.

ORacle is not started.

Get your DBA to start Oracle.