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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EMN0

RE: EMN0

From: April Wells <awells_at_csedge.com>
Date: Tue, 23 Jul 2002 04:28:21 -0800
Message-ID: <F001.0049F3B1.20020723042821@fatcity.com> 





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,







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_at_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_at_M                   
M                    :7,@:&5R96)Y(&=I=F5N('1H870_at_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_at_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_at_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_at_86YY
M(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%SM                   
M                    (&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A
M8V-E<'0@;F\@;&EA8FELM                                       
M:71Y(&9O<B!A;GD_at_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_at_SS0"#CU!0)>(8] $T !["4U)U4E1R0 3A "3K0  
M                  %"!0#14TP1Q0(KY.3 "3_at_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_at_1@43_at_SS;0    #0+0             !50@])H"$X"(%(044ZT       
M                  !4:&4@:6YF;W)M871I;VX_at_8V]N=&%I;F5D(&EN('1H
M:7,@92UM86EL(&ES('-T<FEC=&QY(&-O;F9I9&5N=&EA;"!A;F0_at_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_at_86YD+V]R('!R:6-E('-E;G-I
M=&EV92X@($YO=&EC92!I<R!H97)E8GD_at_9VEV96X@=&AA="!A;GD_at_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_at_97)R;W(L('!L96%S92!N;W1I9GD@=&AE
M('-E;F1E<B!I;6UE9&EA=&5L>2!B>2!R971U<FX_at_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_at_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_at_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_at_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: ListGuru_at_fatcity.com (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: awells_at_csedge.com

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: ListGuru_at_fatcity.com (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).


Received on Tue Jul 23 2002 - 07:28:21 CDT












Original text of this message













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