ORA-29874: Warning in the Execution of ODCIINDEXALTER Routine

(Doc ID 847078.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Healthcare Transaction Base - Version: 5.3
This problem can occur on any platform.


When trying to load or import terminologies, the following error occured:

[35 sec.] Import failed
[35 sec.] java.sql.SQLException: ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file /opt/oracle/product/102/db/ctx/data/enlx/droldU.dat not installed

It looks for the file droldU.dat but the Oracle Text Supplied Knowlege base was installed:
oracle@tcn00qubc00365:~> ll /opt/oracle/product/102/db/ctx/data/enlx
total 49308
-rw-r--r-- 1 oracle oinstall 330062 Apr 13 1999 dren.ds
-rw-r--r-- 1 oracle oinstall 312942 Apr 13 1999 dren.is
-rw-r--r-- 1 oracle oinstall 3497330 Aug 29 1999 drofdUS.dat
-rw-r--r-- 1 oracle oinstall 2652662 Aug 29 1999 drofiUS.dat
-rw-r--r-- 1 oracle oinstall 37766593 Aug 29 1999 droldUS.dat
-rw-r--r-- 1 oracle oinstall 3263531 Aug 29 1999 droliUS.dat
-rw-r--r-- 1 oracle oinstall 2585766 Aug 29 1999 drolkUS.dat
-rw-r--r-- 1 oracle oinstall 12 Feb 29 2000 drolsUS.dat

The same error is encountered running Healthcare ETS Maintenance Program


Deploying E-Business Suite and Healthcare Transaction Base 5.3 using Rapid Clone.


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