Related blog posts:
- RMAN Catalog Upgrade fails – ORA-02296 – error creating modify_ts_pdbinc_key_not_null
(April 19, 2016)
- RMAN Catalog requires Enterprise Edition (EE) since Oracle Database 126.96.36.199
(April 22, 2016)
- RMAN Catalog Upgrade to Oracle 188.8.131.52
(August 1, 2014)
Thanks to Ah Huat Tan from Amway IT Services for keeping me updated!
Actually as I see that more people who got hit by this issue so I’d consider it to be worth to write about it.
Problem and Analysis
You’d apply the July 2016 PSU or BP. According to the readme you are required to upgrade your RMAN catalog afterwards. The readme says:
If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it:$ rman catalog username/password@alias RMAN> UPGRADE CATALOG;
I think there’s a second “upgrade catalog” command necessary but I may be wrong.
Anyhow, if you do this after applying the July 2016 PSU or BP you may see the following error:
RMAN> RMAN-06435: recovery catalog owner is CATALOG5 RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade RMAN> RMAN-06444: error creating dbms_rcvcat package body RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06443: error upgrading recovery catalog
When you try now to recompile the package manually you’ll get:
SYS@CATDB> alter package catalog5.DBMS_RCVCAT compile body; Warning: Package Body altered with compilation errors. SYS@CATDB> show error Errors for PACKAGE BODY CATALOG5.DBMS_RCVCAT: LINE/COL ERROR -------- ----------------------------------------------------------------- 11328/12 PL/SQL: Item ignored 11328/12 PLS-00201: identifier 'BASCHEMAVER.VERSION' must be declared 11340/6 PL/SQL: SQL Statement ignored 11342/13 PL/SQL: ORA-00942: table or view does not exist 11345/9 PL/SQL: Statement ignored 11345/9 PLS-00320: the declaration of the type of this expression is incomplete or malformed 11348/3 PL/SQL: Statement ignored 11348/7 PLS-00320: the declaration of the type of this expression is incomplete or malformed 11353/3 PL/SQL: Statement ignored 11353/54 PLS-00320: the declaration of the type of this expression is incomplete or malformed
This got caused by a wrong library being shipped wrongly with the July PSU and BP meant for ZDLRA only.
Please apply patch for Bug 24461826 – RMAN-06443: ERROR UPGRADING RECOVERY CATALOG AFTER APPLYING PATCH. The bug is non-public and therefore not visible.
Sorry for the inconvenience.