Oracle Database On Premises Gateway connection error

[Charu]

Hi Everyone,

In power bi service I've tried to connect Oracle database and SQL Server database I'm getting the below error 

Followed the Microsoft documents and installed gateway as well as 

• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2....  into following the path I have installed this tool(C:\app)

and in tnsname.ora file has included connection details still I'm not able to connect

Please Help me resolve this As soon as possible... It's very emergency

[v-shex-msft]

HI @Charu,

You share us a common error message which is hard to troubleshooting. Please share us more detailed information about your scenario.

How to Get Your Question Answered Quickly

Troubleshooting the on-premises data gateway

Regards,

Xiaoxin Sheng

[Charu]

Hi @v-shex-msft

below is the detailed error message when I tried to connect oracle database.

[v-shex-msft]

Hi @Charu,

I'd like to suggest you use udl to test oracle connection status on device who install gateway.

Basics first : "UDL Test"

If you can't access to oracle datesource from that device, the issue may related to remote connection settings.

Configuring proxy settings for the on-premises data gateway

Regards,

Xiaoxin Sheng

[Charu]

Hi @v-shex-msft

Followed the instructions given by you, In UDL test I gave oracle credentials and the Connection status is a success but unable to do the same in power bi service... Wonder

[v-shex-msft]

Hi @Charu,

Can you provide the local gateway log? 

In addition, have you check your port settings and firewall white list?

On-premises data gateway

Spoiler

Ports

The gateway creates an outbound connection to Azure Service Bus. It communicates on outbound ports: TCP 443 (default), 5671, 5672, 9350 thru 9354. The gateway does not require inbound ports. Learn more

It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download the Microsoft Azure Datacenter IP list. This list is updated weekly. The gateway will communicate with Azure Service Bus using the IP address along with the fully qualified domain name (FQDN). If you are forcing the gateway to communicate using HTTPS it will strictly use FQDN only, and no communication will happen using IP addresses.

Note

The IP Addresses listed in the Azure Datacenter IP list are in CIDR notation. For example, 10.0.0.0/24 does not mean 10.0.0.0 thru 10.0.0.24. Learn more about the CIDR notation.

Here is a listing of the fully qualified domain names used by the gateway.

Domain names	Outbound ports	Description
*.download.microsoft.com	80	HTTP used to download the installer.
*.powerbi.com	443	HTTPS
*.analysis.windows.net	443	HTTPS
*.login.windows.net	443	HTTPS
*.servicebus.windows.net	5671-5672	Advanced Message Queuing Protocol (AMQP)
*.servicebus.windows.net	443, 9350-9354	Listeners on Service Bus Relay over TCP (requires 443 for Access Control token acquisition)
*.frontend.clouddatahub.net	443	HTTPS
*.core.windows.net	443	HTTPS
login.microsoftonline.com	443	HTTPS
*.msftncsi.com	443	Used to test internet connectivity if the gateway is unreachable by the Power BI service.
*.microsoftonline-p.com	443	Used for authentication depending on configuration.

Regards,

Xiaoxin Sheng