Re: More than one listener process

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sat, 23 May 2009 07:58:44 -0700 (PDT)
Message-ID: <cfc7c61f-88bf-48eb-a5d4-e816da9c07a1_at_g1g2000yqh.googlegroups.com>



On May 22, 6:07 pm, jim <jhav..._at_gmail.com> wrote:
> I'm running Oracle 10.2.0.3.0 Enterprise Server on RHEL 4. I notice
> after a couple days a second listener process gets created. Client
> can't connect when this happens and I need to stop and restart the
> listener then only 1 listener process is running. Does anyone know why
> this is happening and how to fix it?
>
> $ ps -ef | grep LISTENER
>
> oracle   13529     1  0 May18 ?        00:00:48 /u01/app/oracle/oracle/
> product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
> oracle   25326 13529  0 May21 ?        00:00:00 /u01/app/oracle/oracle/
> product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

We have had this issue. We added a listener.ora parameter to avoid the issue. I think the parameter was
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF. Researching this parameter I found two metalink notes that mentioned symptons like you describe. Based on the notes the issue is supposed to be fixed in 10.2.0.3 As Mladen suggested looking at the error logs would help you match your problem to problem reports available on support.

Look at the following two "My Oracle Support" documents:

Intermittent TNS Listener Hang, New Child Listener Process Forked #340091.1

10g Listener: High CPU Utilization - Listener May Hang #284602.1

The parameter setting applies to both RAC and non-RAC environments.

HTH -- Mark D Powell --

Note - third appempt to post as Google reports errors on prior attemps so my apologies if multiple responses show up. Received on Sat May 23 2009 - 09:58:44 CDT

Original text of this message