Oracle Text Error Drg-10700
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work drg-12504: stoplist ctxsys.default_stoplist does not exist correctly without it enabled. Please turn JavaScript back on ora-06512: at "ctxsys.textindexmethods", line 366 and reload this page. Please enter a title. You can not post a blank
Drg-10700 Preference Does Not Exist Global_lexer
message. Please type your message and try again. More discussions in WebCenter Content All PlacesFusion MiddlewareWebCenterWebCenter Content This discussion is archived 2 Replies
Ora-29855: Error Occurred In The Execution Of Odciindexcreate Routine
Latest reply on Dec 27, 2010 7:34 AM by 789452 DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLIST 789452 Dec 26, 2010 8:18 AM Hi, I have recently installed Oracle Universal Content Management 10gR3 server, using an Oracle 10gR2 database. When I try to run the indexer, I get the below error in the content server log. I know this is related to Oracle Text, but I don't know what the problem is. Any help will be appreciated. Many Thanks, Indexing aborted. Unable to delete collection directories. Indexer could not create table or index: IdcColl2. Unable to execute SQL statement 'CREATE INDEX FT_IdcColl2 ON IdcColl2 (dDocFullText) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('DATASTORE CTXSYS.DEFAULT_DATASTORE FILTER CTXSYS.AUTO_FILTER FORMAT COLUMN DFULLTEXTFORMAT CHARSET COLUMN DFULLTEXTCHARSET LEXER OCS_IDCCOLL2_LEXER SYNC (ON COMMIT)')'. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLIST ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364 [ Details ] An error has occurred. The stack trace below shows more information. !csIndexerAbortedMsg!csIndexerUnableToDeleteCollection!csIndexerDBFullTextCanNotCreateTableOrIndex,IdcColl2!csDbUnableToExecuteSql,CREATE INDEX FT_IdcColl2 ON IdcColl2 (dDocFullText) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('DATASTORE CTXSYS.DEFAULT_DATASTORE FILTER CTXSYS.AUTO_FILTER FORMAT COLUMN DFULLTEXTFORMAT CH
preference needs to be configured on ctxsys same as it was on old database. Problem:ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-20000: Oracle Text error:DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLISTORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366 SOLUTION:Login as CTXSYS:BEGINCTX_DDL.create_preference('CTXSYS.DEFAULT_WORDLIST', 'BASIC_WORDLIST');END; update dr$parameterset par_value = 'CTXSYS.EMPTY_STOPLIST'where par_value = 'CTXSYS.DEFAULT_STOPLIST'; BEGINCTX_DDL.create_preference('CTXSYS.DEFAULT_LEXER', 'BASIC_LEXER');END; Posted by Ferdous Nadvi at 2:03 https://community.oracle.com/thread/2152091?start=0 PM Reactions: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) FiNd mE! Loading... Recent Posts Followers Ferdous Nadvi Toronto, ON, Canada BSC in Computer science, Oracle Certified Professional, Oracle Certified Expert (Administering RAC), http://nadvi.blogspot.com/2012/01/drg-10700-preference-does-not-exist.html OCE (Administering Oracle on Linux), OCE 11g (Performance tuning expert) , MCP , Microsoft SQLServer 2012 database professional. Working with Oracle Since 2005. View my complete profile Blog Archive ► 2016 (1) ► July (1) ► 2014 (1) ► August (1) ► 2013 (32) ► October (2) ► August (1) ► July (5) ► June (6) ► April (4) ► March (6) ► February (6) ► January (2) ▼ 2012 (25) ► July (1) ► June (3) ► March (5) ► February (10) ▼ January (6) Truncate Table From a Remote Database DRG-10700: preference does not exist: CTXSYS.DEFAU... Generating & sending email based excel reporting a... ORA-29855: error occurred in the execution of ODCI... Connecting to database without TNS entry ORA-24247 Trying To Send Email Using UTL_SMTP from... ► 2011 (45) ► November (19) ► October (12) ► August (1) &
couple hours, dug up the following:@$ORACLE_HOME/ctx/admin/catctx.sql ctxsys DRSYS TEMP NOLOCKwhere ctxsys is http://richmurnane.blogspot.com/2008/01/installing-oracle-text-on-oracle-10gr2.html the install schema, DRSYS is the default tablespace, Temp is http://www-01.ibm.com/support/docview.wss?uid=swg21405526 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...RichForgot to run the drdefxx.sql file (for US).Subject:Problem/Solution: DRG-10700: preference does not does not exist: CTXSYS.DEFAULT_LEXERDoc ID: Note:107626.1 Type: PROBLEMLast Revision Date: 12-JUL-2007 Status: PUBLISHEDProblem Description-------------------Attempting to create a context index and the following errors were generated:ERROR atline 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATEroutineORA-20000: Oracle Text error:DRG-10700: preference does notexist: CTXSYS.DEFAULT_LEXERORA-06512: at "CTXSYS.DRUE", line 126ORA-06512:at "CTXSYS.TEXTINDEXMETHODS", line 54ORA-06512: at line does not exist 110700,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 scriptas ctxsys, where xx is the country specific name.Explanation-----------In 8.1.7 and newer, the DRG-10700 error could point to other potentially missingobjects addressable by running drdefxx.sql such as:- DEFAULT_WORDLIST- DEFAULT_STOPLISTIn 9iR2 and 10gR1, it could also point to:- DEFAULT_POLICY_ORACONTAINSIn 10gR2, it could also point to:- EXTENDED_STOPLISTYour 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 by Rich Murnane at Monday, January 28, 2008 Tags: databases, dba, Oracle, Oracle Text 15 comments: Dan said... Awesome post, Rich! This was exactly what I needed. Thanks! Oct 24, 200
text; text search; text index; ORA-29855; ctxsys Technote (troubleshooting) Problem(Abstract) java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine during execution of updatedb scripts or configdb Cause Database imported from an export of another Oracle database and/or schema Resolving the problem You may receive the following error when running updatedb.bat or configdb.bat on a database that was imported from and export of a different Oracle database and/or schema. java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10700: preference does not exist: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364. You could be getting this error because a schema export will not export the Oracle Text preferences and sub-lexer definitions or the database does not have Oracle Text indexing enabled. 1. Restore the database back to the before the start up updatedb 2. Follow the steps in the following Technote ORA-29855 Error When Running updatedb 3. If updatedb or configdb failed with the same or similar error continue with the following 4. Repeat steps 1 and 2 then, 5. Connect to the database instance specifying AS SYSDBA 6. Create the MDSYS user with a command in the following format: SQL> CREATE USER MDSYS IDENTIFIED BY