Text Index Creation=ORA-29855 ORA-20000 DRG-10502 DRG-50857 ORA-4063 ORA-4068 On CTXSYS.DRVXMD (Doc ID 2017852.1)

Last updated on MARCH 28, 2019

Applies to:

Symptoms

Sample Text index creation per the steps in this Note:

     Oracle Text Health Check (Doc ID 823649.1)

fails in SQL*Plus with:

     "...
     **********************************************************************
     Testing Text Index Creation:
     **********************************************************************
     ..Creating user TEXT_HEALTHCHECK
     ....User TEXT_HEALTHCHECK created successfully
     ..Testing creation of Text index type CONTEXT
     ....Creating table TEXT_HC_TAB
     ....Inserting test data
     ....Creating text index TEXT_HC_IDX
     ....ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
     ORA-20000: Oracl
     e Text error:
     DRG-10502: index TEXT_HC_IDX does not exist
     DRG-50857: oracle error in drdml
     po
     ORA-04063: package body "CTXSYS.DRVXMD" has errors
     ORA-06508: PL/SQL: could not find pr
     ogram unit being called: "CTXSYS.DRVXMD"
     ORA-06512: at line 1


     **********************************************************************
     ..."

Cause

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