I don't know if this helps, but I had this problem once when the port that the listener was
listening on hosed up. I stopped the listener, and switched it to another port and that fixed it.
I don't know what or how the port hosed, but at least I was able to work around it.
- Chuck Hamilton <chuck_hamilton_at_yahoo.com> wrote:
>
> 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.
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Wed Jul 05 2000 - 14:39:38 CDT