This discussion is archived
6 Replies Latest reply: Jul 30, 2013 7:33 AM by jkallman RSS

APEX 4.2.2 Upgrade Errors

montanarww Newbie
Currently Being Moderated

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

  • 1. Re: APEX 4.2.2 Upgrade Errors
    montanarww Newbie
    Currently Being Moderated

    bump

  • 2. Re: APEX 4.2.2 Upgrade Errors
    jkallman Employee ACE
    Currently Being Moderated

    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
    montanarww Newbie
    Currently Being Moderated

    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
    jkallman Employee ACE
    Currently Being Moderated

    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

  • 5. Re: APEX 4.2.2 Upgrade Errors
    montanarww Newbie
    Currently Being Moderated

    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
    jkallman Employee ACE
    Currently Being Moderated

    Hi "user8846239",

     

    Try:

    alter index xdb.XDB$RESOURCE_CTX_I rebuild;

    And then try your image load again.


    Joel

Legend

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