My Oracle Support Banner

Oracle Dblink To Netezza Fails With Error ORA-28511: Lost RPC Connection To Heterogeneous Remote (Doc ID 2973459.1)

Last updated on DECEMBER 19, 2023

Applies to:

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


Oracle DG4ODBC 19C and odbc driver for netezza nzsql (IBM Netezza SQL) Release [Build 20] ona gateway server.
After installation we created a dblink from Oracle database using gateway server and netezza odbc driver.
The dblink are failling with the following error:

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=xxxxxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xxxx)))
ORA-02063: preceding line from <dblink>
Process ID: 28713
Session ID: 838 Serial number: 54478


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.