数据库升级ora-04063 DBMS_REGISTRY has error
来源:互联网 发布:陌陌切图软件 编辑:程序博客网 时间:2024/06/06 13:20
在做Oracle数据库从11.2.0.1.0升级到11.2.0.2.8时,软件升级没有问题,实例升级没有问题,升级psu的时候。
运行@?/rdbms/admin/catbundle psu apply时,只显示一部分信息,即终止apply。
在dba_registry_history中未显示11.2.0.2.8的psu信息;
select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS
------------------------------ --------------- ---------- ---------- ---------- ---------- ------------------------------
05-JUN-14 12.50.22.878147 PM VIEW INVALIDATE 8289601 view invalidation
05-JUN-14 12.50.23.234212 PM UPGRADE SERVER 11.2.0.2.0 Upgraded from 11.2.0.1.0
05-JUN-14 12.50.59.175151 PM APPLY SERVER 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.55.26.047671 PM APPLY 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.55.37.411219 PM ROLLBACK 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.58.26.752280 PM ROLLBACK 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.58.57.774343 PM ROLLBACK 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 02.03.58.934479 PM APPLY 11.2.0.2 0 PSU Patchset 11.2.0.2.0
查询dba_registry的时候直接报错:
select * from dba_registry;
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at line 1
最终问题定位在DBMS_REGISTRY_SYS包失效,重新跑一下prvtcr.plb脚本即可解决:
SQL>@?/rdbms/admin/prvtcr.plb
重现查询dba_registry不再报错,接着重新apply psu:
SQL>@?/rdbms/admin/catbundle.sql psu apply
select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS
------------------------------ --------------- ---------- ---------- ---------- ---------- ------------------------------
05-JUN-14 12.50.22.878147 PM VIEW INVALIDATE 8289601 view invalidation
05-JUN-14 12.50.23.234212 PM UPGRADE SERVER 11.2.0.2.0 Upgraded from 11.2.0.1.0
05-JUN-14 12.50.59.175151 PM APPLY SERVER 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.55.26.047671 PM APPLY 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.55.37.411219 PM ROLLBACK 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.58.26.752280 PM ROLLBACK 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 01.58.57.774343 PM ROLLBACK 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 02.03.58.934479 PM APPLY 11.2.0.2 0 PSU Patchset 11.2.0.2.0
05-JUN-14 04.40.56.460140 PM APPLY SERVER 11.2.0.2 8 PSU PSU 11.2.0.2.8
9 rows selected.
OK ,psu apply成功。
0 1
- 数据库升级ora-04063 DBMS_REGISTRY has error
- Oracle10gRAC error:'ora.o10n1.LISTENER_O10N1.lsnr' has placement error.
- CRS-0223: Resource 'ora.devdb.devdb1.inst' has placement error.
- CRS-0223: Resource 'ora.devdb.devdb1.inst' has placement error.
- Error: ORA-04062: timestamp of procedure has been changed
- CRS-0223: Resource 'ora.host2.gsd' has placement error.
- ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)解决办法
- 升级数据库报ORA-01092错误
- ORA-04063: view "GFMIS.UNIFYLOGIN" has errors
- ORA-04063: ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors
- ora-28001 the password has expired......oracle11g数据库密码过期
- oracle数据库错误ORA-00257:archiver error.
- Oracle 11g RAC 补丁升级时报ORA-01565: error in identifying spfileprod.ora 错误处理
- Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been det
- 连接oracle 11g出错error:ORA-28001:the password has expired;
- DataPump Export (EXPDP) Error ORA-39095 Dump File Space Has Been Exhausted [ID 559692.1]
- oracle11G EM ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
- Oracle数据库升级后报ORA-00704和ORA-39700错误
- Android Notification使用系统通知栏布局出现的图标问题
- 数据库注意点
- Google字体库引起的首页加载缓慢的解决方法
- Reader类的读取方式和IOException处理
- 【正则表达式】C#正则表达式提取HTML中IMG标签的URL地址
- 数据库升级ora-04063 DBMS_REGISTRY has error
- 第四十七题(求最长递减子序列)
- Oracle 11.2.0.3.0 psu 11.2.0.3.9 in aix
- 【阿里大数据】S1
- Oracle 8.1.7.4 数据库故障恢复一例
- java数据类型及运算符、结构控制
- Building a LAMP Server
- cocos2d-x 3.0 Android编译环境的搭建win7+Eclipse
- 通过MyEclipse生成Hibernate类文件和hbm.xml文件,或者annotation文件