ORA-28513: internal error in heterogeneous remote agent connecting to DB2 Through Oracle Gateway for DRDA In Oracle Database 12.1.0.2

(Doc ID 2312814.1)

Last updated on OCTOBER 13, 2017

Applies to:

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

Symptoms

While trying to load oracle database (12.1.0.2) with DB2 (z/OS version) data using the oracle gateway 11.2.0.4 version, the connection using the database link from 12.1.0.2 is failing with error message

select count(0) from owner.TAB_NAME@DB2;
  *
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from DB2

The same statement run very well with no issue when executing from oracle database version 11.2.0.4 and 12.1.0.1

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