SQLNET.INBOUND_CONNECT_TIMEOUT Causes DG4ODBC To Fail With ORA-28511 Or ORA-600 [opidsa-2] (Doc ID 549095.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When using the SQLNET INBOUND_CONNECT_TIMEOUT parameter (in the listener.ora and sqlnet.ora), the established connection with an HS-Agent (HSODBC in version 10 and Database Gateway for ODBC (DG4ODBC) in version 11) is broken by SQL*Net after this time has expired.

The session in which the database link to the gateway has been opened will get an ORA-28511 when trying to run the next SQL-statement:

SQL> select * from whereami@d71e;
*
ERROR at line 1:
ORA-02068: following severe error from D71E
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=el4u4eb01.nl.oracle.com)(Port=1521))(CONNECT_DATA=(SID=d71e)))


or another symptom that can occur when querying Oracle dynamic/internal tables like 'dual', 'all_catalog' etc. is the following internal error:

SQL> select to_char(sysdate,'dd-mm-yyyy_hh24:mi:ss') from dual@d71e;
            *
ERROR at line 1:
ORA-00600: internal error code, arguments: [opidsa-2], [24338], [ORA-24338: statement handle not executed], [], [], [], [], []


The following error can also be received -

ORA-07445: exception encountered: core dump [hok2beg()+191] [SIGSEGV] [ADDR:0x0] [PC:0x66C67EB] [Address not mapped to object] []

This error may also appear in the RDBMS alert log when a session has timed out -

ORA-07445: exception encountered: core dump [lsfp()+118] [SIGSEGV] [ADDR:0x8] [PC:0x2339FB2] [Address not mapped to object] []

 The problem also happens with the 12c Gateway versions and will give an 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=%s
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from DG4ODBC_FREETDS_EMGTW_12101_DB
Process ID: 27446
Session ID: 15 Serial number: 40039


A gateway trace may show the following errors -

HS:  RPC error reported on agent, XfrBigBuffer: _xfr_opaque for bigbuf_horrhb; NCR code 1004

HS:  RPC error reported on agent, FetchRowCallbOut: HoadaTransfer for list_horsaoQ; NCR code 1004

HS:  RPC error reported on agent, ReceiveFetchRow: ncrosou_send_out_args; NCR code 3010

 

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