Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |