« Oracle : ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA »

[Zalexatwork]

Hello All,

After changing my pc, I find that I cannot connect to my database, with the error shown in subject.
With my previous pc, the oracle connector generated the tns name just fine and the connexion worked.
I reinstalled the oracle connector, made sure the tns name was the same as it was on my older pc when everything worked, and yet I get the error above when trying to connect.
My IT department is baffled, as the exact same setup still works on my colleagues pc.
We have tried uninstalling and reinstaling different versions of the connector and of power BI, to no avail.
At this point we have no clue as to where to look next, and I am hoping this forum may shed a light on at least possible ideas that we could look into to make it work.
Any help would be greatly appreciated.
Regards,

Alex

[v-xiaotang · Accepted solution]

Hi @Zalexatwork 

Not familiar to Oracle, but please try this, I hope it can help,

https://stackoverflow.com/questions/19129931/oracle-error-tns-listener-was-not-given-the-service-nam...

We are happy to help you, but we may not be very professional with Oracle and may waste your time, so you can also go to Oracle Community for more professional advice, https://community.oracle.com/hub/

Best Regards,

Community Support Team _Tang

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

[RickySmall]

This was finally the solution for me!

[amitchandak]

@Zalexatwork , Please add oracle path to env variable. Also, create an entery into tnsnames.ora file and then try