ORA-600[kcbo_ivd_lobid_process_7] is Raised While Creating Text Index With Cache Nologging (Doc ID 2286031.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database - Standard Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

ORA-600[kcbo_ivd_lobid_process_7] is raised while creating a text index with cache and nologging attribute for $R table.

SQL> create index test_idx on test(SEARCH_TEST)
2 indextype is ctxsys.context
3 parameters('storage lexer_jp_txt_storage lexer lexer_jp_txt');

ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kcbo_ivd_lobid_process_7],
Process ID: 24379
Session ID: 108 Serial number: 9223

This problem only happens if you specify storage clause as "cache" and "nologging" for "R_TABLE_CLAUSE" attribute as bellow.

 

Cause

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