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.
