Home > TNS > WARNING: Subscription for node down event still pending

WARNING: Subscription for node down event still pending

February 15, 2011 Leave a comment Go to comments

Symptoms

In  listener log file, the warning message happened

WARNING: Subscription for node down event still pending
14-JAN-2011 11:13:30 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=gsqsvmdb)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=1
85599744)) * status * 0
2011-01-14 11:14:09.862000 +08:00
WARNING: Subscription for node down event still pending
14-JAN-2011 11:14:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=gsqsvmdb)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=1
85599744)) * status * 0
2011-01-14 11:17:02.792000 +08:00
WARNING: Subscription for node down event still pending
14-JAN-2011 11:17:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=gsqsvmdb)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=1
85599744)) * status * 0
2011-01-14 11:21:37.933000 +08:00
WARNING: Subscription for node down event still pending
14-JAN-2011 11:21:37 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=gsqsvmdb)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=1
85599744)) * status * 0
2011-01-14 11:21:52.666000 +08:00
WARNING: Subscription for node down event still pending
14-JAN-2011 11:21:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=gsqsvmdb)(USER=

Cause
These messages are related to the Oracle10g TNS Listener’s default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription.

Solution
Set the following parameter in the listener.ora:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

Where <listener_name> should be replaced with the actual listener name configured in the
LISTENER.ORA file.

This will prevent the messages from being written to the log file, but also prevent the 10g TNS
Listener from hanging periodically.

Advertisements
Categories: TNS
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: