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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). begin 666 InterScan_Disclaimer.txt M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S M=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O<B!T:&4@:6YT96YD960@=7-E M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@ M:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I<V-L;W-U<F4L('5S92!O<B!C M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960@86YD(&UA M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!) M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@ M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S M(&)E96X@<W=E<'0@9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL M:71Y(&9O<B!A;GD@9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
