ORA-28545: Mixing TNSNAMES syntax with SQLPLUS syntax
Last updated on APRIL 13, 2018
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=SRV1)))
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';
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=));
(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