This discussion is archived
9 Replies Latest reply: Dec 26, 2012 8:50 PM by Srini Chavali-Oracle RSS

Reinstalling/Repairing Oracle Text in Oracle 11g R2

935884 Newbie
Currently Being Moderated
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
  • 1. Re: Reinstalling/Repairing Oracle Text
    Barbara Boehmer Oracle ACE
    Currently Being Moderated
    You could try running <your_oracle_home_directory>\ctx\admin\catctx.sql from sys.
  • 2. Re: Reinstalling/Repairing Oracle Text
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post database version. Pl see

    Manual installation, deinstallation and verification of Oracle Text 11gR2 [ID 970473.1]     
    Manual installation, deinstallation and verification of Oracle Text 11gR1 [ID 579601.1]     
    Manual Installation, Deinstallation of Oracle Text 10gR2 [ID 979705.1]     

    HTH
    Srini
  • 3. Re: Reinstalling/Repairing Oracle Text in Oracle 11g R2
    935884 Newbie
    Currently Being Moderated
    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
    ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
    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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
  • 4. Re: Reinstalling/Repairing Oracle Text in Oracle 11g R2
    Herald ten Dam Expert
    Currently Being Moderated
    Hi,

    if you looked at the note for 11.2 given before, you had seen there is a second step to load defaults. Run under CTXSYS the next for creating defaults for AMERICA:
    @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";
    Herald ten Dam
    http://htendam.wordpress.com
  • 5. Re: Reinstalling/Repairing Oracle Text in Oracle 11g R2
    935884 Newbie
    Currently Being Moderated
    Now I get this:

    Creating lexer preference...
    begin
    *
    ERROR at line 1:
    ORA-20000: Oracle Text error:
    DRG-10701: preference SYSTEM.DEFAULT_LEXER already exists
    ORA-06512: at "CTXSYS.DRUE", line 160
    ORA-06512: at "CTXSYS.CTX_DDL", line 26
    ORA-06512: at line 2


    Creating wordlist preference...
    begin
    *
    ERROR at line 1:
    ORA-20000: Oracle Text error:
    DRG-10701: preference SYSTEM.DEFAULT_WORDLIST already exists
    ORA-06512: at "CTXSYS.DRUE", line 160
    ORA-06512: at "CTXSYS.CTX_DDL", line 26
    ORA-06512: at line 2


    Creating stoplist...
    begin
    *
    ERROR at line 1:
    ORA-20000: Oracle Text error:
    DRG-12500: stoplist DEFAULT_STOPLIST already exists
    ORA-06512: at "CTXSYS.DRUE", line 160
    ORA-06512: at "CTXSYS.CTX_DDL", line 533
    ORA-06512: at line 2


    begin
    *
    ERROR at line 1:
    ORA-20000: Oracle Text error:
    DRG-12500: stoplist EXTENDED_STOPLIST already exists
    ORA-06512: at "CTXSYS.DRUE", line 160
    ORA-06512: at "CTXSYS.CTX_DDL", line 533


    Maybe I should try uninstalling and then installing Oracle Text, but how do you uninstall Oracle Text?
  • 6. Re: Reinstalling/Repairing Oracle Text in Oracle 11g R2
    Barbara Boehmer Oracle ACE
    Currently Being Moderated
    I would try dropping the defaults from ctxsys:
    begin
      ctx_ddl.drop_preference ('DEFAULT_LEXER');
      ctx_ddl.drop_preference ('DEFAULT_WORDLIST');
      ctx_ddl.drop_stoplist ('DEFAULT_STOPLIST');
      ctx_ddl.drop_stoplist ('EXTENDED_STOPLIST');
    end;
    /
    then re-creating them by running from ctxsys:

    <your_oracle_home_directory>\ctx\admin\defaults\drdefus.sql
  • 7. Re: Reinstalling/Repairing Oracle Text in Oracle 11g R2
    935884 Newbie
    Currently Being Moderated
    I solved this issue by following the instructions in "Manual installation, deinstallation and verification of Oracle Text 11gR2"
  • 8. Re: Reinstalling/Repairing Oracle Text
    user10897714 Newbie
    Currently Being Moderated
    Hi Srini,

    Please can you provide me the link for Manual installation, deinstallation and verification of Oracle Text 11gR2 [ID 970473.1]. I have tried to find link by googling but could not get it.
  • 9. Re: Reinstalling/Repairing Oracle Text
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    The documents are available at Oracle's support site (https://support.oracle.com), access to which is granted to customers with a paid support contract with Oracle. Sharing these documents in any manner is prohibited.

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points