Listener errors in logs TNS-001184 TNS-12502
NiltonDec 8 2010 — edited Dec 8 2010Oracle Enterprise Edition 10.2.0.3
HP-UX
2 Node RAC
Hi
I have seen repetitive errors in listener log file of one of our databases.
The errors are like this,
07-DEC-2010 12:35:27 * service_register * EXS1 * 1184
TNS-01184: Listener rejected registration or update of service handler "DEDICATED"
TNS-01185: Registration attempted from a remote node
08-DEC-2010 12:35:27 * service_died * EXS1 * 12537
08-DEC-2010 12:35:27 * service_update * EXS1 * 0
There are also errors like the following,
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
TNS-12502: TNS:listener received no CONNECT_DATA from client
I referred this oracle metalink note, ID 275058.1 and it says this is because LOCAL_LISTENER and REMOTE_LISTENER are not configured properly, But I see errors like this being frequent (every minute) yesterday and only once today.
Our Application team complains about problems in performance of various procedures at various time intervals. Can this be the cause of such performance degradation ?