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 AUGUST 24, 2017

Applies to:

Oracle Workflow - Version 2.6.1 and later
Oracle Net Services - Version 9.2.0.1.0 to 9.2.0.6.0 [Release 9.2]
Generic Windows
Oracle Workflow Cartridge - Version: 2.6.1.5.2Microsoft Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003

Symptoms

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



Cause

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