Intermittent "login timeout occured while connecting to the database" or "IO Error: Socket read timed out" Messages Signaled when Running ODI 11g Processes (Doc ID 2263587.1)

Last updated on MARCH 11, 2024

Applies to:

Symptoms

The following intermittent error messages are signaled by Oracle Data Integrator (ODI) 11g relative to a Data Server MYDB when executing a Session:

oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occurred while connecting to the database

   or

java.sql.SQLException: IO Error: Socket read timed out

+ java.sql.SQLRecoverableException: IO Error: Socket read timed out

+ oracle.net.ns.NetException: Socket read timed out

The ODI processes fails with the two alternative error messages due to the JDBC driver not being able to successfully connect to the Oracle database on connection MYDB...

... or losing a previously established connection to the same Data Server.

Note the MYDB database alert file reports ORA-609, and "TNS-12637: Packet receive failed" errors, which are relevant to the ODI execution failures:

***********************************************************************

Fatal NI connect error 12637, connecting to:
(LOCAL=NO)   VERSION INFORMATION:

    TNS for Solaris: Version 12.1.0.1.0 - Production
    Oracle Bequeath NT Protocol Adapter for Solaris: Version 12.1.0.1.0 - Production
    TCP/IP NT Protocol Adapter for Solaris: Version 12.1.0.1.0 - Production
  Time: 02-MAY-2017 11:53:41
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12637

  TNS-12637: Packet receive failed
    ns secondary err code: 12532
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
    Tue May 02 11:53:41 2017
  opiodr aborting process unknown ospid (29418) as a result of ORA-609

Changes

Cause