Logic APP not connecting with my On-Premises Oracle Database

Question

Hello Microsoft Support Team,

I am trying to connect the Logic APP with my On-Premises Oracle Database, But I am getting the below error.

Please check your account info and/or permissions and try again. Details: The provider being used is deprecated: 'OCIEnvCreate failed with return code -1 but error message text was not available.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider. inner exception: The provider being used is deprecated: 'OCIEnvCreate failed with return code -1 but error message text was not available.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider. clientRequestId: 512034e6-f77b-42ac-8323-9e4c776305f6 More diagnostic information: x-ms-client-request-id is 'A116BB37-9FD4-4AAC-A5A8-FE8BEB1159FC'.

Let me explain what I did,

1. I had installed GatewayInstall.exe on one of my servers and logged in with my Azure account, which I am using to create Logic App
2. I had installed the 64 bit Oracle client
3. I had created the Gateway instance in Portal Azure under the On-premises Data Gateways list
4. Now I am trying to connect the Oracle database from Logic App

Oracle server version - 18c Enterprise
Oracle client version - 12.2

Did I miss anything? Or do I have to install/Configure anything to access On-Premises Oracle Database?

How can I ping the database server from Portal Azure to check whether it is accessing or Not?

Answer 1

Hello @Ram , Welcome to Microsoft QnA. Thank you for the question.

Can you connect to Oracle database using SQLPlus? Also please confirm whether the upgrade or installs to 12.2 was properly done.
For reference, https://docs.oracle.com/en-us/iaas/Content/Network/Concepts/azure.htm ( I believe you are already aware of this)

This could be a configuration issue, hence I would recommend you to open a support ticket with Microsoft Support if you have a subscription which allows you to do so. Otherwise , you can send an email with subject line “Attn:Jaya” to AzCommunity[at]Microsoft[dot]com referencing this thread along with the subscription id.