Installing Oracle Text on Oracle 10gR2...

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


Dan said…
Awesome post, Rich! This was exactly what I needed. Thanks!
Christobal said…
Thanks for the post!
Kubilay said…
Very Good post! I was trying to install Apex on Oracle 10g R2 and I was missing the Oracle Text database component. This post helped me to install Oracle Text and carry on with the Apex installation. Thank you Rich!
Stefan said…
Nice post, two remarks:
1. In the string @$ORACLE_HOME/ctx/admin/catctx.sql ctxsys DRSYS TEMP NOLOCK, ctxsys is the password used for user ctxsys.
2. Run the script drdefxx.sql as user ctxsys.
Alannd said…
Thanks for posting this Rich.
Chris said…
Thanks for that ... amazing how the exact thing you need is already out there somewhere. :-)

Prem said…
Thanks it solved my problem
pbsl said…
This comment has been removed by a blog administrator.
Amal said…
Thanks a lot rich! It really helped.
Thanks a lot!
I didn't need to search on Metalink.
kalotus said…
Thanks for this post!
Why the tablespace DRSYS and not, for example, SYSAUX which would be already there?


Rich said…
First thought is that from experience I've noticed that some of the supporting tables for Text indexes get quite large, but I think those would be created in either the user's default tablespace or the tablespace defined in the create index statement (and the preferences for that index).

Most likely reason why Oracle recommends this is for encapsulation of system objects into one tablespace for this type of functionality. The SYSAUX tablespace is really an extension of SYSTEM and I'd prefer not to touch that tablespace, just how I've done it and what Oracle recommends.

kalotus said…
Thanks for your reply.
If I understood correctly Oracle recommends not to touch SYSAUX. Do you have any reference for that?
I'm asking because I believe that when you install Oracle Text through DBCA the tablespace SYSAUX is used, and not DRSYS.
But I'm not sure I remember correctly.

Kind regards

Rich Murnane said…
Hello all,

Thanks for visiting this page.

Please consider taking a peek at the rest of the blog or at my "DataGeek" cartoon posts which can be found here at this link:

Thanks...Rich Murnane
Dale Cook said…
Thanks! This blog entry is still useful today! I needed instructions to do this exact thing.