Oracle does not exist and shared memory realm does not exist error

[Blessy]

Before restarting my server i was able to access my local database.When I restarted the server it is giving the following error.

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

when i started the server by giving the command

>startup <database>

it is not working properly.My database is not getting started.It say control file is not present.But that is present there.

What to do?
Could you please help me on this.

[r035198x]

Check whether your ORACLE_SID is set. If that doesn't work, post the exact error message you are getting when trying to start the database.

[Blessy]

Check whether your ORACLE_SID is set. If that doesn't work, post the exact error message you are getting when trying to start the database.

ya i gave that command set oracle_sid=<my database name>

and after that only i gave that command 'startup <database_name> .

After that i got an error saying 'could not find or load Controls files'.
But all the control files are present.

[r035198x]

ya i gave that command set oracle_sid=<my database name>

and after that only i gave that command 'startup <database_name> .

After that i got an error saying 'could not find or load Controls files'.
But all the control files are present.

Well if the control file are missing/moved the error you would get is

ORA-00205: error in identifying control file, check alert log for more info

Check all the other required environment variables just to be sure (ORACLE_HOME e.t.c)

[Blessy]

Well if the control file are missing/moved the error you would get is

ORA-00205: error in identifying control file, check alert log for more info

Check all the other required environment variables just to be sure (ORACLE_HOME e.t.c)

Sorry i have not set ORACLE_HOME,pre viously also it was not set.
if i need to set ORACLE_HOME:-D:\oracle\ora92 \bin

is it sufficient for me to give this because i have installed oracle in d:\

As you have given set ORACLE_HOME and etc..

what else i have to set ...as you have given etc....

[r035198x]

Sorry i have not set ORACLE_HOME,pre viously also it was not set.
if i need to set ORACLE_HOME:-D:\oracle\ora92 \bin

is it sufficient for me to give this because i have installed oracle in d:\

As you have given set ORACLE_HOME and etc..

what else i have to set ...as you have given etc....

Do not set those variables on the command line if you are using windows. Set them as environment variables.
Which OS are you using and which installation method did you use?