ORA-07445 [dreogParseHeader()+550] (Doc ID 1372190.1)

Last updated on OCTOBER 08, 2015

Applies to:

Oracle Text - Version: and later   [Release: 11.2 and later ]
Information in this document applies to any platform.


The following error is found in the alert.log:

ORA-07445: exception encountered: core dump [dreogParseHeader()+550] [SIGSEGV] [ADDR:0x2A9752B6F9] [PC:0x3D5A4CE] [Address not mapped to object] []

The incident trace file shows the current SQL statement as

select column_value from table(cast(ctxsys.drvparx.IndexOptimizeParFn(cursor(select /*+ parallel(t 1) */ t.num
from ctxsys.dr$number_sequence t), :1, :2, :3, :4, :5, :6, :7) as sys.odcivarchar2list))

Browsing through the incident trace file, we find DML's such as below revealing which Text index is involved:

select /*+ DYNAMIC_SAMPLING(0) */ nlt_docid from "<owner>"."DR$<index_name>$N" order by nlt_docid

Manually running OPTIMIZE_INDEX on this index generates errors:

SQL> exec ctx_ddl.optimize_index('<owner>.<index_name>','FULL')
BEGIN ctx_ddl.optimize_index('<owner>.<index_name>','FULL'); END;
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-11341: Index optimization failed for one or more tokens
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 941
ORA-06512: at line 1

Querying the Text index's I-table for count of rows with token_first = 0, returns more than zero:

SQL> select count(*) from <owner>.DR$<index_name>$I where token_first = 0;




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