My Oracle Support Banner

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 to [Release 9.2]
Generic Windows
Oracle Workflow Cartridge - Version: Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003


-- Problem Statement:
Oracle Client Workflow Builder version 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 :

Result :
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.