Multiple invalid components in dba_registry

Aug 18, 2017 4:34PM

Environment information: Oracle Database Enterprise edition version: 11.2.0.4.0 Server: Linux x86-64 - Redhat 6.5

Important remarks: No recent patch or upgrade update has been made.

But it was verified that several sys.dbms packages are invalid, I only discovered the problem because sys.dbms_scheduler stopped working.

SQL> select substr(comp_name,1,40) comp_name, schema, status, substr(version,1,10) version from dba_registry order by comp_name;

COMP_NAME SCHEMA STATUS VERSION

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

JServer JAVA Virtual Machine SYS VALID 11.2.0.4.0

OLAP Analytic Workspace SYS INVALID 11.2.0.4.0

OLAP Catalog OLAPSYS VALID 11.2.0.4.0

Oracle Application Express APEX_030200 INVALID 3.2.1.00.1

Oracle Database Catalog Views SYS VALID 11.2.0.4.0

Database Administration (MOSC)