Exacs database upgrade from 12.1.0.2 to 19c fails with ORA-08103: object no longer exists
Hi Team,
I have been trying to upgrade 12c database on exadata to 19c. However, its fails after completing 44% of the upgrade, with the following error:
*** WARNING: ERRORS FOUND DURING UPGRADE ***
1. Evaluate the errors found in the upgrade logs
and determine the proper action.
2. Rerun the upgrade when the problem is resolved
REASON:
ERRORS FOUND: During Upgrade
FILENAME: /u02/app/oracle/cfgtoollogs/RMSMTR_iad2kx/upgrade/2021-08-20020932/RMSMTR_iad2kx/catupgrd0.log AT LINE NUMBER: 1073428
------------------------------------------------------
Identifier CATALOG 21-08-20 02:13:37
SCRIPT = [/u02/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/c1201000.sql]
ERROR = [ORA-08103: object no longer exists ORA-06512: at line 8
ORA-06512: at line 2
]
STATEMENT = [BEGIN
EXECUTE IMMEDIATE
'ALTER TABLE wri$_optstat_tab_history
DROP (spare2, spare3, spare4, spare5, spare6)';
EXCEPTION
0