Oracle10g – Additional Listener Process Spawned

I am running Oracle10g (10.2.0.2) on Solaris 9 SPARC 64-bit. Intermittently, an additional listener process is created by Oracle causing the LISTENER to refuse connections to the database.

I submitted a Service Request to Oracle Support and they pointed me to Note 284602.1 with two solutions described below. I chose solution #2. Let’s see if that alone resolves the problem.

1) Rename the Oracle10g ons.config file so the listener does not find or use it.

cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig

(then restart the listener)

2) Explicitly disable the 10g TNS Listener from subscribing to the ONS.

Edit the active 10g listener.ora file and add the parameter below:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

where <listener_name> would be replaced with the actual listener name configured in the listener.ora file.

For example, if the listener name is LISTENER (default), the parameter would be:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

(then restart the listener)

Also found some information on the Oracle-L from June 2006 regarding the same topic. In the thread, Rob Pegram notes they implemented solution #1 and the problem re-occurred again two months later. They were then instructed to implement both solutions.

Update (23-May-2007)
Doug Burns discusses his encounter and mentions a patch to fix this problem in his blog.  He adds additional information in Part 2.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: