After 12.2 ADOP Errors with 'ORA-01654: unable to extend index' and the Tablespace is Modified, Reapplying the Same Patch Fails and the Patch is Skipped
Last updated on JULY 06, 2016
Applies to:Oracle Applications DBA - Version 12.2.5 and later
Information in this document applies to any platform.
E-Business Suite 12.2.5 Applications DBA, Issues with the Function of AD Utilities
While applying an NLS Patch (for example <Patch 19676458>) ORA-1654 errors occurred due to space issues.
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:
[WARNING] Skipping patch 19676458_ZHT as it has already been applied.
[WARNING] You can reapply a patch by adding restart=no and abandon=yes
1. Apply an NLS patch similar to <Patch 19676458> and it errors with ORA-1654.
2. Fix ORA-1654 via changes to the tablespace and autoextend.
3. Reapply NLS <Patch 19676458>.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms