GET ORA-12545 WHEN CONNECTING TO REMOTE INSTANCE USING ORACLE_SID (Doc ID 791380.1)

Symptoms

When a Pro*COBOL application, not an AM4CICS application, attempts to connect
to a remote Oracle Database server using :

    EXEC SQL
        CONNECT :USERNAME IDENTIFIED BY :PASSWD
    END-EXEC.

and WITHOUT using a "Named Database Connection", ie.,
"CONNECT :USERNAME IDENTIFIED BY :PASSWD AT :LOCATION",
per "Named Database Connections" on pg 3-4 of "10.2 Pro*COBOL Programmer's Guide",
and z/OS environment variable "ORACLE_SID" is specified in the ORA$ENV DD statement
for the Pro*COBOL job; Executing the Pro*COBOL job displays error message :

  SQL-ERROR SQL CODE = 00001254N

An SQLNET trace shows:

     [19-FEB-2009 13:26:28:478] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
     [19-FEB-2009 13:26:28:478] New trace stream is //SYSOUT:*
     [19-FEB-2009 13:26:28:478] New trace level is 16
     [19-FEB-2009 13:26:28:478] --- TRACE CONFIGURATION INFORMATION ENDS ---
     ...
     [19-FEB-2009 13:26:28:644] nioqper:  error from nscall
     [19-FEB-2009 13:26:28:644] nioqper:    ns main err code: 12545
     [19-FEB-2009 13:26:28:644] nioqper:    ns (2)  err code: 12560
     [19-FEB-2009 13:26:28:644] nioqper:    nt main err code: 515
     [19-FEB-2009 13:26:28:644] nioqper:    nt (2)  err code: 0
     [19-FEB-2009 13:26:28:644] nioqper:    nt OS   err code: 0
     [19-FEB-2009 13:26:28:644] niomapnserror: entry
     [19-FEB-2009 13:26:28:644] niqme: entry
     [19-FEB-2009 13:26:28:644] niqme: reporting NS-12545 error as ORA-12545

ORA-12545 Connect failed because target host or object does not exist

The TNSNAMES specified "PROTOCOL=TCP", for the remote database HOST/PORT/SID instance.

Cause

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