RMAN Recovery Catalog with July PSU: How to resolve RASCHEMAVER and BASCHEMAVER schema mismatch

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 12.1.0.2
  (April 22, 2016)
• RMAN Catalog Upgrade to Oracle 12.1.0.2
  (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

Explanation

This got caused by a wrong library being shipped wrongly with the July PSU and BP meant for ZDLRA only.

Solution

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.

–Mike