Forum Discussion

adaardor's avatar
adaardor
Copper Contributor
May 13, 2025
Solved

Oracle 2.0 Upgrade Woes with Self-Hosted Integration Runtime

  This past weekend my ADF instance finally got the prompt to upgrade linked services that use the Oracle 1.0 connector, so I thought, "no problem!" and got to work upgrading my self-hosted inte...
azure data factory
Copy Activity
Oracle
  • adaardor's avatar
    adaardor
    May 19, 2025

    In my case the root cause ended up being that the source Oracle server was version 11g which is not supported in the new connector.

     

    Instead, I am connecting to the Oracle data using ODBC connector going forward. Hope this helps someone else!

Vishal_01's avatar
Vishal_01
Copper Contributor
May 16, 2025

Yes, even facing the same issue after upgrading oracle linked service to version 2.0.  We are also using latest oracle version here. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0.

Error –

Test connection operation failed.

Failed to open the Oracle database connection.

ORA-50201: Oracle Communication: Failed to connect to server or failed to parse connect string

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Ferror-help%2Fdb%2Fora-12504%2F&data=05%7C02%7CVishal_Sushil.pawar%40bp.com%7Ca14d9900d9be47f2f94a08dd9414a6c5%7Cea80952ea47642d4aaf45457852b0f7e%7C0%7C0%7C638829538606894436%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=5C2kcjNyKeZgZjAnMcUZw8RAVCEDXHfbrtpZ52nCAno%3D&reserved=0

 

Do we need to provide service name/SID in another way?

Resources