Oracle-L: RE: EMN0

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Mon, 22 Jul 2002 10:43:39 -0800
Message-ID: <F001.0049E3A7.20020722104339@fatcity.com>

In my experience from Saturday, even 'shutdown immediate' does not work. Are you getting any ORA-600's in your alert.log? I was. Have you recently run utlirp.sql? That's what hosed me up, but I had to because I was refreshing from 64-bit Oracle to 32-bit Oracle.

Good Luck,
Mike

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

There is no EMN0 process out there TO kill... that is what concerns me. There are also no user connections (haven't had the listener started in a while... it is (so far) for user testing patches, and we haven't had any patches since we got TEST.

Quite honestly I like your solution better than Oracle's... they claim there is no solution other than to shutdown abort, startup restrict, shutdown immediate (EVERY time you shutdown the database... this is a legitimate way of stopping ... per metalink person)

-----Original Message-----
Sent: Monday, July 22, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L

April:

I just had something like this over the weekend. In my case, the server was trying to run 'dbms_java.stop_server'. There was some mysterious corruption in the stored Java classes that was making this process hang.

If you look at 'ps' or 'top', do you see the client process from svrmgrl running at top speed? If you kill the EMN0 process, does it restart?

I was able to run 'sqlplus /nolog' and 'connect internal' even after the shutdown had started, and I looked at the running SQL. That's how I found this.

If indeed this is the problem, you will need to deinstall and reinstall Java.

Good Luck!
Mike

-----Original Message-----
Sent: Monday, July 22, 2002 9: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: Vergara, Michael (TEM)
INET: mvergara_at_guidant.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).

--

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

Author: Vergara, Michael (TEM)
INET: mvergara_at_guidant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------