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 FEBRUARY 08, 2019
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.99 [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:
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:
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