My Oracle Support Banner

Oracle Database Gateway for ODBC throws ORA-28511 when connecting to PostgreSQL database using PostgreSQL ODBC driver 08.04.0200 (Doc ID 2602210.1)

Last updated on OCTOBER 28, 2019

Applies to:

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

Symptoms

Running Oracle Database Gateway for ODBC 12c connecting to a PostgreSQL database using PostgreSQL ODBC driver version 08.04.0200. When running a select command getting the below error:

 

select * from postgresql_table@dblink;

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=hostname)(PORT=1555))(CONNECT_DATA=(SID=sid)))
ORA-02063: preceding line from DBLINK
Process ID: 171645
Session ID: 2487 Serial number: 29785

 



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


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