Re: Help with understanding why shutdown "hangs" ...

sybrandb wrote:
> On Nov 22, 1:09 pm, "Martin T." <bilbothebagginsb..._at_freenet.de>
> wrote:
> > Hi all.
> > (O 9.2.0.1.0)
> >
> > Somehow I managed to lock up the test DB again while shutting it down.
> > I suspect it may have something to do with some java thread that is
> > started by a job, but I can't really make much of the logfiles I get.
> > When I issue a sc stop OracleServiceSID on windows (xp) this will do a
> > Shutdown Immediate.
> > This is what I did, but after an hour the shutdown is still in progress
> > and I'm very sure that this cannot be due to something big being rolled
> > back, since there isn't anything big going on in the system.
> >
> > When I look at the logfiles I can just see that the shutdown is in
> > progress and one job (the one that started a java thread) seems not to
> > terminate (the other jobs have traced out ORA-01089 + ORA-00448).
> >
> > Find the last entries of said logfiles below.
> > Maybe someone can shed a bit more light on this or tell me where to go
> > looking for more info.
> >
> > thanks!
> > Martin
> >
> > [snipped]
>
> Many times I need to
> alter system set job_queue_processes=0;
> alter system set aq_tm_processes=0;
>
> Even if there are no jobs running the job queue facility will poll the
> queue by means of SELECTs.
> MONITOR looks like a job.
>
> Hth

Sybrand, thanks.

It seems that I was too rash in stating it hangs, it shut down approx. 10 minutes after I posted here. (Which still leaves 1 hour of mystery :-)

It was most likely a job that hung, aq_tm_processes=0 is set anyway. The job in question starts some java that starts some multithreaded work that is run every few seconds. (It's not much to do, basically one table row is updated.)

What was strange, is that the trace file of j000 that had a last modification date of 12:09 in my OP was the last file that was closed by oracle.exe (13:09 or so). But nothing new was written into it.

So it apears that oracle started to log into the file and then waited for one hour (doing not much, or at least nothing worth logging) and then closed the logfile and exited.

I'm still confused I'm afraid ...

cheers,
Martin Received on Wed Nov 22 2006 - 08:21:01 CST