Home > Default > Reinstalling/Repairing Oracle Text in Oracle 11g R2

Reinstalling/Repairing Oracle Text in Oracle 11g R2

November 30Hits:0
I happened to execute 'create or replace operator contains...' How do I restore Oracle Text to its previous state?
Edited by: 932881 on May 9, 2012 1:05 AM


Having run '/u01/app/oracle/product/11.2.0/db_1/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK', I tried to create a CTXSYS.CONTEXT index on a VARCHAR2 column but I got this error:
Error at Command Line:1 Column:26
Error report:
SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 160
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause:    Failed to successfully execute the ODCIIndexCreate routine.
*Action:   Check to see if the routine has been coded correctly.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               

Read other 10 answers


Related Articles

  • Error In ReInstalling the Oracle 11g  DatabaseNovember 30

    Hi, I have installed the Oracle 11g before but it was an improper one.I uninstalled it completely by running the Universal Installer and deinstalling the products. After that ,i installed the Oracle 11g again on the system again and while installing

  • Reinstalling/Repairing Oracle Text in Oracle 11g R2November 30

    I happened to execute 'create or replace operator contains...' How do I restore Oracle Text to its previous state? Edited by: 932881 on May 9, 2012 1:05 AMHaving run '/u01/app/oracle/product/11.2.0/db_1/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK'

  • CRS not starting after Oracle 11g Grid was succesuflly installedNovember 30

    Hi: Have 2 node RAC. My Shared storage is on openfiler. Oracle 11g Grid was successfully installed and all the services was working fine. When i restarted the system I found CRS was not coming up. Remaining processes were up and running. Let me expla

  • How to uninstall Oracle 11g Database Options?October 11

    I've come across a problem. A company that developed an application, installed Oracle 11g EE. I guess they would use all default options. Some of them are licensed separately, and are not used. So I need to uninstall them. For example, I see that it

  • Problem when installing Oracle 11g R2 x64 on rhel 5.8 x86_64October 11

    Hi All, I'm trying to install oracle 11g software only to upgrade my database from 10g to 11g and i install all required packages listed in installation prerequisites but the below error appeared error in invoking target 'mkldflags ntcontab.o nnfgt.o


    okay i intalled the 11g edition but quite unsuccesfully . This is the view of start menu entry start->allprograms->oracle 11g express edition->empty Well, it shouldn't be like this ! Can't figure out why ? Edited by: 908289 on Jan 16, 2012 3:52 A

  • Oracle 11g RAC on RHEL 4.0, error on 1 Node while running ./root.sh for CRSOctober 11

    Hi, I am trying to install Oracle 11g RAC on RHEL 4.0 on Vmware and at the end of CRS installation when installer asks to run the two scripts (orainstRoot.sh and root.sh) on one node (on the node where runInstaller is started) throws following error

  • Error while configuring Oracle 11g Forms/Reports Product during istallationOctober 11

    Dears, We are trying to configuring Oracle 11g Forms / Reports during istallation. OS using: Win 7 -- 32 bit RAM: 4 GB We have installed the following modules successfully. Following are the steps which we have followed: 1. Installation of Oracle jdk

  • Windows 7 install of Oracle 11g R2 client hangsOctober 11

    The prior discussion was closed, but I have something to add, so I am opening a new thread.  The prior thread is Oracle 11g install hangs on windows 7 I found that the very final post, by user12924267 was correct and solved the problem for me. The sy

  • Need help setting up DB Link from my Oracle 11g XE to SQL Server.October 11

    Hi, I'm trying to create a DB Link from my Oracle 11g Express Edition in a Windows XP machine to an SQL Server. Here are the steps I've done so far. 1. Created and setup an ODBC Connection for the SQL Server DB. Named it SQLSERVER. Windows Authentica

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.611 s.