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

Hey Scott,

Thanks for the info. I had forgotten about this and I'm planning an upgrade from 10.1 to 10.2 in '08 Q1. The only thing I'm wondering about is the impact the workaround has on Grid Control monitoring, which I haven't used for production until recently.

Also, I couldn't find note 371052.1, even among the Metalink archived notes.  And Metalink doesn't like using the "%" when searching, which I'm guessing is a side-effect of Oracle Context searching... :)

Thanks!
Rich

• From: <Scott.Washburn_at_xxxxxxxxxxxx>
• Date: Fri, 3 Aug 2007 13:59:52 -0400

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

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