I am trying to upgrade from 4.0.1 to 4.2.2 on SE 22.214.171.124.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
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
where domidx_opstatus is not null;
to determine which index in XDB is invalid, which is causing this error.