It's a harmless, but misleading error message.
The EMN0 process (new in 8i) is the Event Monitor
process used by AQ (see note 105067.1 "What is the
EMN0 process?" for more details).
I believe it's not started unless AQ_TM_PROCESSES > 0.
Like PQ processes that are idle long enough it will
eventually die. For some reason the shutdown process
activates the EMN0 process, hence the message in the
alert.log. I don't know enough about AQ to know if
the EMN0 process needs to check for messages or
process anything on shutdown or whether it's just an
annoying, but ultimately harmless bug.
HTH,
- Anita
- Stephane Faroult <sfaroult_at_oriolecorp.com> wrote:
>
> > Hi Gurus
> > Some times one of instance is shutdown.When I
> checked alert log found
> > following error message.
> > Mon Jun 18 09:04:21 2001
> > Restarting dead background process EMN0
> > EMN0 started with pid=15
> > Mon Jun 18 09:04:24 2001
> > The similar kind of problem I faced when I
> shutdown the database by shutdown
> > immediate option.I couldn't find much information
> on metalink.Let me know
> > what could be problem.Any one have faced similar
> kind of problem?
> > Thanks
> > -Seema
>
> EMN0, of which I had never heard before, is
> according to V$BGPROCESS an 'even
> monitor process' (guess it's a kind of sub-pmon or
> sub-smon). It doesn't seem
> to be started by default. If I were you, I would
> first look in
> background_dump_dest for a trace, because if it died
> it probably didn't die
> without a last phrase. If the trace file is not
> clear enough (likely), send it
> to the Oracle Support to keep them busy and in the
> mean time try to find out
> what makes the b*****y EMN0 start and check whether
> you really need it.
>
> HTH,
>
> Stephane Faroult
> Oriole
> Corporation
>
> ---------------------------------------------
> Performance tools for Oracle ®
> http://www.oriole.com/
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.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!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.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 Wed Jun 27 2001 - 04:53:09 CDT
