RE: strange new process (EMN0) on 8.1.7

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Fri, 29 Dec 2000 13:54:11 -0800
Message-Id: <10725.125476@fatcity.com>

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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sonja Šehović Sent: Friday, December 29, 2000 1:05 AM
To: Multiple recipients of list ORACLE-L Subject: RE: strange new process (EMN0) on 8.1.7

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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rama Malladi Sent: Thursday, December 28, 2000 11:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: strange new process (EMN0) on 8.1.7

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-----
From: Sonja Šehovic [mailto:sonja.sehovic_at_zg.tel.hr] Sent: Thursday, December 28, 2000 12:50 AM To: Multiple recipients of list ORACLE-L Subject: strange new process (EMN0) on 8.1.7 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.

Received on Fri Dec 29 2000 - 15:54:11 CST