Error: "Oracle database error 12504..." When Connecting to Oracle Database
Published: 25 Jul 2016 Last Modified Date: 20 Jul 2023
Issue
When attempting to connect to an Oracle database, the following error message occurs:
"Oracle database error 12504: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
Environment
Tableau Desktop
Oracle
Resolution
Specify the service and port number in the Oracle connection menu. If these values are unknown, contact your Oracle Database Administrator for this additional information.
Cause
The "Service" and "Port" values are not being specified in the Oracle connection dialogue menu. As a result, Tableau Desktop is unable to access the database because of a lack of information.
Additional Information
Thank you for providing your feedback on the effectiveness of the article.