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 MAY 22, 2018
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 to 184.108.40.206.99 [Release 11gR1]
Information in this document applies to any platform.
The following intermittent error messages are signalled by Oracle Data Integrator (ODI) 11g relative to a Data Server MYDB when executing a Session:
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 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 elevant to the ODI execution failures:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!