Problems with connection between Linked Service Oracle and on-prem database

Camilo Villalobos 25 Reputation points
2023-12-04T20:34:00.69+00:00

Hi all. I'm trying to create a linked service for Oracle connection to on premise database but when i check the connection with the button "Test Connection" in the linked service i get an error:User's image

All the parameters for linked service are okay:

  • I have a valid username and password for onpremise oracle, i tested the connection in a dbms.
  • Same for host, port and service name of oracle, i tested them and are ok.

We have a Self-hosted IR in a VM created and run. Inside of this vm, we have a successful connection to the on-premise oracle server tested through telnet. So, network issues are excluded.

There is some extra configuration that i have to do in the VM where IR is installed? The documentation say not, but I'm not sure if it refers to an Azure integration runtime, instead a Self-hosted.User's image

ref: https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory

Thanks for any help.

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