Monday, January 30, 2012

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine


After upgrading DB, Domain & Text indexes were failing. After some research, we found the issue is with CTXSYS schema. Some of the objects went invalid.

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-04063: package body "CTXSYS.DRIUTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRIUTL"
ORA-06512: at "CTXSYS.DRIPARSE", line 800
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 81

BEGIN
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvutl.GetInvoker
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 597
ORA-06512: at line 2

Solution is to reinstall Oracle Text usint catctx.sql that can rebuild ctxsys schema.

No comments: