Database Upgrade ora-04063 DBMS_REGISTRY has error

Source: Internet
Author: User

When upgrading the Oracle database from 11.2.0.1.0 to 11.2.0.2.8, the software upgrade is normal, the instance upgrade is normal, and the psu is upgraded. Run @? /Rdbms/admin/catbundle psu when applying, only part of the information is displayed, that is, terminate apply.
The psu information of 11.2.0.2.8 is not displayed in dba_registry_history; select * from dba_registry_history; ACTION_TIME action namespace version id BUNDLE_SER COMMENTS submit messages ---------- please wait too pm view invalidate 8289601 view invalidation05-JUN-14 overview pm upgrade server 11.2.0.2.0 Upgraded from 11.2.0.1.005-JUN-14 overview pm apply server 11.2.0.2 0 PSU Patchset our-JUN-14 runtime pm apply 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 runtime pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 runtime pm rollback 11.2.0.2 0 PSU Patchset runtime-JUN-14 runtime pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 02.03.58.934479 pm apply 11.2.0.2 0 PSU Patchset 11.2.0.2.0
When querying dba_registry, the following error is reported: select * from dba_registry; ORA-04063: package body "SYS. DBMS_REGISTRY_SYS "has errorsORA-06508: PL/SQL: cocould not find program unit being called:" SYS. DBMS_REGISTRY_SYS "ORA-06512: at line 1
The final problem is located at the failure of the DBMS_REGISTRY_SYS package. You can solve the problem by re-running the prvctl. plb Script: SQL> @? /Rdbms/admin/prvctl. plb re-query dba_registry no longer reports an error, and then re-apply psu: SQL> @? /Rdbms/admin/catbundle. SQL psu applyselect * from dba_registry_history; ACTION_TIME action namespace version id BUNDLE_SER COMMENTS submit messages ---------- please wait too pm view invalidate 8289601 view invalidation05-JUN-14 overview pm upgrade server 11.2.0.2.0 Upgraded from 11.2.0.1.005-JUN-14 overview pm apply server 11.2.0.2 0 PSU Patchset our-JUN-14 runtime pm apply 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 runtime pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 runtime pm rollback 11.2.0.2 0 PSU Patchset runtime-JUN-14 runtime pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 02.03.58.934479 PM applied 11.2.0.2 0 PSU Patchset 11.2.0.2.005-JUN-14 04.40.56.460140 pm apply server 11.2.0.2 8 PSU 11.2.0.2.89 rows selected.
OK, psu apply is successful.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.