Error ORA-29855 ORA-20000 DRG-100 arguments [51021],[drwaf.c],[1607],[] while creating Index on RAC with E-Business Suite (Doc ID 1367324.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Symptoms

On RAC system with Oracle E-Business Suite (APPS) I am trying to run in the driver file created by dpost_imp.pl - I have called this: CREATE_CTX_IND.drv.
When I run in this driver it tries to run the following two sql scripts:

$APPL_TOP/pa/11.5.0/patch/115/sql/paxincx1.sql

$APPL_TOP/icx/11.5.0/patch/115/sql/icxintm2.sql

The versions of the above sql scripts are:

ident $APPL_TOP/pa/11.5.0/patch/115/sql/paxincx1.sql
/orahome/TEST2/test2appl/pa/11.5.0/patch/115/sql/paxincx1.sql:
$Header: paxincx1.sql 115.12.90.1 2004/01/19 16:51:57 dmpotapo noship $

and

ident $APPL_TOP/icx/11.5.0/patch/115/sql/icxintm2.sql
/orahome/TEST2/test2appl/icx/11.5.0/patch/115/sql/icxintm2.sql:
$Header: icxintm2.sql 115.15 2004/12/10 21:47:19 gjimenez ship $

Both sql scripts fail with the same error message:


sqlplus -s APPS/***** @/orahome/TEST2/test2appl/pa/11.5.0/patch/115/sql/paxincx1.sql @paxincx1 PA APPS
DECLARE
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-00100: internal error, arguments : [51021],[drwaf.c],[1607],[],[]
ORA-06512: at line 129

And if I run them manually from the command line, I get the same error.

The creation of a simple Text index fails also:

Changes

Cause

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