Intermittent "login timeout occured while connecting to the database" or "IO Error: Socket read timed out" Messages Signaled when Running ODI 11g Processes
Last updated on JULY 17, 2017
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 to 188.8.131.52.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 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:
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