Re: Shutdown Immediate hangs process

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Tue, 02 Feb 1999 10:57:16 +0100
Message-ID: <36B6CBFC.7DF@mail.esrin.esa.it>

davidm_at_s-scape.ca wrote:
>
> Oracle 8.0.4 on Windows NT 4 sp3.
>
> Inorder to do a complete backup, I use the shutdown immediate command
> nightly. Every two weeks or so it screws up. The Oracle process is still
> running but didn't shutdown properly. It's left if a state where I can't
> stop it from NT services nor can I connect to the database to issue it any
> stop or start commands. The end result is that I have to kill the process

Try 'shutdown abort' followed immediately by 'startup open' then 'shutdown normal'.

James
--
james_at_valhall.esrin.esa.it.NOSPAM Received on Tue Feb 02 1999 - 03:57:16 CST