Database Upgrade ora-04063 Dbms_registry has error

Source: Internet
Author: User

when doing an Oracle database upgrade from 11.2.0.1.0 to 11.2.0.2.8, there is no problem with the upgrade of the instance, there is no problem upgrading the PSU. When performing @?/rdbms/admin/catbundle PSU apply, only a subset of the information is displayed, i.e. termination of apply.
The PSU information for 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-------------------------------- -----------------------------------------------------------------------------------05-jun-14 12.50.22.878147 PM & nbsp VIEW INVALIDATE                          8289601   & nbsp        view invalidation05-jun-14 12.50.23.234212 PM   UPGRADE         SERVER     11.2.0.2.0                       upgraded from 11.2. 0.1.005-jun-14 12.50.59.175151 PM   APPLY           SERVER     11.2.0.2   &NB Sp        0 PSU         Patchset 11.2.0.2.005-jun-14 01.55.26.047671 PM   APPLY                 &NBSP ;    11.2.0.2            0 PSU        patchset 11.2.0.2.005-jun- 01.55.37.411219 PM   ROLLBACK                   11.2.0.2   &NBSP ;        0 PSU        patchset 11.2.0.2.005-jun-14 01.58.26.752280 PM   ROLLBAC K                   11.2.0.2            0 PSU & nbsp      patchset 11.2.0.2.005-jun-14 01.58.57.774343 PM   ROLLBACK           &NB Sp       11.2.0.2            0 PSU        patchset 11.2.0.2. 005-jun-14 02.03.58.934479 PM   APPLY                      11. 2.0.2 &NBSp          0 PSU        patchset 11.2.0.2.0
Query Dba_registry Direct error: SELECT * from Dba_registry;ora-04063:package body "SYS. Dbms_registry_sys "had Errorsora-06508:pl/sql:could not the Find program unit being called:" SYS. Dbms_registry_sys "Ora-06512:at Line 1
Finally problem positioning in the Dbms_registry_sys package failure, another run PRVTCR.PLB script can be resolved: SQL>@?/RDBMS/ADMIN/PRVTCR.PLB re-query Dba_registry no longer error, Then again apply Psu:sql>@?/rdbms/admin/catbundle.sql PSU applyselect * from dba_registry_history; Action_time                    action           NAMESPACE  version            id bundle_ser COMMENTS-------------------------------- -----------------------------------------------------------------------------------05-jun-14 12.50.22.878147 PM & nbsp VIEW INVALIDATE                          8289601   & nbsp        view invalidation05-jun-14 12.50.23.234212 PM   UPGRADE         SERVER     11.2.0.2.0                       upgraded from 11.2. 0.1.005-jun-14 12.50.59.175151 PM   APPLY     &nbsp     SERVER     11.2.0.2            0 PSU        PATC Hset 11.2.0.2.005-jun-14 01.55.26.047671 PM   APPLY                   &N Bsp  11.2.0.2            0 PSU        patchset 11.2.0.2.005-jun-14 01.5 5.37.411219 PM   ROLLBACK                   11.2.0.2     &NBSP ;      0 PSU        patchset 11.2.0.2.005-jun-14 01.58.26.752280 PM   ROLLBACK &nbsp ;                 11.2.0.2            0 PSU   &NB Sp    patchset 11.2.0.2.005-jun-14 01.58.57.774343 PM   ROLLBACK             &NB Sp     11.2.0.2            0 PSU        patchset 11.2.0.2.005-jun -02.03.58.934479 PM   APPLY                      11.2.0.2 &N Bsp          0 PSU        patchset 11.2.0.2.005-jun-14 04.40.56.460140 PM   APPLY           SERVER     11.2.0.2            8 PSU &nbs P      PSU 11.2.0.2.89 rows selected.
OK, PSU apply successfully.

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.