9 Replies Latest reply: Dec 26, 2012 2:50 PM by Srini Chavali-Oracle RSS

    Reinstalling/Repairing Oracle Text in Oracle 11g R2

    935884
      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
          You could try running <your_oracle_home_directory>\ctx\admin\catctx.sql from sys.
          • 2. Re: Reinstalling/Repairing Oracle Text
            Srini Chavali-Oracle
            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
              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
                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
                  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
                    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
                      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
                        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
                          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