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

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

測試環境做了RMAN還原（從10.2.0.4.0 32bit 還原到 10.2.0.4.0 64bit）後，查詢dba_registry系統視圖時報如下錯誤

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

出現這個問題，只需要執行$ORACLE_HOME/rdbms/admin/prvtcr.plb腳本即可。

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.