ORA-04063: view "SYS.DBA_REGISTRY" has errors
2015-04-14 14:22 潇湘隐者 阅读(5118) 评论(0) 编辑 收藏 举报
测试环境做了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.
扫描上面二维码关注我
如果你真心觉得文章写得不错,而且对你有所帮助,那就不妨帮忙“推荐"一下,您的“推荐”和”打赏“将是我最大的写作动力!
本文版权归作者所有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接.