mysql - Oracle 数据库错误 12514 : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Question

现在我正在使用Tableau商业智能工具进行数据可视化，我尝试将Oracle数据库与tableau连接，当时出现以下错误'

 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.

我做错了什么，请帮助我，提出解决这个问题的任何建议

Answer 1

Here is an article来自 tableau 表明当 SERVICE 值不正确时会发生 ORA-12514 错误。

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.