Anita Oracle Support doesn't really care why it is happening. All I get is, hangs happen, your two options are shutdown abort/startup restricted/shutdown immediate ("a valid solution") or putting in Dead Connection Detection and adding overhead. The ever so wonderful Metalink has at least a dozen or more docs that return on a search of EMN0, all of them acknowledging that these happen, about half commenting that you only have to worry if AQ is used, but the other half saying, yeah we know, this is the work around, get over it. Per the assigned analyst "There is nothing we can do to prevent shutdown immediate hang sometimes." Oh, and this... feature... is not fixed in 9i, and frequently appears to have something to do with Java in the database.
Thank you for the help. April -----Original Message----- Sent: Tuesday, July 23, 2002 12:53 AM To: Multiple recipients of list ORACLE-L April, The "Restarting dead background process EMN0" message immediately prior to a shutdown is an annoying, but harmless message. The EMN0 process is not started unless AQ is used and even then it will be killed if it sits idle long enough. Upon shutdown, however, it can get awakened to ensure that it processes any existing messages, if any, and thus this message is written to the alert.log. Do you have any shutdown triggers that could be preventing the db from shutting down cleanly? The best thing to do to get to the root of the hang is to take several system state dumps (at least 3, 1 - 2 minutes apart) while the system appears to be hanging. Connected as internal or a SYSDBA user: ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME SYSTEMSTATE LEVEL 10'; System state dumps can be rather large so you may want to ensure that max_dump_file_size is set very high or change it before generating the system state dump: ALTER SESSION SET MAX_DUMP_FILE_SIZE=UNLIMITED; Oracle Support should be able to determine from them why the shutdown appears to be hanging. HTH, -- Anita --- April Wells <[EMAIL PROTECTED]> wrote: > Has anyone experienced problems with Database > hanging on shutdown and the > only error anywhere is "Restarting dead background > process EMN0 " and that > appears consistently before the inability to stop > the database. > > I have created an Itar (which was down graded > immediately...) and hunted for > answers on metalink. There are two 'solutions' that > they suggest. One is > to ignore it... if you aren't using Advanced Queuing > you don't have to worry > anyway... the other is every time you shut down do > shutdown abort-startup > restricted- shutdown immediate... this will kill all > the process (of which > at the os level and the DB level the only ones > running were Oracle generated > processes... > oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST > oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST > oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST > oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST > oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST > oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST > oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST > ) > > Has anyone dealt with this successfully? It deals, > from what I have > gathered, with Java in the database (maybe?). > > Thanks in advance for any advice > > April Wells > Corporate Systems > Amarillo Texas > begin 666 InterScan_Disclaimer.txt MM 5&AE(&EN9F]R;6%T:6]N M(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!SM M =')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O<B!T M:&4@:6YT96YD960@=7-EM M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL MM >2!P<FEV:6QE9V5D(&%N M9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@M M :7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I<V-L M;W-U<F4L('5S92!O<B!CM M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA MM ;B!T:&4@:6YT96YD960@ M<F5C:7!I96YT(&ES('!R;VAI8FET960@86YD(&UA M>2!B92!I;&QE9V%L+B MM @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97 MM 86=E(&EN(&5R<F]R+"!P M;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961IM M 871E;'D@8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O M<F%T92!3>7-T96US+"!)M M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@ MM 96YS=7)E('1H870@86YY M(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%SM M (&)E96X@<W=E<'0@9F]R('9I<G5S97,N("!792!A M8V-E<'0@;F\@;&EA8FELM M:71Y(&9O<B!A;GD@9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S MM ;V9T=V%R92!V:7)U<V5S M(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5RM M (&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI M;F<@86YY(&%T=&%C:&UE %;G0N#0H M M %.$M M M -- M M P,%!3% 3%% 4(% /&&)#)!, ORACLE-L FAQ:M (440://777./2!&!1.# M/-M -- M M A54(/2: A02), W%,,3M INET: !7%,,3@#3%$ M'%.#/-M M M F!4 C)49 N%47/2+ S%26)#%3 -- (858) 5 (858) 538-5051M M S!. D)%'/, C!,)&/2.)! -- P5",)# M !##%33 / M!),).' L)343M M M ----------------- -#P,I;;]I0&3U4DQ3!@!DC MS0%""4P#023"3AP#"0)3;023 #14TP1Q;0 %# MV@+"4U)U4E8!@5 R5&3@SS0"#CU!0)>(8] $T !["4U)U4E1R0 3A "3K0 M %"!0#14TP1Q0(KY.3 "3@S%1!0 0#"3A0 SSE 20+\ MH8[)3;+0 "#T@%"!0#@310#Q@#023"3 MAP#"4U &3U0%P3E % !DCS23@ .3U0#06;0 3 M$SP$Q3A %"!0*);, SS303A !CT@#U"!4@"3@"#"2Q0$U0DPTB0B3AR3K0 M M M /__________________________________________ M______[0 #P.3U0.02#SP7[0 M 2#SP0*!03%" #0)A13 A5%!4C #"5 MA0 A5%!4K0 %%$&CSR!03%- M M #!04Q0$Q10%"!0#QAB0R03 +\H8[)3; )H<6@"%%$&CSUUU MSCT@1@43@SS;0 #0+0 !50@])H"$X"(%(044ZT M !4:&4@:6YF;W)M871I;VX@8V]N=&%I;F5D(&EN('1H M:7,@92UM86EL(&ES('-T<FEC=&QY(&-O;F9I9&5N=&EA;"!A;F0@9F]R('1H M92!I;G1E;F1E9"!U<V4@;V8@=&AE(&%D9')E<W-E92!O;FQY.R!I="!M87D@ M86QS;R!B92!L96=A;&QY('!R:79I;&5G960@86YD+V]R('!R:6-E('-E;G-I M=&EV92X@($YO=&EC92!I<R!H97)E8GD@9VEV96X@=&AA="!A;GD@9&ES8VQO M<W5R92P@=7-E(&]R(&-O<'EI;F<@;V8@=&AE(&EN9F]R;6%T:6]N(&)Y(&%N M>6]N92!O=&AE<B!T:&%N('1H92!I;G1E;F1E9"!R96-I<&EE;G0@:7,@<')O M:&EB:71E9"!A;F0@;6%Y(&)E(&EL;&5G86PN("!)9B!Y;W4@:&%V92!R96-E M:79E9"!T:&ES(&UE<W-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=&AE M('-E;F1E<B!I;6UE9&EA=&5L>2!B>2!R971U<FX@92UM86EL+@H*0V]R<&]R M871E(%-Y<W1E;7,L($EN8RX@:&%S('1A:V5N(&5V97)Y(')E87-O;F%B;&4@ M<')E8V%U=&EO;B!T;R!E;G-U<F4@=&AA="!A;GD@871T86-H;65N="!T;R!T M:&ES(&4M;6%I;"!H87,@8F5E;B!S=V5P="!F;W(@=FER=7-E<RX@(%=E(&%C M8V5P="!N;R!L:6%B:6QI='D@9F]R(&%N>2!D86UA9V4@<W5S=&%I;F5D(&%S M(&$@<F5S=6QT(&]F('-O9G1W87)E('9I<G5S97,@86YD(&%D=FES92!Y;W4@ M8V%R<GD@;W5T('EO=7(@;W=N('9I<G5S(&-H96-K<R!B969O<F4@;W!E;FEN 59R!A;GD@871T86-H;65N="X-"@T* end Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).