ORA-28511 Error When Sybase Database Using "DDL in Tran" Option, DG4ODBC (Doc ID 2117278.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Configured Oracle Database Gateway for ODBC (DG4ODBC) 12.1.0.1 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

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