Workflow Builder Fails: 1700: Could not connect with username/password 'apps/pwd@VIS' ('ORA-12557: TNS:protocol adapter not loadable')
(Doc ID 453241.1)
Last updated on JANUARY 22, 2020
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document