Tuesday, 14 September 2010

Missing Oracle Text Supplied Knowledge Base after 10gR2 database installation

After applying the, or Patchset and attempting to use theme functionality this will fail with errors like the following:

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
/u1/app/oracle/product/10.2.0/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "CTXSYS.DRUE", line 160
Or while running RepCA you receive a warning message that says:
"Oracle Text Knowlege Base is not installed."

1) You will need to install Oracle Text knowledge base from the Companion CD, please refer to the Companion CD Installation Guide specific to your platform for specific details.
2) Afterwards you must re-apply, or Patchset. Start up the runInstaller once again and select the, or products.xml file once again in the "Specify File Locations" screen. The OUI will see the new components installed and will only install the, or patchsets associated to the new products.
3) Click on 'Install' on the Summary Screen (On there should be roughly 13 "New Installations" items that are being installed)

4) After this then re-run catupgrd.sql script once again and this will correct the situation.

Same steps are applicable when Ultra Search product is required and was not installed with Oracle Database 10g release 2 ( software.

SocialTwist Tell-a-Friend

Related Posts by Categories

No comments: