topic Re: shutdown pending in Operating System - HP-UX

shutdown pending

attilio_1 — Fri, 02 Dec 2005 07:24:13 GMT

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

Re: shutdown pending

Jean-Luc Oudart — Fri, 02 Dec 2005 07:29:38 GMT

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

Re: shutdown pending

Devender Khatana — Fri, 02 Dec 2005 07:31:51 GMT

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

Re: shutdown pending

Steven E. Protter — Fri, 02 Dec 2005 07:47:42 GMT

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

Re: shutdown pending

attilio_1 — Fri, 02 Dec 2005 07:50:21 GMT

Hello Jean-Luc,

With the option abort the instance is gone down

thanks a lot
Attilio

Re: shutdown pending

Borislav Perkov — Fri, 02 Dec 2005 07:54:07 GMT

Hi Attilio,

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

Regards,
Borislav

Re: shutdown pending

Yogeeraj_1 — Fri, 02 Dec 2005 08:06:50 GMT

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