cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LohithaSannathi
Helper III
Helper III

Cannot open ports which are listed in Gateway Test Results, Is Gateway only option to connect to Oracle database

Hi 

 

I have ran Network Port Test  and found list of servers, port and IP Address to create gateway. but i am unable to open ports listed by Network post test due to security issues. So i wanted to know , Is the gateway only option to connect to Oracle Database. (We are running on  Oracle Applications R12). Please suggest me the right Direction.

 

Thanks

Lohitha

5 REPLIES 5
Pstork1
Dual Super User III
Dual Super User III

if your Oracle server is ON-Premises then yes, the only way to access it from Power Apps is an On-Premises gateway.  Please Note: The non-HTTP(s) ports are all outbound only. This is usually less of a security concern for most networking groups.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
v-xida-msft
Community Support
Community Support

Hi @LohithaSannathi ,

Do you use On-premises Oracle Database on your side?

Do you create a connection to your On-premises Oracle Database from your canvas app?

 

If you created a connection to your On-premises Oracle Database from your canvas app, the answer to your question is YES. Currently, within PowerApps, if you want to access On-premises connector, you must install a On-premises Data Gateway on your PC, then create a connection to the On-premises connector through On-premises Data Gateway.

 

More details about On-premises Data Gateway in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth

 

Create a connection to Oracle Database from PowerApps app

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

YEs -Oracle server is ON-Premises ,Though i enable HTTPS mode in gateway, Still im not able to Connect. 

 

Getting Below Errors

 

Gateway service cannot access outside network. Check your connectivity settings.

Gateway service connectivity check failed. Common issues can be found at https://go.microsoft.com/fwlink/?linkid=838272.

Below is the stack trace:
System.Net.Sockets.SocketException (0x80004005): The requested name is valid, but no data of the requested type was found
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.HealthCheck.NetworkCheck.CheckDNSQuery()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.HealthCheck.NetworkCheck.<>c.<Run>b__5_0()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.HealthCheck.HealthCheckAction.Run(Func`1 checkMethod)

 

 

-- Error 2 

Network Connectivity is Limited.

Ensure network access is functioning correctly. Firewall and proxy configurations may need to be changed.

 

 

Thanks

Lohitha

Hi @v-xida-msft , @Pstork1 

 

 

yes we have Oracle server is ON-Premises ,Though i enable HTTPS mode in gateway, Still im not able to Connect. 

I have installed On-Premises gateway on my PC and when trying to congifure getting below errors.

 

Getting Below Errors

 

Gateway service cannot access outside network. Check your connectivity settings.

Gateway service connectivity check failed. Common issues can be found at https://go.microsoft.com/fwlink/?linkid=838272.

Below is the stack trace:
System.Net.Sockets.SocketException (0x80004005): The requested name is valid, but no data of the requested type was found
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.HealthCheck.NetworkCheck.CheckDNSQuery()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.HealthCheck.NetworkCheck.<>c.<Run>b__5_0()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.HealthCheck.HealthCheckAction.Run(Func`1 checkMethod)

 

 

-- Error 2 

Network Connectivity is Limited.

Ensure network access is functioning correctly. Firewall and proxy configurations may need to be changed.

 

 

Thanks

Lohitha

 

 

Did you open the ports mentioned in the original post thorugh your Windows Firewall for outbound?  Does the connectivity test you originally ran finish without errors?  If not then you still have to fix those outbound ports or the gateway won't work.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (86,700)