While applying an NLS Patch getting ORA-1654 errors occurred due to space issues.
Error:
ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX
ORA-01654: unable to extend index APPLSYS.AD_PROGRAM_RUN_TASK_JOBS_N1 by 16 in tablespace APPS_TS_TX_IDX
After fixing the ORA-1654 errors by setting the APPS_TS_TX_IDX datafile to autoextend, reapplying the same NLS patch gives the following warning message and the patch is skipped:
Fix:
1. Resolve the ORA-1654 error per any of the available methods.
2. Test reapplying the patch using following option:
adop phase=apply apply_mode=downtime patches=19676458 options=forceapply restart=no abandon=yes
3. Confirm the patch applied successfully using the above command.
Error:
ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX
ORA-01654: unable to extend index APPLSYS.AD_PROGRAM_RUN_TASK_JOBS_N1 by 16 in tablespace APPS_TS_TX_IDX
After fixing the ORA-1654 errors by setting the APPS_TS_TX_IDX datafile to autoextend, reapplying the same NLS patch gives the following warning message and the patch is skipped:
Fix:
1. Resolve the ORA-1654 error per any of the available methods.
2. Test reapplying the patch using following option:
adop phase=apply apply_mode=downtime patches=19676458 options=forceapply restart=no abandon=yes
3. Confirm the patch applied successfully using the above command.
No comments:
Post a Comment