Workflow Builder Fails: 1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable')
Last updated on AUGUST 24, 2017
Applies to:Oracle Workflow - Version 2.6.1 and later
Oracle Net Services - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 9.2]
Oracle Workflow Cartridge - Version: 22.214.171.124.2Microsoft Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003
-- Problem Statement:
Oracle Client Workflow Builder version 126.96.36.199 has been installed on a Windows based workstation. The proper Net Service Names entry has been added the entry for the instance (VIS) to the tnsnames file. However, you are unable to open definitions in the database (File->Open->database).
The following error message is received:
1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable').
However, TNSPING from the client or server it returns the correct information.
An ORA-12557 'TNS protocol adapter not loadable' error while trying to test the 'VIS' Oracle Net Service Name via the Oracle Net Configuration Assistant :
Trying to connect to the database VIS :
ORA-12557 TNS protocol adapter not loadable
Test did not succeed
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms