ORA-28511 Error When Sybase Database Using "DDL in Tran" Option, DG4ODBC
(Doc ID 2117278.1)
Last updated on OCTOBER 10, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Configured Oracle Database Gateway for ODBC (DG4ODBC) 126.96.36.199 to access Sybase database 15.7.0 using DriverName:Adaptive Server Enterprise (ANSI), DriverVer:16.0.01.03.
The dblink to one Sybase DB does not work while a dblink to another works just fine. The two Sybase instances are on the save server. They were installed from the same binary, with the same configuration. The only difference is the port.
select count(*) from "sysobjects"@TJPE1G_ODBC -- ERROR
select count(*) from "sysobjects"@TJPE2G_ODBC -- OK
The error getting when using TJPE1G_ODBC database link -
select count(*) from "sysobjects"@TJPE1G_ODBC
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=TJPE1G_ODBC)))
ORA-02063: preceding 2 lines from TJPE1G_ODBC
28511. 00000 - "lost RPC connection to heterogeneous remote agent using SID=%s"
*Cause: A fatal error occurred in one of the following places
-- the connection between the ORACLE server and the agent
-- the heterogeneous services remote agent itself
-- the connection to the non-Oracle system
This error occurred after communication had been established successfully.
*Action: Check for network problems and remote host crashes. The problem is
probably in the agent software. If so, contact a customer support
representative of the agent vendor.
Error line 1 Column: 22
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