Summary
The Oracle Text option requires the use of certain context knowledge bases that are not part of the typical installation of the Oracle 11gR2 database software. To be able to create context indexes these knowledge bases may be required.
Example:
DRG-11446: supplied knowledge base file /u01/app/oracle/product/11.2.0/dbhome_1/ctx/data/enlx/droldUS.dat not installed
1. Download the Oracle Examples Installation (formally Companion CD)
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
2. Unzip the Oracle Examples Installation
$ unzip linux.x64_11gR2_examples.zip
3. Goto the location in the installation media for the CTX Filegroups
$ cd examples/stage/Components/oracle.ctx.companion/11.2.0.1.0/1/DataFiles
4. unzip the CTX Knowledge base files
$ unzip filegroup1.jar
Archive: filegroup1.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
5. Goto the location of the knowledge base files we just extracted and copy them to the Oracle Database Home location
$ cd ctx/data/enlx/
$ cp * $ORACLE_HOME/ctx/data/enlx
Subscribe to:
Post Comments (Atom)
5 comments:
thank you very much, it worked well for me :)
Thanks, this solved my problem!
Perfect, thank you.
It worked. In my case i have copied the files from PRD instance.. Thank you
Mike,
Thank you for this post. Helped me alot.
Regards,
Maaz
Post a Comment