Re: listener problem ...

--0-1025202362-962814406=:13496
Content-Type: text/plain; charset=us-ascii

Check your listener.log and see if that gives any indication what's happening. Two things that come to mind (though I have to admit I've never seen this condition before) are....

   An oracle agent is constantly re-connecting to the listener to verify it's up. If so, stop the agent with "lsnrctl dbsnmp_stop".    The listener has use_plug_and_play_listener set on and there's no names server for it to connect to. run "lsnrctl show use_plugandplay" to see if it's on. If you don't use oracle names, turn it off. If you do have oracle names, make sure the names servers specified in sqlnet.ora or .sdns.ora have valid addresses.

  Jomsch Kilroy <jedi99_at_gmx.net> wrote:

we've an interesting listener problem here running 8.0.5 on suse 6.4 our listener uses between 80 and 95% cpu-time with 2 active connections...

i've never seen that before, what can be wrong with it?

regards to all cracks

joe

-- 
Author: Jomsch Kilroy
INET: jedi99_at_gmx.net

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


---------------------------------
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
--0-1025202362-962814406=:13496
Content-Type: text/html; charset=us-ascii



<P>Check your listener.log and see if that gives any indication what's happening. Two things that come to mind (though&nbsp;I have to admit I've never seen this condition before) are....</P>

<OL>

<LI>An oracle agent is constantly re-connecting to the listener to verify it's up. If so, stop the agent with "lsnrctl dbsnmp_stop".</LI>

<LI>The listener has use_plug_and_play_listener set on and there's no names server for it to connect to. run "lsnrctl show use_plugandplay" to see if it's on. If you don't&nbsp;use oracle names, turn it off. If you do have oracle names, make sure the names servers specified in sqlnet.ora or .sdns.ora have valid addresses.</LI></OL>

<P>&nbsp; <B><I>Jomsch Kilroy &lt;jedi99_at_gmx.net&gt;</I></B> wrote: <BR></P>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">we've an interesting listener problem here running 8.0.5 on suse 6.4<BR>our listener uses between 80 and 95% cpu-time with 2 active connections...<BR><BR>i've never seen that before, what can be wrong with it?<BR><BR>regards to all cracks<BR><BR>joe<BR><BR><BR>-- <BR>Author: Jomsch Kilroy<BR>INET: jedi99_at_gmx.net<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>D!

o You Yahoo!?</b><br>
Kick off your party with Yahoo! Invites.