Intermittent 'The Network Adapter could not establish the connection' Messages And TNS-12502 Errors Signaled During The Runtime Of ODI Processes

(Doc ID 1323777.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

Oracle Data Integrator (ODI) execution intermittently receives the following message in Integration Interface/ODI 12c Mapping tasks :

17002 : null : java.sql.SQLException: IO exception: The Network Adapter could not establish the connection

Moreover, the following may be observed on the Oracle listener logfile:

....
25-MAR-2011 06:59:45 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
    
26-MAR-2011 22:40:02 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
....

Each of them appearing to be directly related to the IO exception messages.

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