6 Replies Latest reply on Jul 30, 2013 2:33 PM by joelkallman-Oracle

    APEX 4.2.2 Upgrade Errors

    Rick Weiss

      I am trying to upgrade from 4.0.1 to 4.2.2 on SE 11.2.0.3.5 - ran the apexins.sql fine

      when running @apxldimg, i gave the full path to the images directory

      after learning of my error I tried to rerun the load to the correct path description and got this error string

       

      ERROR at line 1:

      ORA-00604: error occurred at recursive SQL level 1

      ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

      ORA-06512: at "XDB.DBMS_XDB", line 473

      ORA-06512: at line 9

      ORA-06512: at line 37

       

      How do I recover from here, I cannot get the apxldimg script to run

       

      Message was edited by: user8846239 further investigation shows the index affected is SYS.XDB$RESOURCE_CTX_I

        • 2. Re: APEX 4.2.2 Upgrade Errors
          joelkallman-Oracle

          Hi "user8846239",

           

          Quite honestly, it looks like you may have an issue with XDB itself.  When you query the DBA_REGISTRY, what status do you have for the comp_id = 'XDB'?

           

          Joel

          • 3. Re: APEX 4.2.2 Upgrade Errors
            Rick Weiss

            XML

            Oracle XDK

            11.2.0.3.0                    VALID       28-MAY-2013 15:25:33 SERVER                         SYS

            SYS                            XMLVALIDATE

             

             

            XDB

            Oracle XML Database

            11.2.0.3.0                     VALID       28-MAY-2013 15:29:50 SERVER                         SYS

            XDB                            DBMS_REGXDB.VALIDATEXDB

            ANONYMOUS,XS$NULL

            • 4. Re: APEX 4.2.2 Upgrade Errors
              joelkallman-Oracle

              Hi "user8846239",

               

              Interesting result.  I looked in the Support database for any similar types of issues, and while I can't guarantee that this is exactly the same issue, you should examine Doc ID 560202.1 for a similar type of issue.

               

              You may wish to also run the query:

              select owner, index_name, status, domidx_status, domidx_opstatus

              from dba_indexes

              where domidx_opstatus is not null;

              to determine which index in XDB is invalid, which is causing this error.

               

              Joel

              1 person found this helpful
              • 5. Re: APEX 4.2.2 Upgrade Errors
                Rick Weiss

                OWNER                          INDEX_NAME                     STATUS   DOMIDX_STATU DOMIDX

                ------------------------------ ------------------------------ -------- ------------ ------

                XDB                            XDBHI_IDX                      VALID    VALID        VALID

                XDB                            XDB$ACL_XIDX                   VALID    VALID        VALID

                SYS                            XDB$RESOURCE_CTX_I             VALID    VALID        FAILED

                • 6. Re: APEX 4.2.2 Upgrade Errors
                  joelkallman-Oracle

                  Hi "user8846239",

                   

                  Try:

                  alter index xdb.XDB$RESOURCE_CTX_I rebuild;

                  And then try your image load again.


                  Joel