Unable to connect ADF to Oracle 19c DB

Venkata Ravikumar Chebrolu 0 Reputation points

Hi ,

We are trying to create oracle 19c Database connection as a source in Azure Data Factory and getting below popup error message.

ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination

Activity ID: 3cefa339-9457-48e2-89db-fac0eb3fd8fa.

Note: We were able to connect and work Oracle 12c db. But issue with 19c db only.

Thank You,


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,985 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 4,071 Reputation points

    When attempting to connect Azure Data Factory (ADF) to Oracle 19c and encountering an ORA-12203 error, you should check several key areas:

    Start by confirming the compatibility of the ADF Oracle connector with Oracle 19c. Ensure Oracle 19c is network-accessible from ADF, which might require IP whitelisting in Oracle's firewall.

    Then examine the Oracle listener configuration and the TNSNAMES.ORA file for accuracy. Verify that you're using an ODBC driver compatible with Oracle 19c and review the connection string details.

    Finally, inspect configurations in both Oracle 19c (especially if there are deprecated features from 12c) and ADF's linked service, and consider consulting Azure Support if the issue persists.

  2. Venkata Ravikumar Chebrolu 0 Reputation points

    Thank you for your reply!!

    I have whitelisted Oracle server IP in IR network and upgraded IR to latest version. But still facing the same issue.

    Thank You,


    0 comments No comments