Transactions Fail When Connecting Through a DBLink With ORA-2046 & ORA-2063 Errors And Remote ORA-600 [4400] (Doc ID 234579.1)

Last updated on MARCH 02, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Mar-2015***

Symptoms

Transactions fail when connecting via a dblink with ORA-2046 & ORA-2063 errors.  The remote instance will show ORA-600 [4400], [48] errors are occurring, e.g.:

Local instance

ORA-02046: distributed transaction already begun
ORA-02063: preceding %s%s from %s%s

Remote instance

ORA-00600: internal error code, arguments: [4400], [48], [], [], [], [], []


The call stack trace of the ORA-600 will resemble:

... ktcddt kssdch ktcbod kssdch ksuxds ksudel opilof opiodr ttcpip opitsk opiino opiodr opidrv sou2o main start

 

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