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 JULY 17, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

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

oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured 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 fail 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 loosing 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 elevant 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms