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).
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
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.
Chris
I didn't need to search on Metalink.
Why the tablespace DRSYS and not, for example, SYSAUX which would be already there?
Cheers
--
Kamal
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
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
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