0

I am trying to connect to oracle datasource from ADF using linked services which resides on an AZURE VM with private IP address and the configuration of the VM is not windows it is LINUX and this is the reason I am not able to setup SHIR in the VM to connect to my ADF.

Is there any other way to connect to the oracle database which resides on the LINUX AZURE VM?

Please provide your suggestions.

when I tried to connect to AZURE VM oracle data source I am getting error [08001] [microsoft ODBC oracle wire protocol driver] Connection refused verify host name and port number.

Improve this question
2
  • Can you set another VM with Windows, and install Self hosted integration runtime there? That would be the best approach. Commented Jul 11, 2023 at 8:42
  • you should check that the Oracle database on the Linux Azure VM is listening on the specified port number Commented Jul 11, 2023 at 8:52

1 Answer 1

Reset to default
0

Connect ADF to Oracle DB hosted on Azure linux VM without SHIR

Due to the fact that the ADF Oracle connector uses SHIR to make a connection with oracle database on VM or on-premises, I don't believe it is feasible to connect to Oracle operating on a Linux virtual machine. As the only platform on which SHIR is presently available is Windows (see here for system requirements).

As per prerequisites mentioned in MS Document :

If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.