ORA-28511 Selecting From Some MySQL Tables Using DG4ODBC and MySQL 5.1.11 Driver on Linux
(Doc ID 1530565.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterLinux x86-64
Symptoms
A database link has been setup between Oracle and MySQL version 5.0.77 using DG4ODBC and mysql-connector-odbc-5.1.11-linux-rhel5-x86-64bit.
Selects work for some tables but for others give the error -
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))(CONNECT_DATA=(SID=odbcmysql)))
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))(CONNECT_DATA=(SID=odbcmysql)))
A DG4ODBC debug trace ends at this point -
Exiting hgobegn, rc=0 at 2012/08/17-16:02:50
hostmstr: 0: HOA After hoabegn
hostmstr: 0: RPC After Begin Trans
hostmstr: 0: RPC Before Describe Table
hostmstr: 0: HOA Before hoadtab
Entered hgodtab at 2012/08/17-16:02:50
count:1
table: mysql_table_name
hostmstr: 0: HOA After hoabegn
hostmstr: 0: RPC After Begin Trans
hostmstr: 0: RPC Before Describe Table
hostmstr: 0: HOA Before hoadtab
Entered hgodtab at 2012/08/17-16:02:50
count:1
table: mysql_table_name
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 |