Wednesday, August 22, 2018

1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable').

Oracle Workflow Builder might throw the error

1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable'). 

CAUSE

ORACLE_HOME environment variable statically set in the Windows Users Environment settings.

SOLUTION

To implement the solution, please execute the following steps:

Unset/rename the ORACLE_HOME environment variable in the Windows Users Environment setting so the Oracle WorkFlow Builder sub-components can freely reference libraries or executables from the adjacent Oracle Home locations.