This is indeed an interesting phenom. We noticed the same thing on all of
our 8i instances and Oracle said the below. In oracle forums several people
noted that the emn0 process appeared to cause a shutdown immediate. Indeed,
in our case an emn0 message appears in the alert logs prior to a 'shutdown
immediate' being issued before our nightly cold backups. To test I issued a
shutdown immediate and tail -f the alert log of an 8i db. The results were
thus: oracle was attempting to restart the emn0 process BEFORE shutting
down. Evidently it was successful because I have not witnessed the dead
process err below. Entirely strange since we don't use advanced queing on
any of our applications and have not enabled it via the aq_tm_processes
param.
dan
- Original Message -----
From: Rama Malladi <rmalladi_at_inteliant.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, December 29, 2000 4:55 PM
Subject: RE: strange new process (EMN0) on 8.1.7
> Sonja,
> After checking Oracle TARS, it appears that several others have the same
> problem with EMN0. Oracle Docs say ...
>
> "If you are running release 8.1.x you may see the message "found dead
> background
> process EMNO" in your alert log at startup. If you are not using the EMNO
> Advanced Queuing feature you can safely ignore this message."
>
> Hope it helps ...
> Rama
>
> -----Original Message-----
> Sent: Friday, December 29, 2000 1:05 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Rama,
> Yes well, my Oracle support told me it's aq_tm_processes and it is used
for
> advanced queing.
> The strange thing is that I don't have it (also don't want it) but it's
> still there!
> Do you have any idea?
>
> TIA,
>
> Sonja
>
>
> -----Original Message-----
> Sent: Thursday, December 28, 2000 11:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Sonja,
> I am running Oracle 8.1.7 on Solaris 7 and I do not see any such EMN0
> process. These are the processes that we have ...
>
> oracle 476 1 0 14:44:47 ? 0:00 ora_d004_TESTLAB
> oracle 474 1 0 14:44:47 ? 0:00 ora_d003_TESTLAB
> oracle 446 1 0 14:44:46 ? 0:00 ora_pmon_TESTLAB
> oracle 448 1 0 14:44:46 ? 0:00 ora_dbw0_TESTLAB
> oracle 450 1 0 14:44:46 ? 0:00 ora_lgwr_TESTLAB
> oracle 452 1 0 14:44:46 ? 0:00 ora_ckpt_TESTLAB
> oracle 454 1 0 14:44:47 ? 0:01 ora_smon_TESTLAB
> oracle 456 1 0 14:44:47 ? 0:00 ora_reco_TESTLAB
> oracle 458 1 0 14:44:47 ? 0:00 ora_s000_TESTLAB
> oracle 460 1 0 14:44:47 ? 0:00 ora_s001_TESTLAB
> oracle 462 1 0 14:44:47 ? 0:00 ora_s002_TESTLAB
> oracle 464 1 0 14:44:47 ? 0:00 ora_s003_TESTLAB
> oracle 466 1 0 14:44:47 ? 0:00 ora_s004_TESTLAB
> oracle 468 1 0 14:44:47 ? 0:00 ora_d000_TESTLAB
> oracle 470 1 0 14:44:47 ? 0:00 ora_d001_TESTLAB
> oracle 472 1 0 14:44:47 ? 0:00 ora_d002_TESTLAB
> oracle 481 1 0 14:44:55 ? 0:00 ora_i201_TESTLAB
>
> May be some settings in your INIT file are starting this new process. Do
you
> know which parameter starts this process?
>
> Rama
> ================
> -----Original Message-----
> Sent: Thursday, December 28, 2000 12:50 AM
> To: Multiple recipients of list ORACLE-L
> Hi lists!
> I have Oracle 8.1.7 on AIX.
> Yesterday when I wanted to shutdown my database with shutdown immediate,
It
> took a very long time to do it (I know the reason). Problem is that this
> process generated log:
> *** 2000-12-27 09:09:47.842
> *** SESSION ID:(1.1) 2000-12-27 09:09:47.841
> ORA-00445: background process "EMN0" did not start after 120
seconds
> *** 2000-12-27 09:15:06.443
> ORA-00445: background process "EMN0" did not start after 120
seconds
> It seems that EMN0 is a new process in 8.1.7 (something with advanced
> quing), and according to my Oracle support this error is nothing
dangerous.
> Do you have any idea what is this really ?
> TIA,
> Sonja
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rama Malladi
> INET: rmalladi_at_inteliant.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
Received on Fri Dec 29 2000 - 19:00:32 CST
