Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Error: "ORA-12557: TNS: protocol adapter not loadable" when trying to connect to an Oracle database

Environment Details

The following error occurs in the Input Data tool when running a workflow:

ORA-12557: TNS: protocol adapter not loadable

idea Skyscrapers

Alteryx Designer
- All versions
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