Forum Discussion
On premise Gateway and an Oracle Datasouce
We have solved it. We added the SERVICE_NAME parameter to the TNSNAMES.ORA file. In the Power BI Portal we also configured the server name as //<Host>/<Service_Name>. If we have a Host name of ORAPROD and a SERVICE_NAME of PRODDB then the Server name in the Power BI Console under Settings and then Manage Gateways, under your Gateway and Add Data Source would be //ORAPRDO/PRODDB. It worked fine then.
Thanks for the help.
This is the error I am getting.
Oracle: ORA-12154: TNS:could not resolve the connect identifier specified
Here is my TNSNAMES file with names changed.
PROD.WORLD=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)(HOST=ORAPROD)(PORT=1521)
)
(CONNECT_DATA=(SID=PROD1)
I am working with our Oracle DBA this afternoon to see if he can get the SERVICE_NAME variable working in TNSNAMES.ORA.
)
)
Here is what I would put into the field when I configure the datasource.
Data Source Name: Oracle Test
Data Source Type: Oracle
Server: PROD.WORLD
Authentication Method: Basic
Username: user1
Password: xxxxxxxx
Thanks for your reply. I am checking on the other items you mentioned.
We have solved it. We added the SERVICE_NAME parameter to the TNSNAMES.ORA file. In the Power BI Portal we also configured the server name as //<Host>/<Service_Name>. If we have a Host name of ORAPROD and a SERVICE_NAME of PRODDB then the Server name in the Power BI Console under Settings and then Manage Gateways, under your Gateway and Add Data Source would be //ORAPRDO/PRODDB. It worked fine then.
Thanks for the help.
Hi Mankney,
Glad to hear the issue is solved. You can accept helpful reply as answer, this way, other community members would easily find the solution when they have same issues.
Thanks,
Lydia ZhangNever has a solution been this good, very well explained and true to your words it fixed the issue! Thank you. The error wasnt to useful and could not have lead to a solution, but thanks to you it fixed the issues in less than 2 seconds.
Many Thanks
Lolu
Mankney Lolu Anonymous I had a similar issue and this post helped my configure the Gateway entry for the Oracle server. I was thrilled that it was so simple.
But now when I deploy a model that uses that service name to Power BI and try to configure SCHEDULED REFRESH, I get an error under the Gateway section stating that it is "not configured correctly". I also gives me an option to add the data source to the gateway with the following: Oracle{"server":"<service name>"} But when I click Add to gateway, the entry that it wants to add only includes the service name, not the full format you have as your solution, that of "//host/service_name"
On the one hand the full syntax works from the perspective of the GATEWAY, but from the perspective of the MODEL, it only wants the service name, which DOESN'T work (can't be added).
Curious to know if you ran into this, and what was the resolution.
Thanks in advance.
PS (an hour later): I solved this. The solution was in the Power BI model itself. When connecting to the Oracle database, use the format as expected by the Gateway, that of "//host/service". Note that this need NOT be edited in TNSNAMES.ORA file becasue the two components of it are each contained in the entry. So when you do a GET DATA on the desktop, specify //host/service instead of just the service.
Maybe that helps someone somewhere.
