Oracle-L: RE: EMN0

From: April Wells <awells_at_csedge.com>
Date: Mon, 22 Jul 2002 11:38:40 -0800
Message-ID: <F001.0049E621.20020722113840@fatcity.com>

The solutions (the ones that I got) aren't good ones.

Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID solution'???) or add some much needed overhead by turning on sqlnet.expire_time parameter... I'm missing something here...

'This option can be used only on the server.

Sets a dead connection time-out value. Net8 sends a probe periodically to verify that a client-server connection is still active. This ensures that connections are not left open indefinitely, due to an abnormal client termination. If the probe finds a dead connection, or a connection that is no longer in use, it returns an error, causing the server process to exit.

Limitations on using the dead connection detection feature are:

Dead connection detection is not allowed on bequeathed connections.

Though very small, a probe packet generates additional traffic that may downgrade network performance.

The server may need to perform additional processing to distinguish the connection probing event from other events that occur, depending on which operating system is in use. This may also result in downgrading network performance. '

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

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).

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_at_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_at_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_at_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_at_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_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S
M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL
M:71Y(&9O<B!A;GD_at_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: awells_at_csedge.com

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