Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
- Oracle
Answer
Change the SERVICE_NAME in the TNSNames.ora file to SID. For example,Production = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prod.corp.com)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME= orcl) ) ) should be changed to: Production = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prod.corp.com)(PORT = 1521) ) (CONNECT_DATA = (SID= orcl) ) )
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