Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with understanding why shutdown "hangs" ...

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

From: EscVector <Junk_at_webthere.com>
Date: 22 Nov 2006 06:37:41 -0800
Message-ID: <1164206261.671857.3300@j44g2000cwa.googlegroups.com>

Martin T. wrote:
> 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

Were the any active transactions? Rolback can take a long time. Received on Wed Nov 22 2006 - 08:37:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US