cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Oracle Database connection Issue

Hi all,

 

I'm having trouble connecting to my Oracle database. I'm following the instructions as in https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-manage-oracle/.

 

I have installed a Gateway on my server machine (with Oracle database) and have Oracle client's installed on both my laptop and the server machine where I updated the tnsnames.ora files. The error I get back when trying to add a data source:

 

Activiteits-id:b1582ad1-d64a-3a16-2ae2-bb4c56944ad7
Aanvraag-id:94eda210-f250-b497-6fa8-8611e4cbbaf0
URI cluster:https://wabi-north-europe-redirect.analysis.windows.net
Statuscode:400
Foutcode:DM_GWPipeline_Gateway_MashupDataAccessError
Tijd:Wed Jul 05 2017 14:52:39 GMT+0200 (W. Europe Daylight Time)
Versie:13.0.1781.272
Onderliggende foutcode:-2147467259
Onderliggend foutbericht:Oracle: ORA-12541: TNS:no listener
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath:92.111.224.XXX
Microsoft.Data.Mashup.ValueError.ErrorCode:-2147467259
Microsoft.Data.Mashup.ValueError.Message:ORA-12541: TNS:no listener
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error

 

The entry in tnsnames.ora looks like:

 

ebs =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 92.111.224.XXX)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ebsdb)
)
)

 

The information for adding a data source to my gateway in app.powerbi.com:

 

Name: ebs

Type: Oracle

Server: 92.111.224.XXX

Verification: Basic

User: xxx

Password: xxx

 

It seems that there is no file called listener.ora in my Oracle client directory (D:\app\client\xxx\product\12.2.0\client_1\Network\Admin). Is that causing the error?

 

Yesterday, I got a different error doing the same thing, which was a Oracle ORA-12170 TNS connect timeout. No idea why I'm getting a different error today.

 

Help is very much appreciated!

 

 

Kind regards.

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Oracle Database connection Issue

Hi @moravan,

 

As stated here, regarding the error "ORA-12541: TNS: no listener" and "ORA-12170: TNS:Connect timeout occurred", the issue is occurred if either the Oracle client is not installed, or if it is not configured properly. As data gateway is 64 bit, please make sure both Oracle server and Oracle client are 64 bit.

 

As the issue is more related to Oracle client configuration, please contact your Oracle admin or post a thread in Oracle forum to get dedicated support.

 

Best Regards,

Qiuyun Yu

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

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors