My Oracle Support Banner

ODI Receives Timeout Messages on Linux x86 with Java 1.5 Onwards (Doc ID 1277360.1)

Last updated on MAY 17, 2021

Applies to:

Oracle Data Integrator - Version and later
Linux x86


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:@<HOST>:1521:<SID> and user <USER>.
at com.sunopsis.sql.SnpsConnection.a(
at com.sunopsis.sql.SnpsConnection.connect(
at com.sunopsis.dwg.cmd.e.j(
at com.sunopsis.dwg.cmd.e.i(
at com.sunopsis.dwg.cmd.e.A(
at com.sunopsis.dwg.DwgJv.treatCmd(
at com.sunopsis.dwg.DwgJv.main(
at oracle.odi.Agent.main(
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(
at oracle.jdbc.driver.PhysicalConnection.(
at oracle.jdbc.driver.T4CConnection.(
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverE


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.