Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center