Re: 8i listener stops responding;spawns a second non functional listener process

In article <t13okg4aft99ce_at_corp.supernews.com>,   "Dave A" <dave_and_vanna_at_hotmail.com> wrote:
> Hi all,
>
> On Solaris 2.6 with ORacle 8.1.6.2 the listener sometimes(a couple
 times per
> week) stops responding. There are no errors in the listener.ora and
 the
> listener is just too active to turn tracing on. Connection attempts
 will
> time out(I have increased the timeout from 10 seconds to 30 seconds).
> lsnrctl commands also hang.
>
> At the OS level, a ps -ef shows 2 listener processes when only one was
> started(there is only one when the listener is working.
>
> I'm at a loss here as there isn't any error to use as a starting
 point.
> Background info is that the server(6500) has 20 processors which run
 at
> about 10% idle, 9gb ram with about 2-3 gb free, 9gb swap with about
 8gb
> free. The listener gets about 1-3 connection requests per second. I
 am not
> using multithreaded server.
>
> Any advice?
>
> --
> Dave A
>
>

I would guess you have many inactive sessions in your database which never disconnect (and still are 'known' to the listener). You should try to enable sqlnet.expire_time in sqlnet.ora on the server. You also should definitely switch to MTS.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.