My Oracle Support Banner

ODI Randomly Signals "The application requester cannot establish the connection. <HOST>" Messages when IBM Toolbox JDBC Driver Is Used (Doc ID 750458.1)

Last updated on DECEMBER 15, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.

Symptoms

Following message is randomly signaled by Oracle Data Integrator (ODI) when IBM Toolbox JDBC Driver is used to address executions on DB2/400 technology and the ODI Agent is running on other than iSeries (AS/400) operating system:

The exception just displays the name of the machine, <HOST>.

Following points have already been verified:

  1. The current machine successfully resolves <HOST> with the proper domain.
  2. The current machine is successfully pinging <HOST>.
  3. None of the following reasons behind the failure in establishing a connection have been observed:
    • Not able to pass connection to server
    • Connection refused: connect
    • Operation timed out: connect
    • No route to host: connect
    • A remote host refused an attempted connect operation
    • Timeout

Actually, the ODI Agent is running on Windows and the IBM Toolbox JDBC Driver, deployed in ODI "/drivers" folder, comes from a file called "jt400native.jar".

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!

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