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).
