Loading

Tableau - Bad Connection: Tableau couldn't connect to Oracle Datasource. Error Code: 1CA83880

Julkaisupäivä: Oct 23, 2025
Kuvaus

Issue where Tableau could not connect to the Oracle data source from Tableau Desktop. The error message indicated a 'Bad Connection' with Error Code: 1CA83880, caused by an illegal character in the TNS_ADMIN path.

The error occurred due to a misconfigured TNS_ADMIN environment variable on the system. Specifically, two Oracle paths were concatenated without a proper separator, forming an invalid file path:

C:\oracle\product\11.2.0\client_1\network\AdminC:\Oracle\OraClient19Home1\Network\admin\ojdbc.properties

This caused Tableau’s Oracle JDBC driver to interpret the path as containing illegal characters, resulting in a failed connection attempt.

Ratkaisu

To resolve the issue, the TNS_ADMIN environment variable was corrected using the following steps:

  1. Open Environment Variables:

    • Press Win + R, type sysdm.cpl, and press Enter.

    • Go to the Advanced tab and click Environment Variables…

  2. Locate the TNS_ADMIN Variable:

    • Under User Variables or System Variables, find and select TNS_ADMIN.

  3. Edit the Variable:

    • Remove the concatenated or incorrect path.

    • Ensure the value is set to a single valid Oracle network admin path, for example:

       
      C:\oracle\product\11.2.0\client_1\network\Admin

  4. Save and Apply:

    • Click OK on all dialog boxes to save changes.

    • Restart Tableau Desktop and attempt the Oracle connection again.

After applying the correct path, Tableau  should successfully establish a connection to the Oracle data source.

Lisäresurssit
  • The TNS_ADMIN environment variable should point to the directory containing the tnsnames.ora file.

  • Avoid concatenating multiple Oracle paths in a single environment variable value unless explicitly supported and separated properly.

  • If multiple Oracle clients are installed, ensure Tableau is using the correct one and that PATH and TNS_ADMIN variables are configured accordingly.

  • Common files inside the TNS_ADMIN directory

    • tnsnames.ora - Defines network aliases (TNS names) for databases — e.g. how to translate PROD_DB (Oracle service) into host, port, and service name.
    • sqlnet.ora Configures network behavior, encryption, and authentication settings.

     

  • Always restart Tableau Desktop and Command Prompt windows after making changes to environment variables to ensure the updated values are loaded.
Knowledge-artikkelin numero

005167028

 
Ladataan
Salesforce Help | Article