Forum Discussion
Oracle Problems Power BI Desktop
Hi dniedrauer,
Perhaps you can take a look at below article:
Troubleshooting
You may encounter serveral errors from Oracle when the naming syntax is either incorrect or not configured properly.
- ORA-12154: TNS: could not resolve the connect identifier specified
- ORA-12514: TNS listener does not currently know of service requested in connect descriptor
- ORA-12541: TNS: no listener
- ORA-12170: TNS:Connect timeout occurred
- ORA-12504: TNS listener was not given the SERVICE_NAME in CONNECT_DATA
These errors could occur if either the Oracle client is not installed, or if it is not configured properly. If it is installed, you will want to verify the tnsnames.ora file is properly configured and you are using the proper net_service_name. You will also need to make sure that the net_service_name is the same between the machine using Power BI Desktop and the machine that is running the gateway. For more information, see Installing the Oracle Client.
Regards,
Xiaoxin Sheng
- I'm actually trying to connect via Phone Bi desktop. Is a gateway even relevant here?
Would also be nice to know: (1) what's a net service name? (2) what does it look like and (3) what other things is it usually called ?Hi dniedrauer,
On my side, I can direct use service name connect to oracle database. Have you test to use command line to connect to your oracle server?
Establishing a Connection and Testing the Network
In addition, you can also check your oracle service to confirm it has turned on.
Regards,
Xiaoxin Sheng
