Wednesday, July 2, 2014

Quick fix for “WARNING: Subscription for node down event still pending”

[oracle@vmxdb01 admin]$ cd $ORACLE_HOME/network/admin

[oracle@vmxdb01 admin]$ echo "SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF" >> listener.ora

[oracle@vmxdb01 admin]$ lsnrctl reload

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-JUL-2014 22:42:41

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully

Please Note: Setting SUBSCRIBE_FOR_NODE_DOWN_<listener_name> to OFF disables a necessary RAC functionality. The above workaround is recommended only for non-RAC environments.
The issue may be present in all 10g and newer installations.

Note:  The use of this undocumented parameter may cause problems with the use of the Net Manager (NetMgr) configuration utility.  See Note 437598.1 NetMGR May Error When Listener.ora File Contains:SUBSCRIBE_FOR_NODE_DOWN_EVENT