Issue# 34:
While applying 12.2.6 RUP patch:
ATTENTION: All workers either have failed or are waiting:
FAILED: file DDR_R_CLNDR_QTR_DN_MV.xdf on worker 1.
FAILED: file MTH_RESOURCE_COST_MV.xdf on worker 2.
FAILED: file ozf_earning_summary_mv.xdf on worker 3.
FAILED: file MSC_PHUB_RESOURCES_MV.xdf on worker 4.
FAILED: file DDR_R_CLNDR_MNTH_DN_MV.xdf on worker 5.
FAILED: file MSC_PHUB_SUPPLIERS_MV.xdf on worker 6.
FAILED: file DDR_R_AOH_LVL_4_ATTR_MV.xdf on worker 7.
FAILED: file MSC_PHUB_PROJECTS_MV.xdf on worker 8.
FAILED: file MTH_SHIFT_REFERENCE_MV.xdf on worker 9.
FAILED: file DDR_BS_INV_SKU_BU_COMBS.xdf on worker 10.
FAILED: file MSC_PHUB_CATEGORIES_MV.xdf on worker 11.
FAILED: file DDR_R_CLNDR_PRD_DRTN_DN_MV.xdf on worker 12.
FAILED: file DDR_R_AOH_LVL_3_ATTR_MV.xdf on worker 13.
FAILED: file DDR_R_AOH_LVL_1_ATTR_MV.xdf on worker 14.
FAILED: file DDR_R_AOH_LVL_2_ATTR_MV.xdf on worker 15.
FAILED: file MTH_EQUIPMENTS_EXT_B_MV.xdf on worker 16.
FAILED: file MRP_COMPANY_USERS_SN.xdf on worker 17.
FAILED: file DDR_R_CLNDR_DAY_DN_MV.xdf on worker 18.
FAILED: file MSC_PHUB_ORGS_MV.xdf on worker 19.
FAILED: file MSC_PHUB_CUSTOMERS_MV.xdf on worker 20.
FAILED: file MSC_PHUB_DATES_MV.xdf on worker 21.
FAILED: file DDR_R_CLNDR_WK_DN_MV.xdf on worker 22.
FAILED: file DDR_R_CLNDR_YR_DN_MV.xdf on worker 23.
FAILED: file MTH_EQUIP_SHIFT_HR_PERF_MV.xdf on worker 24.
FAILED: file MTH_SHIFT_GREGORIAN_DENORM_MV.xdf on worker 25.
FAILED: file MTH_ITEM_COST_MV.xdf on worker 26.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log:
Start time for statement above is Tue Apr 25 00:08:15 AST 2017
Error while writing error logs to DB
Ignoring the error and continuing ...
Turning off logging errors to DB ...
Exception occured ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater
ORA-00722: Feature "Editions"
ORA-06512: at "APPS.AD_MV", line 183
ORA-06512: at "APPS.AD_MV", line 330
ORA-06512: at line 1
Solution:
Stop all workers > adctrl > 3 > all
Change compatibility parameter value:
SQL> sho parameter COMPATIBLE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 11.2.0
noncdb_compatible boolean FALSE
SQL>
SQL> alter system set compatible='12.1.0' scope=spfile;
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 6442450944 bytes
Fixed Size 4511656 bytes
Variable Size 2583693400 bytes
Database Buffers 3841982464 bytes
Redo Buffers 12263424 bytes
Database mounted.
Database opened.
SQL>
- Restart the patch again
No comments:
Post a Comment