cancel
Showing results for 
Search instead for 
Did you mean: 

shutdown pending

SOLVED
Go to solution
attilio_1
Frequent Advisor

shutdown pending

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

6 REPLIES
Jean-Luc Oudart
Honored Contributor
Solution

Re: shutdown pending

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
fiat lux
Devender Khatana
Honored Contributor

Re: shutdown pending

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
Impossible itself mentions "I m possible"
Steven E. Protter
Exalted Contributor

Re: shutdown pending

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
attilio_1
Frequent Advisor

Re: shutdown pending

Hello Jean-Luc,

With the option abort the instance is gone down

thanks a lot
Attilio

Borislav Perkov
Respected Contributor

Re: shutdown pending

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
Honored Contributor

Re: shutdown pending

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)