Another “The problem -> the fix” post. 🙂
# KB:
Upgrade Recovery Catalog fails with RMAN-07539: insufficient privileges (Doc ID 1915561.1)
Unpublished Bug 17465689 – RMAN-6443: ERROR UPGRADING RECOVERY CATALOG
# Problem
[oracle@databasesrvr dbs]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 21 14:17:09 2015 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: MYDB (not mounted) RMAN> connect catalog catalog_mydb/catalog_mydb@catalogdb connected to recovery catalog database PL/SQL package CATALOG_MYDB.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is too old RMAN> upgrade catalog RMAN-00571: ========================================================= RMAN-00569: ============== ERROR MESSAGE STACK FOLLOWS ============== RMAN-00571: ========================================================= RMAN-07539: insufficient privileges to create or upgrade the catalog schema RMAN> exit
# Solution
– Connect on the catalog database with the 12c (local) OH:
(and don’t worry about the error on alter session).
[oracle@databasesrvr dbs]$ sqlplus sys/magicpass@catalogdb as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 14:21:02 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @?/rdbms/admin/dbmsrmansys.sql alter session set "_ORACLE_SCRIPT" = true * ERROR at line 1: ORA-02248: invalid option for ALTER SESSION PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. alter session set "_ORACLE_SCRIPT" = false * ERROR at line 1: ORA-02248: invalid option for ALTER SESSION
– Then try to upgrade catalog again:
[oracle@databasesrvr dbs]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 21 14:21:27 2015 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: MYDB (not mounted) RMAN> connect catalog catalog_mydb/catalog_mydb@catalogdb connected to recovery catalog database PL/SQL package CATALOG_MYDB.DBMS_RCVCAT version 11.02.00.03 in RCVCAT database is too old RMAN> upgrade catalog; recovery catalog owner is CATALOG_MYDB enter UPGRADE CATALOG command again to confirm catalog upgrade RMAN> upgrade catalog; recovery catalog upgraded to version 12.01.00.02 DBMS_RCVMAN package upgraded to version 12.01.00.02 DBMS_RCVCAT package upgraded to version 12.01.00.02.
Matheus.