‘Warning: Subscription For Node Down Event Still Pending’ Can Cause Hanging Listener

Receiving errors for large batch jobs in a production 11.2.0.2 database.

ERROR:
ORA-12541: TNS:no listener

The listener log contained the following event at the same time-  ‘Warning: Subscription For Node Down Event Still Pending’ . I have seen this event before and it hasn’t caused any issues but apparently there are reports of hanging issues in databases >10g.

See the following MOS document :’Warning: Subscription For Node Down Event Still Pending’ In Listener Log [ID 372959.1]

“These messages are related to the Oracle TNS Listener’s default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription.   This feature was introduced in Oracle 10g. ”

This recommendation was news to me, so this is why I put in a blog post because someone else will come across the same problem…the fix is to add to the listener.ora

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

and then reload or restart the listener. Using the Reload command in lsnrctl will be less disruptive than restarting.

Advertisements

About April C Sims

Oracle DBA for over a decade...enough said.
This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to ‘Warning: Subscription For Node Down Event Still Pending’ Can Cause Hanging Listener

  1. Kishore says:

    Thank you!

  2. shiva says:

    HIII THANK UU SO MUCH FRIEND IT HELPED ME LOT… :-)

    THNKS…

  3. Prashant Chatterjee says:

    This was a unique WARNING, and I have experienced it just two days back, whereas I had been using Oracle 10g for more than 5 years.

    Thanks a lot, and the issue is resolved.

    Warm Regards,
    Prashant

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