My Oracle Support Banner

XA Transactions Through Gateways Give Ora-600 Errors Then Instance Terminates or ORA-3001 Error (Doc ID 578099.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When using an XA-compliant tp-monitor with Oracle-XA and a XA-transaction that uses an HS-database link to a 10g or 11g Gateway then at or just before XA_close a couple of internal errors are encountered and the Oracle instance terminates:

ORA-00600: internal error code, arguments: [1234]
ORA-00600: internal error code, arguments: [729], [602296], [space leak] [], [], []
ORA-00600: internal error code, arguments: [17112], [0x700000064F80F20]
ORA-07445: exception encountered: core dump


Similar SQL that does not use an HS-database link to a Gateway completes successfully.

When using a 11.2 Gateway then the following error is returned -

ORA-03001: unimplemented feature


and a supplementary message indicating specifically that migratable transactions are unsupported.

Cause

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
Symptoms
Cause
Solution
References

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