Error Ncr-01004 and ORA-3136 During Insert Using Database Gateway (Doc ID 1196299.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for Sybase - Version 10.2.0.3 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Aug-2013***


Symptoms


Running an insert with a large number of rows over the TG4Sybase 10.2 gateway fails with:


Mon Aug 30 13:41:54 2010
Error 28500 trapped in 2PC on transaction 7.111.99450. Cleaning up.
Error stack returned to user:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
trying all tdps, ignoring failure
ORA-02063: preceding 2 lines from TG4SYBS


and a gateway debug trace shows the following errors -


Execute SQL statement
DRV_GetRows: ORA-03136: inbound connection timed out
...
nvRETURN (./drv_irow.c 368): -2204



and -


hoastmt.c (2094): ; hosceac_end_agent_callback(): Exited with retcode = 0.
hoaexec (18): ; hoaexec Exited with retcode = 28500, nrows = 0.
HS Agent received unexpected RPC disconnect
Network error 1004: NCR-01004: NCRS: Write error.
hoaroll (12): ; hoaroll Entered. tflag = 0.

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