KNOWLEDGE BASE

Error: "ORA-12154: TNS: could not resolve the connect identifier specified" When Publishing Workbook


Published: 27 Aug 2015
Last Modified Date: 14 Nov 2016

Issue

When publishing a workbook with a connection to Oracle 11g database, the following error might occur:
ORA-12154: TNS: could not resolve the connect identifier specified

Environment

  • Tableau Server
  • Oracle 11g

Resolution

Ensure there are no syntax errors or leading spaces in the tnsnames.ora file on the computer running Tableau Server. 

Cause

tnsnames.ora file on Tableau Server had some leading spaces in front of the server name.
Did this article resolve the issue?