My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2020

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=<SID>)))



The database link definition for XYZ_LINK is as follows:


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



...and the TNSNAMES alias for <SID> is defined as:


<SID>= (DESCRIPTION=
(ADDRESS=
(PROTO = TCP)
(HOST = ###.###.###.##)
(PORT = <PORT>))
(CONNECT_DATA=(SID=<SID>))
(HS=));


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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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