Database Error ORA-29861: domain index marked as loading/failed/unusable

Error status:

Bmxaa3167e-Unexpected exceptions occurred during workflow processing.
BMXAA4211E-When WFASSIGNMENT task is assigned = 2,568,992 process = MRAPPROVE process Revision = 6 workflow id = 42,689 node id = 26, a database error has occurred and is numbered 29861.
ORA-29861: domain index marked as LOADING/FAILED/UNUSABLE

Solution Process:

At first, I thought it was a domain index problem or a full-text index problem: Execute the full-text index script as follows:

call ctx_ddl.drop_preference('global_lexer');call ctx_ddl.drop_preference('default_lexer');call ctx_ddl.drop_preference('english_lexer');call ctx_ddl.drop_preference('chinese_lexer');call ctx_ddl.drop_preference('japanese_lexer');call ctx_ddl.drop_preference('korean_lexer');call ctx_ddl.drop_preference('german_lexer');call ctx_ddl.drop_preference('dutch_lexer');call ctx_ddl.drop_preference('swedish_lexer');call ctx_ddl.drop_preference('french_lexer');call ctx_ddl.drop_preference('italian_lexer');call ctx_ddl.drop_preference('spanish_lexer');call ctx_ddl.drop_preference('portu_lexer');call ctx_ddl.create_preference('default_lexer','basic_lexer');call ctx_ddl.create_preference('english_lexer','basic_lexer');call ctx_ddl.create_preference('chinese_lexer','chinese_lexer');call ctx_ddl.create_preference('japanese_lexer','japanese_lexer');call ctx_ddl.create_preference('korean_lexer','korean_morph_lexer');call ctx_ddl.create_preference('german_lexer','basic_lexer');call ctx_ddl.create_preference('dutch_lexer','basic_lexer');call ctx_ddl.create_preference('swedish_lexer','basic_lexer');call ctx_ddl.create_preference('french_lexer','basic_lexer');call ctx_ddl.create_preference('italian_lexer','basic_lexer');call ctx_ddl.create_preference('spanish_lexer','basic_lexer');call ctx_ddl.create_preference('portu_lexer','basic_lexer');call ctx_ddl.create_preference('global_lexer', 'multi_lexer');call ctx_ddl.add_sub_lexer('global_lexer','default','default_lexer');call ctx_ddl.add_sub_lexer('global_lexer','english','english_lexer','en');call ctx_ddl.add_sub_lexer('global_lexer','simplified chinese','chinese_lexer','zh');call ctx_ddl.add_sub_lexer('global_lexer','japanese','japanese_lexer',null);call ctx_ddl.add_sub_lexer('global_lexer','korean','korean_lexer',null);call ctx_ddl.add_sub_lexer('global_lexer','german','german_lexer','de');call ctx_ddl.add_sub_lexer('global_lexer','dutch','dutch_lexer',null);call ctx_ddl.add_sub_lexer('global_lexer','swedish','swedish_lexer','sv');call ctx_ddl.add_sub_lexer('global_lexer','french','french_lexer','fr');call ctx_ddl.add_sub_lexer('global_lexer','italian','italian_lexer','it');call ctx_ddl.add_sub_lexer('global_lexer','spanish','spanish_lexer','es');call ctx_ddl.add_sub_lexer('global_lexer','portuguese','portu_lexer',null);

Run and the problem persists.

Okay, so remove text search enabled in the database configuration?

The Configdb cannot be completed, and the message "the domain index status is loading, and ddl operations cannot be performed" is reported. (You can't remember it clearly and forget it ).

 

Well, it looks like the index problem in the oracle database. Google to an article:

1. ORA-29861: domain index marked as LOADING/FAILED/UNUSABLE

2. This is an intermedia index of the table.

3. First query to see the current full-text index

4.SelectIdx_name, idx_statusFromCtxsys. ctx_indexes;

5. You need to re-Synchronize the full-text index:

6.Alter indexIndex name rebuild online parameters ('sync ')

7. If not, delete the index.

8.Drop indexIndex nameForce;

Query indexes in your own databaseSELECTT .*FROMCtxsys. ctx_indexes t, there are many exceptions, as shown below:

 

Follow the above steps to fix the problem. If it doesn't work, simply delete it. (Note: I'm in the test environment. I hope you are careful. I didn't know what this table is)

It seems that there are no errors. However, we haven't figured out what the ctxsys. ctx_indexes of oracle is. Take a good look at it and wait for it to be continued...