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.2IBM 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>
*
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>)))
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>';
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=));
(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 |