Tag Archives: ORA-01653

FAILED: file affurgol.sql on worker 1

Problem: When applying patch, the following error appears:

ATTENTION: All workers either have failed or are waiting:
           FAILED: file affurgol.sql on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checked log file /u0/oracle/testappl/admin/TEST/log/adwork001.log:

declare
*
ERROR at line 1:
ORA-01653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 2362205 in
tablespace APPLSYSD
ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 2380
ORA-06512: at line 55

Solution: Resize the next extent to 40K.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960  1.9351E+10           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE storage (next 40K);
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       40960           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE allocate extent;
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       65536           1         505           50          5