KNOWLEDGE BASE

Error: "Oracle database error 12504..." When Connecting to Oracle Database


Published: 25 Jul 2016
Last Modified Date: 02 Feb 2017

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 9.2.6
  • 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.
Did this article resolve the issue?