On Prem ODI 12.2.1.3.0 Connectivity with ADW

SaurabhJaiswal-Oracle

Hello Experts,

We are using on premise ODI(ODI_12.2.1.3.0ODIBP_GENERIC_190411.0724) to establish the connectivity with ADW.

We are facing below issue while connecting the ADW from ODI topology -

Error:IO error: The Network Adaptor could not established the connection.(Telnet works from source server to ADW)

Has anyone came across this issue and solved it?

SiddharthDang-Oracle

Dear Saurabh,

Please check the OJDBC jar file being used by your ODI. ADW requires at least OJDBC8.jar for proper connectivity.

Regards,

Siddharth Dang

SaurabhJaiswal-Oracle

Our ODI is using ojdbc7m.jar file.

Thanks,

Saurabh Jaiswal

SiddharthDang-Oracle

Changing OJDBC files is not recommended. We need to use the original jar as part of the binaries. Apply buddle patch to upgrade to new OJDBC Jar file.

Regards,

Siddharth Dang