Re: Database won't shutdown immediate

From: "Daniel J. Potter" <djpotter_at_one.net> >>  (Oracle 7.1.3 on Digital Unix 3.2(D I believe?)) For the past few weeks, the shutdown has hung. The are no ORA errors listed in the alert log at this time.  <<

I do not know what is causing your problem for sure, but I have seen similiar events when a 'shutdown immediate' normally works and have usually been able to assist the database shutting down by terminating the user oracle sessions at the OS level.

May I suggest you wirte a new shutdon script that 1) issues 'alter system enable restricted session;' 2) run a script that generates and runs a script that issues   "alter system kill session 'sid,serial#'; " 3) pauses for a few seconds to allow Oracle backouts to complete then hosts a script that kills the Oracle processes at the OS level 4) issues the 'shutdown immediate' command   and you could add
5) restart database in restricted mode and issue normal shutdown

This will greatly reduce the chances of your sleep being interrupted to have the database shutdown We use scripts to do items 2 and 3, but we always shut our system down semi-manually. We provided our System Admin a script that does item 1 and 4 after they run item 3 manually.

One last comment, you did check to make sure Oracle is not busy backing out a long running job, with only one commit at the end, that was added to the schedule a couple of weeks back.
Sometimes developers do the strangest things.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sat Jan 24 1998 - 00:00:00 CST