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 18, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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
*
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
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
| Symptoms |
| Cause |
| Solution |
| References |