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
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 |