Oracle database error 12514: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Question

 Now I am using Tableau business intelligence tool for data visualization, I tried to connect Oracle database with tableau, at that time I got below Error

Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Oracle database error 12514: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Unable to connect to the Oracle server "192.176.10.145". Check that the server is running and that you have access privileges to the requested database.

what mistake I did kindly help me out, give any suggestion to resolve this

Answer 1

• When SERVICE value is incorrect, Here is an article from tableau which suggests that the ORA-12514 error occurs

• In order to resolve this issue, find out what the correct SERVICE value is, open the TNSNames.ora file located in your %ORACLE_HOME%\network\admin\ folder. Refer to the steps under ORA_12154 if necessary.