My Oracle Support Banner

Socket read timed out Whilst Executing Load Plan In ODI (Doc ID 2350396.1)

Last updated on JANUARY 03, 2024

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Symptoms


Timeout connection whilst executing Load Plan in ODI  with JDBC 11.2.0.4.

While executing a Load Plan, it fails always in same step with the following error message:

java.lang.Exception: The application script threw an exception: TableException: Custom Exception: Exception occured when trying to establish Target Connection

If the Load Plan is executed, the same will finish with no errors (sometimes it needs to be re-executed more than once).


WebLogic AdminServer.log shows:
java.sql.SQLRecoverableException: IO Error: Socket read timed out

while the database shows:
TNS-12537: TNS:connection closed
  ns secondary err code: 12560
  nt main err code: 0
  nt secondary err code: 0
  nt OS err code: 0
opiodr aborting process unknown ospid (3975) as a result of ORA-609



Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.