Xref: alice comp.databases.oracle.server:39534 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.nacamar.de!serra.unipi.it!news.esrin.esa.it!not-for-mail From: James Dickson Newsgroups: comp.databases.oracle.server Subject: Re: Shutdown Immediate hangs process Date: Tue, 02 Feb 1999 10:57:16 +0100 Organization: European Space Agency / Serco Lines: 17 Message-ID: <36B6CBFC.7DF@mail.esrin.esa.it> References: <78hrbp$hf4$1@nnrp1.dejanews.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m) davidm@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@valhall.esrin.esa.it.NOSPAM