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).


Subject:
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 "CTXSYS.TEXTINDEXMETHODS", line 54
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.


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

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

In 10gR2, it could also point to:
- EXTENDED_STOPLIST

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

Comments

Unknown said…
Awesome post, Rich! This was exactly what I needed. Thanks!
Unknown 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!
Eierdopje 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.
Thanks for that ... amazing how the exact thing you need is already out there somewhere. :-)

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

Cheers

--
Kamal
Murnane 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.

Best...Rich
Anonymous 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

--
Kamal
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: http://richmurnane.blogspot.com/search/label/DataGeek

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