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
Recent Comments