DG4ODBC: ORA-28511: Lost RPC Connection to Heterogeneous Remote Agent (Doc ID 1988866.1)

Last updated on MAY 26, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
ORA-28511 ORA-28513

Symptoms

Following error is observed when accessing Mysql tables using Database Gateway for ODBC (DG4ODBC) 11.2 -

 

SQL> select count(*) from "XXXXX"@YYYY;
select count(*) from "cmdb_ip"@mrms
*
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=(PROTOCOL=TCP)(HOST=localhost)(PORT=1523))(CONNECT_DAT
A=(SID=mrms)))
ORA-02063: preceding line from MRMS
Process ID: 3410
Session ID: 726 Serial number: 1113

The gateways trace ends after getting the remote table details and does not show any errors -

Entered hgodtab at 2015/03/09-10:44:28
320  count:1
321   table: XXXXX                                    <==== Table name here
322  Allocate hoada[0] @ 0x1233480
323 Entered hgopcda at 2015/03/09-10:44:28
324  Column:1(id): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
325 Exiting hgopcda, rc=0 at 2015/03/09-10:44:28
326 Entered hgopcda at 2015/03/09-10:44:28
327  Column:2(addr): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:0, octet:45, sign:1, radix:10
328 Exiting hgopcda, rc=0 at 2015/03/09-10:44:28
329 Entered hgopcda at 2015/03/09-10:44:28
330  Column:3(segment_id): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
331 Exiting hgopcda, rc=0 at 2015/03/09-10:44:28
332 Entered hgopcda at 2015/03/09-10:44:28
333  Column:4(status): dtype:-8 (WCHAR), prc/scl:3/0, nullbl:1, octet:9, sign:1, radix:10

357  Column:12(class): dtype:-8 (WCHAR), prc/scl:6/0, nullbl:1, octet:18, sign:1, radix:10
358 Exiting hgopcda, rc=0 at 2015/03/09-10:44:28
359 Entered hgopcda at 2015/03/09-10:44:28
360  Column:13(sd_id): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
361 Exiting hgopcda, rc=0 at 2015/03/09-10:44:28
362 Entered hgopcda at 2015/03/09-10:44:28
363  Column:14(coss_id): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
364 Exiting hgopcda, rc=0 at 2015/03/09-10:44:28

  Another kind of error we saw is below which has similar symptoms

select * from "XXXXXXX"@JESS where rownum < 10;
select * from "XXXXXXX"@JESS where rownum < 10
*
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from JESS

  

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