Re: MMNL absent during shutdown immediate

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 23 Apr 2013 12:13:07 +0100
Message-ID: <CAPMSPxPbCW--Si-QiTr2uyMtZfqEkH27SgCYVnVBFy42sRejkw_at_mail.gmail.com>

Hi
Is this bug 14213856?
I guess the workaround is to do a checkpoint and then an abort. Regards
Pete

On 12 April 2013 17:55, Ray Stell <stellr_at_vt.edu> wrote:

> WIth 11.2.0.3 on OL 5.9 we are experiencing some long delays during
> shutdown immediate. I did a 10046 trace as suggested in 164504.1
> on a shutdown immediate and the wait all with this MMNL process going AWOL:
>
> *** 2013-04-12 07:21:19.315
> WAIT #47711582838936: nam='rdbms ipc reply' ela= 149 from_process=7
> timeout=2147483647 p3=0 obj#=-1 tim=1365765679315276
> XCTEND rlbk=0, rd_only=1, tim=1365765679315850
> MMNL absent for 1304 secs; Foregrounds taking over
>
> this was a rather short wait, only 20 minutes as some have been much
> longer. Is there something I can do to make this wait/shutdown
> cleaner/shorter?
> I see this has been an issue for awhile via google, but I don't see any
> fix besides an abort. This is an interesting observation:
> http://www.runningoracle.com/product_info.php?products_id=386
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards

Pete


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 23 2013 - 13:13:07 CEST