[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]

Originally Posted by 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.

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]

Originally Posted by Blessy

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

Expand|Select|Wrap|Line Numbers

1. 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]

Originally Posted by r035198x

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

Expand|Select|Wrap|Line Numbers

1. 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,previously 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]

Originally Posted by Blessy

Sorry i have not set ORACLE_HOME,previously 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?