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 SEPTEMBER 02, 2016

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
*** Checked for ODI 11g compliance on 01-Jun-2012 ***
*** Checked for ODI 12c compliance on 04-Nov-2013 ***
*** Checked for relevance on 04-Nov-2013 ***

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