Dg4odbc 11.2.0.4 Connection From Oracle 11.2.0.4 To Sybase Fails with ORA-28511 (Doc ID 1957739.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Microsoft Windows (32-bit)

Symptoms

Queries via database link from Oracle using the Database Gateway for ODBC (DG4ODBC) 11.2.0.4 to Sybase database is not working when the Oracle database is 11.2.0.4.
The same query is working fine in Oracle 11.2.0.3 and DG4ODBC 11.2.0.3.
The error is -

select count(*) from "TPMControl"@devontest.world
  *
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname)(PORT=1554)))

(CONNECT_DATA=(SID=DEVONCHARON)))
ORA-02063: preceding line from DEVONTEST.WORLD
Process ID: 8028
Session ID: 33 Serial number: 3

 

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