shutdown pending

[attilio_1]

Hello

For a problem on a application I have done a shutdown of the instance of db.
I have done only shutdown without immediate.
Now If I try to do a shutdown immediate, there is a message:ORA-01034: ORACLE not available, but the istance oracle is not down.
How can I restart the Server ?

Thanks
Attilio

[Jean-Luc Oudart · Accepted solution]

How do you know the instance is not down ?

any remaining background processes (ps -ef | grep ) ?

Have tried shutdown abort
then re-start database

Regards
Jean-Luc

[Devender Khatana]

Hi,

I am not a DBA but from my experience I think it will require some time to shut if the immediate option is not specified. How much time it has allready taken?

If it is less than 15-20 minutes then you can wait for some time otherwise can wait for other responses.

HTH,
Devender

[Steven E. Protter]

Shalom Attilio,

Not a DBA but highly experience with Oracle "nariskait" which roughly translates as silly behavior.

Try logging on to the database as the oracle OS user. Go for dba priveledges if possible.

shutdown immediate

If that does not work

shutdown abort

That WILL work

startup

shutdown

Now you may restart.

If you can't get the database to behave nicely go ahead and restart the server. My steps increase the liklihood of a clean shutdown/start and lower the liklihood of data corruption.

Normally the database will recover after boot anyway.

SEP

[attilio_1]

Hello Jean-Luc,

With the option abort the instance is gone down

thanks a lot
Attilio

[Borislav Perkov]

Hi Attilio,

The application keep the database not to do shutdown.
Find the processes which from the application and terminate them.

Regards,
Borislav

[Yogeeraj_1]

hi attilio,

ALso note that Shutdown immediate is a clean shutdown. It simply kicks off active transactions before doing a clean shutdown whereas shutdown normal WAITS for them to
complete.

A shutdown immediate leaves the database in the same closed state as shutdown normal does.

Shutdown abort just kills all transactions and we do recovery upon restart.

hope this helps too!

kind regards
yogeeraj