Hello all -
I am getting this stack trace while connecting via JDBC to an ORACLE 11G R2 instance:
Caused by: oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:249)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 21 more
It doesn't happen all the time -- it seems to happen at random.
In the listener alert file, I see many errors like this:
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 08-MAR-2010 13:29:19
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
opiodr aborting process unknown ospid (29865) as a result of ORA-609
2010-03-08 13:29:24.424000 -06:00
I have looked through documentation and I have run out of ideas. Does anybody know what could cause this, or at least what I should look into?
Thanks, Kevin