Issue# 30:
While applying main upgrade merged patch
ATTENTION: All workers either have failed or are waiting:
FAILED: file czhist.sql on worker 2.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log:
BEGIN FND_STATS.GATHER_COLUMN_STATS('CZ','CZ_DEVL_PROJECTS','DELETED_FLAG'); END;
*
ERROR at line 1:
ORA-20002: Version of statistics table "APPLSYS"."FND_STATTAB" is too old.
Please try upgrading it with dbms_stats.upgrade_stat_table
ORA-06512: at "APPS.FND_STATS", line 667
ORA-06512: at "APPS.FND_STATS", line 3236
ORA-06512: at line 1
Solution:
[ordpro@r12upgdb ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 23 14:24:31 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');
PL/SQL procedure successfully completed.
SQL>
No comments:
Post a Comment