How to Diagnose Components with NON VALID Status in DBA_REGISTRY after an Upgrade

(Doc ID 753041.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


To provide the steps and tools to diagnose components in the DBA_REGISTRY which
are showing status INVALID, LOADED, UPGRADED, NO SCRIPT, OPTION OFF, etc. after an upgrade and
provide possible solutions to resolve these status's.

If the status is shown as REMOVED then this means component is successfully removed.
In case of UPGRADE, the component was not upgraded because it was removed from the database.

For Example:

SQL>  select substr(comp_name,1,30) comp_name, substr(comp_id,1,10) 
      comp_id,substr(version,1,12) version,status from dba_registry;

COMP_NAME                      COMP_ID    VERSION      STATUS
------------------------------ ---------- ------------ -----------
Oracle Enterprise Manager      EM   VALID
Spatial                        SDO    NO_SCRIPT
Oracle interMedia              ORDIM   VALID
OLAP Catalog                   AMD   VALID
Oracle XML Database            XDB   INVALID
Oracle Text                    CONTEXT   VALID
Oracle Expression Filter       EXF   VALID
Oracle Rule Manager            RUL   VALID
Oracle Workspace Manager       OWM   UPGRADED
Oracle Data Mining             ODM   REMOVED
Oracle Database Catalog Views  CATALOG   VALID
Oracle Database Packages and T CATPROC   VALID
JServer JAVA Virtual Machine   JAVAVM   LOADED
Oracle XDK                     XML   VALID
Oracle Database Java Packages  CATJAVA   VALID
OLAP Analytic Workspace        APS   INVALID
Oracle OLAP API                XOQ   VALID
Oracle Real Application Cluster RAC   OPTION OFF


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