MMNL absent during shutdown immediate

  • From: Ray Stell <stellr@xxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 12 Apr 2013 12:55:45 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: