Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: strange new process (EMN0) on 8.1.7

RE: strange new process (EMN0) on 8.1.7

From: Sonja Šehović <sonja.sehovic_at_zg.tel.hr>
Date: Fri, 29 Dec 2000 10:04:51 +0100
Message-Id: <10725.125436@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C0717E.C8C89360 Content-Type: text/plain;

        charset="iso-8859-2"
Content-Transfer-Encoding: 8bit

RE: strange new process (EMN0) on 8.1.7Rama, 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:

  TIA,
          Sonja

------=_NextPart_000_0018_01C0717E.C8C89360 Content-Type: text/html;

        charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: strange new process (EMN0) on 8.1.7</TITLE>
<META content=3D"text/html; charset=3Diso-8859-2" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000>Rama,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN class=3D088264908-29122000>Yes =
well, my=20
Oracle support told me it's aq_tm_processes and it is used for advanced = queing.=20
</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN class=3D088264908-29122000>The =
strange thing=20
is that I don't have it (also don't want it) but it's still=20 there!</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN class=3D088264908-29122000>Do =
you have any=20
idea?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000>TIA,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000>&nbsp;&nbsp;&nbsp; </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000>&nbsp;&nbsp;&nbsp; Sonja</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff size=3D2><SPAN=20
class=3D088264908-29122000></SPAN></FONT><FONT face=3DTahoma = size=3D2>-----Original=20
Message-----<BR><B>From:</B> root_at_fatcity.com = [mailto:root_at_fatcity.com]<B>On=20
Behalf Of </B>Rama Malladi<BR><B>Sent:</B> Thursday, December 28, 2000 = 11:46=20
PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> = RE:=20
strange new process (EMN0) on 8.1.7<BR><BR></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"></FONT>
  <DIV><SPAN class=3D344144522-28122000></SPAN><FONT face=3D"Comic Sans = MS"><FONT=20
  color=3D#008080><FONT size=3D2>S<SPAN=20   class=3D344144522-28122000>onja,</SPAN></FONT></FONT></FONT></DIV>   <DIV><FONT face=3D"Comic Sans MS"><FONT color=3D#008080><FONT = size=3D2><SPAN=20
  class=3D344144522-28122000>&nbsp;I am running Oracle 8.1.7 on Solaris = 7 and I do=20
  not see any such EMN0 process. These are the processes that we have=20   ...</SPAN></FONT></FONT></FONT></DIV>
  <DIV><FONT face=3D"Comic Sans MS"><FONT color=3D#008080><FONT = size=3D2><SPAN=20
  class=3D344144522-28122000></SPAN><SPAN=20   class=3D344144522-28122000>&nbsp;</SPAN></FONT></FONT></FONT><BR><FONT =

  face=3D"Comic Sans MS"><FONT color=3D#008080><FONT size=3D2>&nbsp;=20   oracle&nbsp;&nbsp; 476&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_d004_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 474&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_d003_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 446&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:46=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_pmon_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 448&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:46=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_dbw0_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 450&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:46=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_lgwr_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 452&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:46=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_ckpt_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 454&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:01 = ora_smon_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 456&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_reco_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 458&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_s000_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 460&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_s001_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 462&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_s002_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 464&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_s003_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 466&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_s004_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 468&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_d000_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 470&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_d001_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 472&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:47=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_d002_TESTLAB<BR>&nbsp;=20
  oracle&nbsp;&nbsp; 481&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; 0 14:44:55=20   ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 = ora_i201_TESTLAB<BR><SPAN=20
  class=3D344144522-28122000>&nbsp;</SPAN></FONT></FONT></FONT></DIV>   <DIV><FONT face=3D"Comic Sans MS"><FONT color=3D#008080><FONT = size=3D2><SPAN=20
  class=3D344144522-28122000>May be some settings in your INIT file are = starting=20
  this new process. Do you know which parameter starts this=20   process?</SPAN></FONT></FONT></FONT></DIV>   <DIV><FONT face=3D"Comic Sans MS"><FONT color=3D#008080><FONT = size=3D2><SPAN=20
  class=3D344144522-28122000></SPAN></FONT></FONT></FONT>&nbsp;</DIV>   <DIV><FONT face=3D"Comic Sans MS"><FONT color=3D#008080><FONT = size=3D2><SPAN=20
  class=3D344144522-28122000>Rama</SPAN></FONT></FONT></FONT></DIV>   <DIV><FONT face=3D"Comic Sans MS"><FONT color=3D#008080><FONT = size=3D2><SPAN=20
  =
class=3D344144522-28122000>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= &nbsp;</SPAN></FONT></FONT></FONT></DIV>   <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From: Sonja=20
  =A9ehovic [<A=20
  =
href=3D"mailto:sonja.sehovic_at_zg.tel.hr">mailto:sonja.sehovic_at_zg.tel.hr</A= >]</FONT>=20
  <BR><FONT size=3D2>Sent: Thursday, December 28, 2000 12:50 AM</FONT> =
<BR><FONT=20

  size=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT=20   size=3D2>Subject: strange new process (EMN0) on 8.1.7</FONT> </P>   <P><FONT size=3D2>Hi lists!</FONT> <BR><FONT size=3D2>I have Oracle = 8.1.7 on=20
  AIX.</FONT> <BR><FONT size=3D2>Yesterday when I wanted to shutdown my = database=20
  with shutdown immediate, It</FONT> <BR><FONT size=3D2>took a very long = time to=20
  do it (I know the reason). Problem is that this</FONT> <BR><FONT=20   size=3D2>process generated log:</FONT>=20   <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT size=3D2>*** = 2000-12-27=20
  09:09:47.842</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT=20

  size=3D2>*** SESSION ID:(1.1) 2000-12-27 09:09:47.841</FONT>=20   <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT = size=3D2>ORA-00445:=20
  background process "EMN0" did not start after 120 seconds</FONT>=20   <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT size=3D2>*** = 2000-12-27=20
  09:15:06.443</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT=20

  size=3D2>ORA-00445: background process "EMN0" did not start after 120=20   seconds</FONT> <BR><FONT size=3D2>It seems that EMN0 is a new process = in 8.1.7=20
  (something with advanced</FONT> <BR><FONT size=3D2>quing), and = according to my=20
  Oracle support this error is nothing dangerous.</FONT> <BR><FONT = size=3D2>Do you=20 Received on Fri Dec 29 2000 - 03:04:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US