Showing results for 
Search instead for 
Did you mean: 

Devgurus Discussion

Journeyman III
Journeyman III

Alteryx & tableau - OCILogon2 Error: ORA-12514: TNS:listener does not currently know of service requ

I have two database servers Test and Prod. I installed all the oracle client tools required for establishing connections. I am able to connect to both of Test & PROD using basic connection type from SQL developer. Also I am able to connect to the Test environment using Tableau & Alteryx but when I try to connect to PROD it throws TNS listener error(both Alteryx and Tableau). I am using Oracle OCI to connect in Alteryx and basic connection type in tableau. I did not set up any TNS names from the beginning

Oracle server version: 12C SQL Developer: Tableau: 2019.3.4 Alteryx: 2018.4.5

0 Kudos