ODI Receives Timeout Messages On Linux x86 With Java 1.5 Onwards (Doc ID 1277360.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 10.1.3.6.0 and later
Linux x86

Symptoms

A timeout is received while executing an Oracle Data Integrator (ODI) Scenario on Linux x86 with Java 1.5 onwards:

com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL jdbc:oracle:thin:@XXXXXXXX:1521:DB1 and user ODI.
at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java)
at com.sunopsis.dwg.cmd.e.j(e.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.e.A(e.java)
at com.sunopsis.dwg.DwgJv.treatCmd(DwgJv.java)
at com.sunopsis.dwg.DwgJv.main(DwgJv.java)
at oracle.odi.Agent.main(Agent.java)
DwgJv.main: Exit. Return code:-1

Ultimately, the user receives a "java.sql.SQLRecoverableException: IO Error: Connection reset" message, as for example:

java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:421)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverE

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