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