ORA-28545: Mixing TNSNAMES syntax with SQLPLUS syntax (Doc ID 794915.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Database Gateway for DB2 - Version 9.2 to 10.2
IBM z/OS on System z
Oracle Transparent Gateway for DB2 - Version: 9.2 to 10.2
IBM z/OS (OS/390)

***Checked for relevance on 30-Dec-2014***


Symptoms

ORA-28545 occurs when accessing the Transparent Gateway for DB2 (TG4DB2) via a database link:

   

SQL> select * from sysibm.systables@XYZ_LINK
                                   *
    ERROR at line 1:
    ORA-28545: error diagnosed by Net8 when connecting to an agent
    Unable to retrieve text of NETWORK/NCR message 65535
    ORA-02063: preceding 2 lines from XYZ_LINK
SQL>


Errors of the following form are also written to the Oracle Server Alert log:

HS: Unable to establish RPC connection to HS Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(CONNECT_DATA=(SID=SRV1)))



The database link definition for XYZ_LINK is as follows:


CREATE PUBLIC DATABASE LINK XYZ_LINK
CONNECT TO <userid> IDENTIFIED BY <password>
USING 'SRV1';



...and the TNSNAMES alias for SRV1 is defined as:


SRV1= (DESCRIPTION=
(ADDRESS=
(PROTO = TCP)
(HOST = ###.###.###.##)
(PORT = 5039))
(CONNECT_DATA=(SID=SRV1))
(HS=));


Note the extraneous semi-colon ';' following the trailing close parenthesis.


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