How to Diagnose Components with NON VALID Status in DBA_REGISTRY after an Upgrade (Doc ID 753041.1)

Last updated on OCTOBER 18, 2016

Applies to:

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

Goal

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.

Note:
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         10.2.0.3.0   VALID
Spatial                        SDO        9.2.0.6.0    NO_SCRIPT
Oracle interMedia              ORDIM      10.2.0.3.0   VALID
OLAP Catalog                   AMD        10.2.0.3.0   VALID
Oracle XML Database            XDB        10.2.0.3.0   INVALID
Oracle Text                    CONTEXT    10.2.0.3.0   VALID
Oracle Expression Filter       EXF        10.2.0.3.0   VALID
Oracle Rule Manager            RUL        10.2.0.3.0   VALID
Oracle Workspace Manager       OWM        10.2.0.1.0   UPGRADED
Oracle Data Mining             ODM        10.2.0.3.0   REMOVED
Oracle Database Catalog Views  CATALOG    10.2.0.3.0   VALID
Oracle Database Packages and T CATPROC    10.2.0.3.0   VALID
JServer JAVA Virtual Machine   JAVAVM     10.2.0.3.0   LOADED
Oracle XDK                     XML        10.2.0.3.0   VALID
Oracle Database Java Packages  CATJAVA    10.2.0.3.0   VALID
OLAP Analytic Workspace        APS        10.2.0.3.0   INVALID
Oracle OLAP API                XOQ        10.2.0.3.0   VALID
Oracle Real Application Cluster RAC       10.2.0.3.0   OPTION OFF

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