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

时间:2023-03-08 20:01:18

测试环境做了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

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

出现这个问题,只需要执行$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.