Catalog and Catproc - How to find what Objects are keeping them Invalid in the Registry (dba_registry)
(Doc ID 578841.1)
Last updated on JULY 23, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
*** ***
Goal
This note is old, please refer the New Note 759635.1
How to determine what is keeping Catalog and Catproc invalid in the Registry, even though you cannot find any invalid SYS objects in the database.
SQL> select comp_id, status, version from dba_registry;
COMP_ID STATUS VERSION
------------ ----------- --------------
CATALOG INVALID 11.2.0.3.0
CATPROC INVALID 11.2.0.3.0
SQL> select object_name, object_type from dba_objects
2 where owner = 'SYS' and status = 'INVALID';
no rows selected
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |