Amit's Oracle DBA Blog: How to validate CATALOG and CATPROC

Monday, 7 February 2022

SQL> col comp_id for a10

col version for a11

col status for a10

col comp_name for a37

select comp_id,comp_name,version,status from dba_registry;SQL> SQL> SQL> SQL>

COMP_ID COMP_NAME VERSION STATUS

---------- ------------------------------------- ----------- ----------

CATALOG Oracle Database Catalog Views 19.0.0.0.0 INVALID

CATPROC Oracle Database Packages and Types 19.0.0.0.0 INVALID

RAC Oracle Real Application Clusters LOADING

XDB Oracle XML Database 19.0.0.0.0 LOADED

SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;

PL/SQL procedure successfully completed.

SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATALOG;