ORA-28511 When Selecting From a Large PostgreSQL Table Using DG4ODBC (Doc ID 949832.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Febl-2013***


Symptoms


A select from a PostgreSQL table with a large amount of data, for example more than 40k, gives the following error -

Select * from large_table@postgres ;
*
ORA-02068: following severe error from POSTGRES
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTO =TCP)(HOST=host1)(PORT=1521)))(CONNECT_DATA=(SID=POSTGRES)))

A select from a table with a small amount of data, for example 4k, using the same DG4ODBC connection works successfully.
The select of the same large Postgres table using DG4ODBC on a different machine may work successfully.

A DG4ODBC trace ends without any errors at the point where it tries to get the remote table information.


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