My Oracle Support Banner

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 DECEMBER 15, 2022

Applies to:

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


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


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

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

+ 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:

    TNS for Solaris: Version - Production
    Oracle Bequeath NT Protocol Adapter for Solaris: Version - Production
    TCP/IP NT Protocol Adapter for Solaris: Version - 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




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.