Issuing Rollback After Using DG4DRDA Gives Error - ORA-28511: Lost RPC Connection To Heterogeneous Remote Agent

(Doc ID 1931689.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database Gateway for DRDA - Version and later
Information in this document applies to any platform.


Using Database Gateway for DRDA (DG4DRDA)  running any SQL after a commit or rollback after the execution of a DB2 stored procedure gives the error -


SQL> @test11204
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> @test11204
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
(PORT=11241)))(CONNECT_DATA=(SID=jdehil1))) ORA-02063: preceding line from JDEHIL1
ORA-06512: at line 8
Process ID: 433
Session ID: 149 Serial number: 17595

The same error happens trying to describe the remote procedure from Oracle.

The problem does not happen with DG4DRDA


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