RE: An interesting listener issue

From: Chitale, Hemant Krishnarao <Hemant.Chitale_at_sc.com>
Date: Tue, 18 Oct 2011 10:33:57 +0800
Message-ID: <8375C7FDC01FEB40A11B49DD940A96ABEE18D1_at_HKMGAXMB110A.zone1.scb.net>

On 10gR1 and 10gR2 this was a known issue. See references to Bug#4518443 at support.oracle.com

For example
Intermittent TNS Listener Hang, New Child Listener Process Forked [ID 340091.1] 10g Listener: High CPU Utilization - Listener May Hang [ID 284602.1]

I wonder if it manifested in 9.2.0.8 as well.

 
Hemant K Chitale

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Haddon Sent: Tuesday, October 18, 2011 6:46 AM
Cc: Oracle Discussion List
Subject: An interesting listener issue

Today I was brought into a performance issue on one of our databases. There were a couple of resource issues and during the analysis I noticed that the listener was attempting to be started when it is already running. The database is 9.2.0.8 (yeah, I know, it supports a legacy app), and the listener is on default port.

The problem is that I continue to see the system try to start the same listener. This of course fails because the port is already open but the attempt is made again in a minute or two.

*Hostname->SID:> ps -ef | grep lsnr

   oracle 3768386 1 120 May 27 - 13233:59
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit

   oracle 4231390 3805240 1 17:23:10 pts/0 0:00 grep lsnr Hostname->SID:> ps -ef | grep lsnr

   oracle 3768386 1 120 May 27 - 13234:00
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit

   oracle 5882040 1 102 17:23:12 - 0:00
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit

*Wait a few minutes
*
ps -ef | grep lsnr

   oracle 3768386 1 60 May 27 - 13235:58
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit
**Hostname->SID**:> r ps
ps -ef | grep lsnr

   oracle 3768386 1 120 May 27 - 13235:58
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit
**Hostname->SID**:> r ps
ps -ef | grep lsnr

   oracle 3768386 1 120 May 27 - 13236:00
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit

   oracle 5042184 1 17 17:30:14 - 0:00
/u00/app/oracle/product/9.2.0.8/bin/tnslsnr LISTENER -inherit

*On top of this the original instance of the listener is taking up a complete CPU on the system.

*Name            PID  CPU%  PgSp Owner
tnslsnr     3768386  27.2 782.2 oracle

*
I have checked everywhere for the reason the listener is being started again. There are no cron jobs, at jobs, running processes, dbms jobs that would be trying to restart. The only thing I can think of is maybe the listener is bound and trying to restart itself. We do not have Oracle Restart installed and configured so I am at a lack.

I will be shutting down and restarting the listener later this evening but this is such a vexing issue I don't want to walk away from this issue without truly understanding what is happening. I think it is related to the size of the listener log (> 2GB) and will be resetting the log this evening.

Has anyone seen this before? The OS is AIX 5.3 (LPAR) with 9.2.0.8 Oracle binaries.

Any ideas would be very welcome.

Thanx in advance,

Mike

--
http://www.freelists.org/webpage/oracle-l



This email and any attachments are confidential and may also be privileged.  If you are not the addressee, do not disclose, copy, circulate or in any other way use or rely on the information contained in this email or any attachments.  If received in error, notify the sender immediately and delete this email and any attachments from your system.  Emails cannot be guaranteed to be secure or error free as the message and any attachments could be intercepted, corrupted, lost, delayed, incomplete or amended.  Standard Chartered PLC and its subsidiaries do not accept liability for damage caused by this email or any attachments and may monitor email traffic.

Standard Chartered PLC is incorporated in England with limited liability under company number 966425 and has its registered office at 1 Aldermanbury Square, London, EC2V 7SB.

Standard Chartered Bank ("SCB") is incorporated in England with limited liability by Royal Charter 1853, under reference ZC18.  The Principal Office of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the United Kingdom, SCB is authorised and regulated by the Financial Services Authority under FSA register number 114276.

If you are receiving this email from SCB outside the UK, please click http://www.standardchartered.com/global/email_disclaimer.html to refer to the information on other jurisdictions.
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 17 2011 - 21:33:57 CDT