Re: shutdown immediate hangs

I have seen this on one system I worked on. What I did was issue a
  alter system checkpoint;

About 3 minutes prior to the shutdown.
It has not hung since. (1 year)

This may or may not help in your case.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Cristian Veronesi" <veronesic_at_libero.it> wrote in message news:am9ba1$e88$1_at_panco.nettuno.it...
> Hello, Oracle 7.3.4 on SCO Openserver 5.0.4 here (I know, I know!)
>
> I have a cron script that every night shuts down the database, copy the
> files on tape and restart the database (cold backup).
> Sometimes the script is not able to shut down the database and in the
> morning the database is still in shutdown progress. If I telnet into the
> system and manually kill all the oracle<sid> processes (except the one
> that is performing the shutdown of course :)) the database shuts down
> immediatly.
> The script performs a SHUTDOWN IMMEDIATE.
>
> Any suggestion?
>
> Thanks in advance, Cris
>
Received on Wed Sep 18 2002 - 05:40:00 CDT