ORA-00600 [20084] [748040989] reported on oracle text queries (Doc ID 2713043.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 19.3.0.0.0 version, Creating/Maintaining context indexes

ACTUAL BEHAVIOR
---------------
The error

ORA-00600: Interner Fehlercode, Argumente: [20084], [748040989], [0], [748040989], [0], [], [], [], [], [], [], []

is encountered when running a statement including "CONTAINS":

SELECT COUNT(*) FROM DBild
 WHERE (((CED>=to_date('11.01.2020','DD.MM.YYYY') AND CED<=to_date('14.01.2020','DD.MM.YYYY'))
  AND (contains(Text,'birbaumer',3)>0))
  AND (Status='Original' OR Status='Archiviert'))
  AND ((IptcDie!='krjverlag' OR IptcDie IS NULL)
  AND ((IptcDie!='sose' OR IptcDie IS NULL)
  AND ((IptcDie!='journale' OR IptcDie IS NULL)
  8 AND (IptcDie!='buli' OR IptcDie IS NULL))));
SELECT COUNT(*) FROM DBild
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [20084], [843438098], [10], [843438098], [10], [], [], [], [], [], [], []

OR

SELECT count(cid) FROM DBild WHERE contains(IptcAN,'Schöndorfer',6)>0
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [20084], [604880322], [1], [604880322], [1], [], [], [], [], [], [], []

Checking the internal $ table we can see duplicated rows for one partition:

select TEXTKEY,count(*) from NGEN."DR$DBILD_IPTCAN#0037$K" group by textkey having count(*) > 1;

TEXTKEY              COUNT(*)
------------------ ----------
AAGq9rACPAAC3VdAAC          2
AAGq9rACPAAC3XEAAK          2
AAGq9rACPAAC3XUAAH          2
AAGq9rACPAAC3XUAAT          2
AAGq9rACOAADIaJAAG          2
AAGq9rACOAADIaZAAK          2
AAGq9rACJAAB3XHAAc          2
AAGq9rACJAAB3XHAAi          2

.

.

AAGq9rACQAADdQkAAB          2
AAGq9rACJAAB3WqAAI          2
AAGq9rACJAAB3XKAAE          2

208 rows selected.

Changes

Cause

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