ORA-28511 Selecting From Some MySQL Tables Using DG4ODBC and MySQL 5.1.11 Driver on Linux (Doc ID 1530565.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Linux 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)))

 

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

 



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