Environment Details
The following error occurs in the Input Data tool when running a workflow:
ORA-12557: TNS: protocol adapter not loadable
- Alteryx Designer
- Oracle
- Database Version: 12c and 19c
Cause
This is an error being passed by Oracle to Alteryx rather than an Alteryx error.
You will need to edit the environment variables for the Oracle path.
Resolution
This is an error being passed by Oracle to Alteryx rather than an Alteryx error. You will need to edit the environment variables for the Oracle path.
Try the following:
1 - put the Oracle DB Home in front of the other paths in the PATH environment variable.
OR
2 - Remove ORACLE_HOME From environment Variable and reboot PC
Additional Resources