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.
