Re: db hang on shutdown - uh, maybe not

On Wed, 16 Jan 2002 05:51:15 GMT, Paul Drake <paled_at_home.com> wrote:

>Ed,
>
>use a better shutdown routine.
>This is from memory, please test.
>
>execute in svrmgr30:
>
>alter system checkpoint;
>alter system archive log all;
>shutdown abort
>startup mount restrict
>alter system set job_queue_processes=0;
>alter database open;
>shutdown normal
>
>in this manner, you get a shutdown guaranteed, and the dbms_jobs can't
>interfere with the restart/clean shutdown.
>
>hth,
>
>Paul
>
>

<snip>
>
>

Seems I spoke too soon. It worked fine on a test db, but when it came time to run it for real on the production db, we again hung on the SHUTDOWN. The script looks like this:

• begin quote === connect sys/xxxx_at_xxxx as sysdba alter system checkpoint; alter system archive log all; shutdown abort; startup mount restrict pfile=xxxxxxx alter system set job_queue_processes=0; alter database open; shutdown immediate exit
• end quote ===

and the spooled output looks like this, indicating that it hung on the SHUTDOWN ABORT command.

• begin quote === Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Release 8.0.5.1.1 - Production
PL/SQL Release 8.0.5.1.0 - Production

Connected.
Statement processed.
ORA-00271: there are no logs that need archiving Terminate batch job (Y/N)?
=== end quote ===

Looking at the alert.log and the NT system and application logs indicates that nearly an hour passed between issuing the SHUTDOWN and the operator finally pulling the plug

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)