Repair INVALID “Oracle Database Packages and Type” in dba_registry – DBUA upgrade error

Following is error screen shot while upgrading database using DBUA.






















To repair and validate “Oracle Database Packages and Types” component you should :
1. log as SYSDBA
$ sqlplus ” / as sysdba”
2. shutdown running database and startup database in upgrade mode
SQL> shutdown immediate;
SQL>startup migrate;
3. run this two scripts (i recommend to spool output into file, so you can see complete output after all)
SQL> spool /tmp/cat_repair.txt
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
catalog.sql will recreate Oracle database Catalog Views component and catproc.sql will recreate Oracle database Packages and Types component
4. Recompile all invalid objects
SQL> @?/rdbms/admin/utlrp.sql
SQL> spool off
5. Shutdown database and startup in open mode
SQL> shutdown immediate;
SQL> startup;
Following is confirmation screen shot