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 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 12.1.0.2 [Release 9.2 to 12.1]
Information in this document applies to any platform.

***Checked for relevance on 21-Jul-2017***

Goal

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms