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 > M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S > M=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O<B!T:&4@:6YT96YD960@=7-E > M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL > M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@ > M:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I<V-L;W-U<F4L('5S92!O<B!C > M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA > M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960@86YD(&UA > M>2!B92!I;&QE9V%L+B > @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S > M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I > M871E;'D@8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!) > M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@ > M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S > M(&)E96X@<W=E<'0@9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL > M:71Y(&9O<B!A;GD@9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S > M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R > M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE > %;G0N#0H > end > > -- > 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). __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).