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 AUGUST 20, 2017

Applies to:

Oracle Text - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Oracle Applications DBA - Version 12.1.1 and later
Information in this document applies to any platform.


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:

 

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