Last Modified Date: 24 Aug 2022
Environment
- Tableau Server
- Oracle
Resolution
Use one of the following workarounds to modify the Oracle connection:1. Open the workbook in Tableau Desktop, edit the connection details, and re-publish.
2. Use a TNSNAMES.ORA file and enter the TNS name as the 'Server Name' with no Service name or port when connecting. Refer to Setting an Oracle Connection to Use TNSNames.ora or LDAP.ora for configuring the Tableau Server machine to utilize a TNSNAMES.ORA file.
In this scenario, simply changing the 'Server Name' in the Edit Connection Dialog from one TNS name to another should be successful, as long as both of the TNS names are configured in TNSNAMES.ORA.
Cause
This is related to known issue in Tableau Server that occurs when the Oracle connection is using service name and port rather than a TNSNAME. Tableau Server does not display a field for the service name in the Edit Data Connection dialog.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials