ORA-600 [17059] error affecting domain index partitions (Doc ID 3042924.1)

Last updated on AUGUST 21, 2024

Applies to:

Symptoms

On : 19.19.0.0.0 version, Internals Errors (ORA-600 & ORA-7445)

ORA-00600 [17059]. This only affects domain index partitions with zero rows or no segments. The hcheck report identifies Orphan partitions, but after a rebuild of the domain index and clean-up of the orphans, the ORA-00600 [17059] still appears.
The patch level we saw this in is Database Release Update : 19.19.0.0.230418 (35042068).

ERROR
-----------------------
SELECT CSMP.ANALYSIS_MAINT_DATA_LOC_SEQ.NEXTVAL,AMD.ANALYSIS_MAINTENANCE_DATA_ID,NULL,NULL
FROM CSMP.ANALYSIS_MAINTENANCE_DATA AMD
WHERE AMD.ANALYSIS_ID = 5598 AND AMD.ANALYSIS_ELEMENT_ID=3572
AND CONTAINS(FINDING_REPAIR_TEXT, 'LEAK' ) > 0
AND NOT EXISTS ( SELECT NULL FROM CSMP.ANALYSIS_MAINT_DATA_LOC AMDL WHERE AMDL.ANALYSIS_MAINTENANCE_DATA_ID = AMD.ANALYSIS_MAINTENANCE_DATA_ID );

SELECT CSMP.ANALYSIS_MAINT_DATA_LOC_SEQ.NEXTVAL,AMD.ANALYSIS_MAINTENANCE_DATA_ID,NULL,NULL
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17059], [0x0A1C6DD08],
[0x0763E8A88], [0x0763E9108], [65520], [1], [0], [], [], [], [], []
Same db version affected and same stack trace

Cause

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