Missing Oracle Text Supplied Knowledge Base after 10gR2 database installation

After applying the 10.2.0.2.0, 10.2.0.3.0 or 10.2.0.4 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
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364
Or while running RepCA you receive a warning message that says:
"Oracle Text Knowlege Base is not installed."

Solution
1) You will need to install Oracle Text knowledge base from the 10.2.0.1.0 Companion CD, please refer to the Companion CD Installation Guide specific to your platform for specific details.
2) Afterwards you must re-apply 10.2.0.2.0, 10.2.0.3.0 or 10.2.0.4.0 Patchset. Start up the runInstaller once again and select the 10.2.0.2.0, 10.2.0.3.0 or 10.2.0.4.0 products.xml file once again in the "Specify File Locations" screen. The OUI will see the new components installed and will only install the 10.2.0.2.0, 10.2.0.3.0 or 10.2.0.4.0 patchsets associated to the new products.
3) Click on 'Install' on the Summary Screen (On 10.2.0.3.0 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 (10.2.0.1.0) software.


Cheers!!!

Related Posts by Categories