Welcome to the Alteryx Knowledge Base

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

ORA-12557: TNS: protocol adapter not loadable

• Alteryx Designer
  • All versions
• Oracle
  • Database Version: 12c and 19c

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

• Oracle help documentation
• How to connect to Oracle