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

Last updated on JUNE 22, 2016

Applies to:

Operating System Dependent Interface - Version 10.1.0.2 and later
IBM z/OS on System z
IBM z/OS (OS/390)
***Checked for relevance on 30-Dec-2014***


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

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