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 (Doc ID 2155352.1)

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.

Symptoms

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.

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:

[WARNING] Skipping patch 19676458_ZHT as it has already been applied.
[WARNING] You can reapply a patch by adding restart=no and abandon=yes

STEPS
-----------------------
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>.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms