Greetings,
My oracle RDBMS is 11.2.0.3.0 with the January 2014 PSU applied. It is the repository for my OEM Cloud Control 12.1.0.3.0. Intermittently in the alert log I see the following -
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
Tue Feb 04 07:50:02 2014
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 04-FEB-2014 07:50:02
Tracing not turned on.
Tns error struct:
ns main err code: 12537
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 04-FEB-2014 07:50:02
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (22266) as a result of ORA-609
opiodr aborting process unknown ospid (22268) as a result of ORA-609
This morning I found this in the listener.log file -
04-FEB-2014 07:50:02 * (CONNECT_DATA=(CID=(PROGRAM=OMS)(HOST=__jdbc__)(USER=oracle))(SID=oemrepos)) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.120.32.168)(PORT=27810)) * establish * oemrepos * 0
Tue Feb 04 07:50:29 2014
04-FEB-2014 07:50:29 * ping * 0
WARNING: Subscription for node down event still pending
I am not sure which is the cause and which is the effect here. I have also found suggestions to add the statement
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
to the listener.ora file and restart the listener. Given that I am not certain of the causal relation I am a bit hesitant to make this change right away.
If anyone has suggestions or can offer ideas as to other things to investigate I would greatly appreciate it.
Thank you.
Bill Wagman