RE: 10Gr2 two listener problem (parent fork child)????

From: <Scott.Washburn_at_ferguson.com>
Date: Fri, 3 Aug 2007 13:59:52 -0400
Message-ID: <EE92CDCECE9F354EB68EC77BF61891A14EE14A@fei00018mx001.hq.ferg.com>

I think this is a bug in 10.2. Here are the Oracle notes that you can review:

Note 284602.1 10g Listener: High CPU Utilization - Listener May Hang
Note 371052.1 Listener Is Consuming 100% CPU
Note 340091.1 Intermittent TNS listener hang, new child listener process

I have used the following to fix the problem on our databases:

Edit the active 10g listener.ora file and add the parameter below: SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

Or rename the ons.config file:

cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig
(then restart the listener)

Scott Washburn

Oracle Database Administrator
Wolseley North America Division
12500 Jefferson Ave
Newport News * VA * 23602-4314
T: +1 (757) 223-6404 F: +1 (757) 989 2501 E: scott.washburn_at_ferguson.com

www.wolseley.com
Wolseley plc registered office
Parkview 1220 Arlington Business Park
Theale Nr Reading Rg7 4GA United Kingdom Registration No. 29846 England

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Friday, August 03, 2007 1:36 PM
To: oracle-l_at_freelists.org
Subject: 10Gr2 two listener problem (parent fork child)????

we have ORACLE 10gr2 on Redhar AS 4.3. ORACLE version is 10.2.0.2.

Today we have users report can NOT connect to database. I checj listener and found there have two listeners (parent and child). The parent automatic fork another child. It cause listener conflict and stop.

]%ps -ef|grep lsnr

oracle 5589 1 0 May20 ? 00:15:39
/home/app/oracle/product/10.2/bin/tnslsnr LISTENER
-inherit

oracle 27132 5589 0 12:19 ? 00:00:00
/home/app/oracle/product/10.2/bin/tnslsnr LISTENER
-inherit

Is this a ORACLE bug or something else?

I tried to stop listeners, but it hang. I need "kill" both processes then restart new listener.

Thanks.

____________Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo.com/

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


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

Received on Fri Aug 03 2007 - 12:59:52 CDT