| WARNING: Subscription for node down event still pending [message #335632] |
Wed, 23 July 2008 00:55  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
