DG4ODBC: ORA-28511: Lost RPC Connection to Heterogeneous Remote Agent
(Doc ID 1988866.1)
Last updated on DECEMBER 19, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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
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
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
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
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
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 |