Geeks With Blogs
The Blug A forum that just screams "meh"...
There seem to be a lot of issues out there in Oracle where the source cause is that Oracle Text was not properly installed/configured.  There is an article on informIT regarding this topic, but many thanks to Rich Murnane who wrote this blog entry about it.

In the off-chance that Rich ever takes it down, I'll quote it here:

I had a tough time finding the instructions on how to manually install Oracle Text on a 10g database. I googled, yahoo'd, tahiti'd, no luck.

After a couple hours, dug up the following:
@$ORACLE_HOME/ctx/admin/catctx.sql ctxsys DRSYS TEMP NOLOCK
where ctxsys is the install schema, DRSYS is the default tablespace, Temp is well - temp tablespace for that user, and NOLOCK instructs the script to not lock the account when the install is complete (which by the way, you should lock).

until next time...Rich

Forgot to run the drdefxx.sql file (for US).

Problem/Solution: DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
Doc ID: Note:107626.1 Type: PROBLEM
Last Revision Date: 12-JUL-2007 Status: PUBLISHED

Problem Description

Attempting to create a context index and the following errors were generated:

ERROR atline 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATEroutine
ORA-20000: Oracle Text error:
DRG-10700: preference does notexist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at line 1

10700,0, "preference does not exist: %(1)s"
// *Cause: the preference name specified does not exists
// *Action: retry with the correct preference name
// *Mnemonic: PF_PREF_NOTXIST

Solution Description

The installation of Oracle Text does not appear to have been successful.
You will need to run the $ORACLE_HOME/ctx/admin/defaults/drdefxx.sql script
as ctxsys, where xx is the country specific name.

In 8.1.7 and newer, the DRG-10700 error could point to other potentially missing
objects addressable by running drdefxx.sql such as:

In 9iR2 and 10gR1, it could also point to:

In 10gR2, it could also point to:

Your database should not have DEFAULT_LEXER missing. These error messages above
indicate that the Oracle Text installation has not completed successfully.
Running drdefxx.sql will resolve this problem.

Additional Search Words

DEFAULT_LEXER create index
Posted on Friday, October 24, 2008 2:46 PM IT type pile | Back to top

Comments on this post: Installing Oracle Text on Oracle10gR2

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © cleggenator | Powered by: