Issue
When using an Oracle connection, which was created on a computer that uses LDAP, TNSNAMES, or EZCONNECT or where all three connection parameters (Server, Service, and Port) were configured during the initial connection, the connection will no longer work and the following error might occur:"Oracle database error 12154: ORA-12154: TNS:could not resolve the connect identifier specified"
When you try to connect to the same Oracle database using the service name from TNSNames.ora file in the Server parameter and leaving the other two parameters blank, the connection is successful.
This behavior can occur when:
- Sharing workbooks between computers running Tableau Desktop, one of which has the above configuration file(s), and the other does not.
- Publishing a live connection to Oracle from a computer running Tableau Desktop that uses one of the above configuration file(s) to an instance of Tableau Server which does not. (If the connection is published as an extract, it will work, but will not refresh.)