R12.1.1 upgrade fails with ORA-29861
Hello,
We are upgrading EBS from 11.2.0.3 to 12.1.3. During the merged patch as part of 12.1.1 upgrade, a worker fails with:
sqlplus -s APPS/***** @/u01/app/oracle/apps/apps_st/appl/zx/12.0.0/patch/115/sql/zxmigratefc.sql
DECLARE
*
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at "APPS.ZX_FC_MIGRATE_PKG", line 3542
ORA-06512: at "APPS.ZX_FC_MIGRATE_PKG", line 5243
ORA-06512: at line 6
I have skipped the worker for now so the patch can continue for now. We will be doing other iterations of this upgrade in future. Is there a fix for this both for my current iteration and future ones?
Tagged:
0