Re: shutdown immediate hangs

"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?

Mostly likely you have an open session. You could

1. issue shutdown ABORT then immediately startup and shutdown normal.
2. Reconsider and do HOT backups. They aren't that hard really (and dead easy to sell to management).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************