Home » RDBMS Server » Networking and Gateways » WARNING: Subscription for node down event still pending (os=linux,db=oracle10g)
WARNING: Subscription for node down event still pending [message #335632] Wed, 23 July 2008 00:55 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I saw msg in listener.log was
"WARNING: Subscription for node down event still pending"

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.

My listener.ora file is,
Should i add the parameter like this?

# listener.ora Network Configuration File: /home/oracle/product/10gR2/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = TESTDB)
      (ORACLE_HOME = /home/oracle/product/10.2.0)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = mypc.net)(PORT = 1521))
    )
  )
SUBSCRIBE_FOR_NODE_DOWN_EVENT_Listener=OFF


Please confirm because i would like to implement it in production.

Thanks in advance.
Re: WARNING: Subscription for node down event still pending [message #335721 is a reply to message #335632] Wed, 23 July 2008 07:24 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
And after this activity i need to restart the listener, am i right?

Thanks,
Re: WARNING: Subscription for node down event still pending [message #335816 is a reply to message #335632] Wed, 23 July 2008 18:00 Go to previous messageGo to next message
BlackSwan
Messages: 22542
Registered: January 2009
Senior Member
OK, I'll bite

>but also prevent the 10g TNS Listener from hanging periodically
What proof do you have that the Listener "hangs" periodically?
What is the average duration of these hangs?
Re: WARNING: Subscription for node down event still pending [message #335858 is a reply to message #335632] Thu, 24 July 2008 00:46 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I just read that point on the net while searching for the solution. Sorry for any wrong statement.

Please confirm about the same. Smile
Previous Topic: WIERD LISTENER ISSUE
Next Topic: Unable to access DB2 data from oracle
Goto Forum:
  


Current Time: Thu Jul 31 04:51:41 CDT 2014

Total time taken to generate the page: 0.10230 seconds