FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / Non-Coded Errors and Alerts / WARNING: Subscription for node down event still pending / Latest Posts

RE: WARNING: Subscription for node down event still pending

Admin — Thu, 10 Jun 2010 12:48:21 GMT

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.

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.

Hope this works for you.

Thanks,

RE: WARNING: Subscription for node down event still pending

Admin — Sun, 18 Jan 2009 09:56:30 GMT

I figured out the solution and it was very tricky and unique.

Problem occurred when my local ip changed from 192.168.1.2 to 1.92.168.1.4

So I changed the following info:
I changed from old to new ip in my init.ora
I changed ip from old to new in listener.ora
I changed ip from old to new in tnsnames.ora

So when I was trying to connect using sqlplus , it was not connecting

Reason: I had my sqlnet.ora restricted to 192.168.1.3,192.168.1.2
so I just added 192.168.1.4 and everything worked fine now.

Thank you.

RE: WARNING: Subscription for node down event still pending

Admin — Sun, 18 Jan 2009 09:53:53 GMT

This is another difference when it was working, log look liked this
16-JAN-2009 15:57:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=vipdb)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)) * establish * vidpdb * 0
1

Now it is

WARNING: Subscription for node down event still pending
16-JAN-2007 08:08:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status

RE: WARNING: Subscription for node down event still pending

Admin — Sun, 18 Jan 2009 09:52:17 GMT

btw this happens only when i restart my listener using lsnrctl

WARNING: Subscription for node down event still pending

Admin — Sun, 18 Jan 2009 09:51:41 GMT

Thread: WARNING: Subscription for node down event still pending? Urgent!

"WARNING: Subscription for node down event still pending"

any help on this ...very urgent please
this is running on linux fedora and 10g .. never ever had this problem before.