Seema,
I also am having this exact same problem. It happened last night during the
nightly backup scripts which issue a "shutdown immediate" and then I get the
"Restarting dead background process EMN0" message in my <SID>Alert.log and
then my database hangs. I am currently searching metastink. I did a search
on "Restarting dead background process EMN0". What I am seeing is that
there are other people having this problem. I had a post on this list the
other day with a subject of "License high water mark" in which I thought I
had a different problem.
What happened was that my DB just up and did a shutdown immediate on its
own. From reading on metalink there are others that have experienced this
unwanted shutdown. They all had the "Restarting dead background process
EMN0" in there <SID>alert.log right before the shutdown immediate was
issued.
Oracle seems to weasle out af giving any kind of answer on this exept to say
to read DocID 105067.1. They do not think that the DB is shutting itself
down, that it is probably some rogue network admin guy doing a shutdown.
Must be NT gremlins.
Hope this helps!
Dave
"So many cats...........So few recipes!!"
-----Original Message-----
Sent: Wednesday, June 27, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L
EMN0 is for advanced queueing, are you using AQ or uses something that might
use AQ?
Richard
>>> [EMAIL PROTECTED] 06/27/01 06:30AM >>>
Could it be that your OEM is starting the event monitor process.
Just guessing ....
Ravinder
Stephane
Faroult To: Multiple recipients of
list ORACLE-L
<sfaroult@oriol <[EMAIL PROTECTED]>
ecorp.com> cc:
Sent by: Subject: Re: EMN0 process
problem
[EMAIL PROTECTED]
m
27-Jun-2001
01:30 AM
Please respond
to ORACLE-L
Sender Info:
No Sender Info
found in the
address Book
> 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: [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).
____________________________________________________________________________
__________
Visit us at www.singaporeair.com.
____________________________________________________________________________
__________
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
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).
