My Oracle Support Banner

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

Last updated on MAY 11, 2022

Applies to:

Oracle Database Gateway for Sybase - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


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.


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

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