Receiving errors for large batch jobs in a production 220.127.116.11 database.
ORA-12541: TNS:no listener
The listener log contained the following event at the same time- ‘Warning: Subscription For Node Down Event Still Pending’ . I have seen this event before and it hasn’t caused any issues but apparently there are reports of hanging issues in databases >10g.
See the following MOS document :’Warning: Subscription For Node Down Event Still Pending’ In Listener Log [ID 372959.1]
“These messages are related to the Oracle TNS Listener’s default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription. This feature was introduced in Oracle 10g. ”
This recommendation was news to me, so this is why I put in a blog post because someone else will come across the same problem…the fix is to add to the listener.ora
and then reload or restart the listener. Using the Reload command in lsnrctl will be less disruptive than restarting.