ORACLE 12C的CATALOG创建BUG

                       ORACLE 12C的CATALOG创建BUG

     当rman的客户端的数据库是12c的时候，使用以前的版本db创建catalog会报错，
过程如下:

在以前的版本创建用户

SQL> create user test identified by test;

User created.

SQL> grant recovery_catalog_owner to test;

Grant succeeded.

在12C的rman中创建catalog

RMAN>  create catalog;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-07539: insufficient privileges to create or upgrade the catalog schema

即使用test用户给dba权限也不行

RMAN>  create catalog;

recovery catalog created
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-01917: user or role 'RECOVERY_CATALOG_USER' does not exist

报角色或用户不存在

果断上mos一查，发现原来是 bug,可以参考Oracle Support Document 1915561.1 (Upgrade Recovery Catalog fails with RMAN-07539: insufficient privileges).

拷贝12C的ORACLE_HOME/rdbms/admin下的三个文件到catalog database下执行

sqlsessstart.sql
 sqlsessend.sql
sqlsessstart.sql

SQL> @/home/oracle/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.

.................

alter session set "_ORACLE_SCRIPT" = false
                  *
ERROR at line 1:

执行报错，可以不用理会

RMAN> create catalog;

recovery catalog created

再次可以成功创建了.