Oracle Upgrade ORA-04063 DBMS_REGISTRY has error

Oracle Upgrade ORA-04063 DBMS_REGISTRY has error

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.

No psu information of 11.2.0.2.8 is 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 view invalidate 8289601 view invalidation
 
05-jun14 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-jun14 01.55.2610947671 pm apply 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 01.55.37.42.1619 pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 01.58.26.752280 pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 01.58.57.774343 pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 02.03.58.934479 pm apply 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 

 

When querying dba_registry, an error is reported:
 
Select * from dba_registry;
 

ORA-04063: package body "SYS. DBMS_REGISTRY_SYS" has errors
 
ORA-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-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-jun14 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-jun14 01.55.2610947671 pm apply 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 01.55.37.42.1619 pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 01.58.26.752280 pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 01.58.57.774343 pm rollback 11.2.0.2 0 PSU Patchset 11.2.0.2.0
 
05-jun14 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 11.2.0.2.8
 
9 rows selected.

OK, psu apply is successful.

--------------------------------------------------------------------------------

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

--------------------------------------------------------------------------------