RE: EMN0

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Mon, 22 Jul 2002 09:38:32 -0800
Message-ID: <F001.0049E0A7.20020722093832@fatcity.com>

April,

I have been fighting this since installing 8.1.7 on windoze. I do an shutdown immediate in my backup script and then it will hang forever periodically. I have not had a solution suggested that has worked. Hope you get better results than I. Are you on windoze also? I know that when I researched this on metastink I found that many others also experience this. I opened a TAR but got nowhere fast. As EP would say.

HELP Dave

-----Original Message-----
Sent: Monday, July 22, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L

Has anyone experienced problems with Database hanging on shutdown and the only error anywhere is "Restarting dead background process EMN0 " and that appears consistently before the inability to stop the database.

I have created an Itar (which was down graded immediately...) and hunted for answers on metalink. There are two 'solutions' that they suggest. One is to ignore it... if you aren't using Advanced Queuing you don't have to worry anyway... the other is every time you shut down do shutdown abort-startup restricted- shutdown immediate... this will kill all the process (of which at the os level and the DB level the only ones running were Oracle generated processes...

oratest 36146 1 0 05:59:02 - 0:07 ora_qmn0_TEST 
oratest 36384 1 0 05:59:02 - 0:01 ora_smon_TEST 
oratest 36640 1 0 05:59:02 - 0:01 ora_ckpt_TEST 
oratest 37156 1 0 05:59:02 - 0:00 ora_dbw0_TEST 
oratest 37416 1 0 05:59:02 - 0:00 ora_pmon_TEST 
oratest 37672 1 0 05:59:02 - 0:00 ora_lgwr_TEST 
oratest 41404 1 0 05:59:02 - 0:00 ora_reco_TEST 

)

Has anyone dealt with this successfully? It deals, from what I have gathered, with Java in the database (maybe?).

Thanks in advance for any advice

April Wells
Corporate Systems
Amarillo Texas

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.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 Mon Jul 22 2002 - 12:38:32 CDT