Repair The Invalid Oracle Packages and Types in dba_registry

i had the problem after i created the new DB or my database has been upgraded from Oracle 11gR2 to Oracle 12c

COMP_NAME                                     STATUS                           VERSION
------------------------------------- -------------------------------- ------------------------------
Oracle Database Catalog Views                 INVALID                          12.1.0.2.0
Oracle Database Packages and Types            INVALID                          12.1.0.2.0

Cause:

1. Applied a patch and after the patch application because of some dependent object status change registry can become invalid
2. Installed a new component and the new component installation got failed then registry components could become invalid
3. catalog.sql or catproc.sql was not successfully ran after database creation. Any of them would have failed somewhere or any of the dependent object got invalid afterward

To repair and validate the invalid 'Packages and Types' component we can execute the catalog and catproc script

SQL> shutdown immediate;
SQL> startup restrict
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql
SQL> SELECT comp_name, status, version FROM dba_registry where STATUS not like 'VALID';

COMP_NAME                                     STATUS                           VERSION
------------------------------------- -------------------------------- ------------------------------
Oracle Database Catalog Views                 VALID                          12.1.0.2.0
Oracle Database Packages and Types            VALID                          12.1.0.2.0

Shutdown your database in the normal mode and startup with the normal mode.

Share :

Tweet

Related Post