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 JULY 20, 2024

Applies to:

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

Symptoms

Oracle DG4ODBC 19C and odbc driver for netezza nzsql (IBM Netezza SQL) Release 11.2.2.1 [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

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


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