RDW Batches Fail With Database Connection Error: "IO Error: Connection Reset" (Doc ID 1415233.1)

Last updated on JUNE 16, 2016

Applies to:

Oracle Retail Data Warehouse - Version 13.1.3 and later
Information in this document applies to any platform.

Symptoms

With RDW 13.1/RETL 13.1 and DB 11.2.0.2, the batches fail with the below error when they are scheduled in parallel:


 

Starting the threads
FATAL - retl 13.1.3 build 1758 (20.2-b06 :: Sun Microsystems Inc. :: i386 :: Linux :: 2.6.18-194.el5)

FATAL - E135: Exception in operator [oraread:3]
E415: Unable to obtain connection to database. (connectionstring="jdbc:oracle:thin:@10.24.26.22:1521:RDWPRD",userid="rdwprd")
--- SQLException caught ---
java.sql.SQLRecoverableException: IO Error: Connection resetMessage: IO Error: Connection resetXOPEN SQL State: 08006
Database Vendor Driver/Source Error Code: 17002

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