Connect to Oracle Database Error(ORA-12154: TNS:could not resolve the connect identifier specified)

[Anonymous]

Hi,

I want to connect to Oracle Database, but there's still an error message after the Oracle DataAccess Client is installed, saying: Details: "Oracle:ORA-12154: TNS: could not resolve the connect identifier specified".

Is there any guide that can help me

[theov]

Hello, 

I'd make sure the ora client is installed properly, the string is correct and finally tnsnames.ora is up to date. This video might helps as well:

https://www.youtube.com/watch?v=EpeJrO5tHDc

[Icey]

Hi @Anonymous ,

Please check:

1. Whether the Oracle client either is installed or configured properly.

2. If it's installed, verify that the tnsnames.ora file is properly configured and you're using the proper net_service_name.

3. Make sure that the net_service_name is the same between the machine that uses Power BI Desktop and the machine that runs the gateway.

4. Whether it is a compatibility issue between the Oracle server version and the Oracle client version.

For more details, please refer to this document:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle#troubleshooting.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

---

[amitchandak]

This typically when either the listener is not on or connection details are not correct.

You can test that by connecting using same details with some other tool like oracle sql developer.