Re: db hang on shutdown

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
>
>
>Ed Stevens wrote:
>

<snip>
That worked quite well. Thanks for the tip.

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