DRG-11446 droldUS.dat not installed

You are trying to create a text index and receive the following error:

   CREATE INDEX FILES_CONTENT_IDX ON FILES(CONTENT_URL) INDEXTYPE IS 
CTXSYS.CONTEXT
   *
   ERROR at line 1:
   ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
   ORA-20000: Oracle Text error:
   DRG-11422: linguistic initialization failed
   DRG-11446: supplied knowledge base file
   /u01/app/oracle/product/10.2.0/db_1/ctx/data/enlx/droldUS.dat not installed
   ORA-06512: at "CTXSYS.DRUE", line 160
   ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

Apparently this is a known issue for "for new 10g installations" as reported by 
the metalink Note:430604.1.  Well, if it's a known issue why not fix it in R2?  
I hit this issue after I installed 10gR2, applied 10.2.0.3 and then patched 
with the latest CPUJUL2007.  But I digress, you are probably here scratching 
your head in the same position as I am and the last thing you need is my 
bitching about how Oracle does it's business.

So lets get down to it shall we?  The solution proposed in Note:430604.1 is to 
install all of the additional components from "Oracle Database 10g Companion 
CD" then reapply all patches that you've already applied to your ORACLE_HOME 
...

Sounds great doesn't it?  Would you do this?  If you are considering, you might 
want to look up Bug 4426262 - it might change your mind ...

Personally I decided to follow a shorter (at least I thought it was shorter) 
solution outlined in Note:430604.1 by manually extracting the dreaded 
droldUS.dat file from the Companion CD.  The problem of course is that Oracle 
support just couldn't get the procedure down right by directing you to go into 
the following directory [WRONG]:

  "stage\Components\oracle.demo.cartridges.context\10.1.0.2.0\1\DataFiles"

then extracting a file named [WRONG]:

  group1.1.jar

So if you tried to follow these steps you'd be stuck and frustrated as you 
probably are right now.  But FEAR NO ORACLE my friend - here's the right 
solution ...

First you'll need to get the Companion CD for your platform. Here's the KEY 
point - you MUST get R1 companion CD - R2 CD doesn't have these files.  I am 
working on Solaris so in my case I went to:

 Oracle 10gR1 for Solaris

and downloaded ship_rel10_sol64_ccd.cpio.gz

NOTE:
   From here on you'll need to substitute ship_rel10_sol64_ccd.cpio.gz 
   with the filename for your platform:

## put ship_rel10_sol64_ccd.cpio.gz on your server and unzip it
##
host.SID-> pwd
/u01/app/oracle/download/10gR1_companion
host.SID-> gunzip ship_rel10_sol64_ccd.cpio.gz

host.SID-> ls -lta
total 1304852
drwxr-xr-x   2 oracle   dba          512 Dec  5 15:26 .
drwxr-xr-x   9 oracle   dba          512 Dec  5 15:26 ..
-rw-r--r--   1 oracle   dba      667746304 Dec  5 15:25 
ship_rel10_sol64_ccd.cpio
host.SID-> cat ship_rel10_sol64_ccd.cpio | cpio -icd
1304190 blocks
host.SID->

## extract missing files directly from JAR file
##
host.SID-> cd ./Disk1/stage/Components/oracle.cartridges.context.knowbase/10.1.0.2.0/1/DataFiles/

host.SID-> ls -l
total 58194
-rwxr-xr-x   1 oracle   dba          184 Dec  5 15:27 build.jar
-rwxr-xr-x   1 oracle   dba      29768378 Dec  5 15:27 data.jar
host.SID->

host.SID-> unzip data.jar
Archive:  data.jar
  inflating: ctx/data/enlx/drofdUS.dat
  inflating: ctx/data/enlx/drofiUS.dat
  inflating: ctx/data/enlx/droldUS.dat
  inflating: ctx/data/enlx/droliUS.dat
  inflating: ctx/data/enlx/drolkUS.dat
  inflating: ctx/data/enlx/drolsUS.dat
  inflating: ctx/data/frlx/drofdF.dat
  inflating: ctx/data/frlx/drofiF.dat
  inflating: ctx/data/frlx/droldF.dat
  inflating: ctx/data/frlx/droliF.dat
  inflating: ctx/data/frlx/drolkF.dat
  inflating: ctx/data/frlx/drolsF.dat
host.SID->

## copy missing files over to ORACLE_HOME
##
host.SID-> ls -l /u01/app/oracle/product/10.2.0/db_1/ctx/data/enlx/
total 1312
-rw-r--r--   1 oracle   dba       330062 Apr 13  1999 dren.ds
-rw-r--r--   1 oracle   dba       312942 Apr 13  1999 dren.is
host.SID-> cp -p ./ctx/data/enlx/* $ORACLE_HOME/ctx/data/enlx/

host.SID-> ls -l $ORACLE_HOME/ctx/data/enlx/
total 98674
-rw-r--r--   1 oracle   dba       330062 Apr 13  1999 dren.ds
-rw-r--r--   1 oracle   dba       312942 Apr 13  1999 dren.is
-rw-r--r--   1 oracle   dba      3497330 Aug 29  1999 drofdUS.dat
-rw-r--r--   1 oracle   dba      2652662 Aug 29  1999 drofiUS.dat
-rw-r--r--   1 oracle   dba      37766593 Aug 29  1999 droldUS.dat
-rw-r--r--   1 oracle   dba      3263531 Aug 29  1999 droliUS.dat
-rw-r--r--   1 oracle   dba      2585766 Aug 29  1999 drolkUS.dat
-rw-r--r--   1 oracle   dba           12 Feb 29  2000 drolsUS.dat
host.SID->

## finally re-run index creation - it should work now
##
Index created.