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

1 comment:

  1. I’m curious to find out what blog platform you happen to be utilizing? I’m experiencing some small security issues with my latest website and I’d like to find something more secure. Do you have any recommendations? stage lighting rental in Orlando

    ReplyDelete