ORA-04063: view & quot; SYS. DBA_REGISTRY & quot; has errors, databasehaserrors

ORA-04063: view "SYS. DBA_REGISTRY" has errors, databasehaserrors

After RMAN restoration (from 10.2.0.4.0 32bit to 10.2.0.4.0 64bit) is performed in the test environment, the following error is reported when you query the dba_registry System View.

SQL> select  comp_name,version,status from dba_registry;

select  comp_name,version,status from dba_registry

                                      *

ERROR at line 1:

ORA-04063: view "SYS.DBA_REGISTRY" has errors

SQL> select * from v$version;

BANNER

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

Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

In this case, you only need to execute the $ ORACLE_HOME/rdbms/admin/prvctl. plb script.

SQL> $ORACLE_HOME/rdbms/admin/prvtcr.plb 

SQL> col comp_name for a40

SQL> col version for a20

SQL> select  comp_name,version,status from dba_registry;

COMP_NAME                                VERSION              STATUS

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

Oracle Enterprise Manager                10.2.0.4.0           VALID

Spatial                                  10.2.0.1.0           OPTION OFF

Oracle interMedia                        10.2.0.4.0           VALID

OLAP Catalog                             10.2.0.1.0           OPTION OFF

Oracle XML Database                      10.2.0.4.0           VALID

Oracle Text                              10.2.0.4.0           VALID

Oracle Expression Filter                 10.2.0.4.0           VALID

Oracle Rule Manager                      10.2.0.4.0           VALID

Oracle Workspace Manager                 10.2.0.4.3           VALID

Oracle Data Mining                       10.2.0.1.0           OPTION OFF

Oracle Database Catalog Views            10.2.0.4.0           LOADED

COMP_NAME                                VERSION              STATUS

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

Oracle Database Packages and Types       10.2.0.4.0           LOADING

JServer JAVA Virtual Machine             10.2.0.4.0           VALID

Oracle XDK                               10.2.0.4.0           VALID

Oracle Database Java Packages            10.2.0.4.0           VALID

OLAP Analytic Workspace                  10.2.0.1.0           OPTION OFF

Oracle OLAP API                          10.2.0.1.0           OPTION OFF

17 rows selected.