Oracle Database On Premises Gateway connection error

Question

Hi Everyone,&nbsp;In power bi service I've tried to connect Oracle database and SQL&nbsp;Server database I'm&nbsp;getting the below error&nbsp;Followed the Microsoft&nbsp;documents and installed gateway as well as&nbsp;32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4)&nbsp; into following the path I have installed this tool(C:\app)and in tnsname.ora file has&nbsp;included connection details still I'm not able to connect&nbsp;Please Help me resolve this As soon as possible... It's very emergency&nbsp;&nbsp;

anonymous · Answer

HI&nbsp;Charu,
&nbsp;
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
&nbsp;
Regards,
Xiaoxin Sheng
&nbsp;

charu · Answer

Hi&nbsp;Anonymous&nbsp;below is the detailed error message when I tried to connect oracle database.

anonymous · Answer

Hi&nbsp;Charu,
&nbsp;
I'd like to suggest you use udl to test oracle connection status on device who install gateway.
Basics first : "UDL Test"
&nbsp;
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
&nbsp;
Regards,
Xiaoxin Sheng

charu · Answer

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

anonymous · Answer

Hi&nbsp;Charu,
&nbsp;
Can you provide the local gateway log?&nbsp;
&nbsp;
In addition, have you check your port settings and firewall white list?
On-premises data gateway
&nbsp;
Spoiler (Highlight to read)
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.&nbsp;Learn more
It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download the&nbsp;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&nbsp;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.

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.&nbsp;Learn more
It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download the&nbsp;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&nbsp;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.

&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Oracle Database On Premises Gateway connection error

5 Replies

Related content

Database connectivity.

Unable to connect to On premise database

Notebook connect to Fabric SQL Database

Connection to On-Premise Oracle Database with Fabric Data Pipeline

Change Source Connection on Mirrored Database