Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

On Prem ODI 12.2.1.3.0 Connectivity with ADW

Received Response
44
Views
3
Comments
SaurabhJaiswal-Oracle
SaurabhJaiswal-Oracle Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

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?

Tagged:

Answers

  • SiddharthDang-Oracle
    SiddharthDang-Oracle Rank 5 - Community Champion

    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
    SaurabhJaiswal-Oracle Rank 5 - Community Champion

    Our ODI is using ojdbc7m.jar file.

    Thanks,

    Saurabh Jaiswal

  • SiddharthDang-Oracle
    SiddharthDang-Oracle Rank 5 - Community Champion

    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