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 <awells_at_csedge.com> 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_at_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_at_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_at_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_at_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_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S
>
M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL
>
M:71Y(&9O<B!A;GD_at_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: 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).
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: abardeen1_at_yahoo.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 - 00:53:19 CDT
