ORA-28511 Error When Sybase Database Using "DDL in Tran" Option, DG4ODBC
Last updated on OCTOBER 04, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Configured Oracle Database Gateway for ODBC (DG4ODBC) 18.104.22.168 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
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