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.