Grant is not working for RMAN recovery catalog related objects, after catalog schema upgrade

Apr 24, 2015 6:40AM

Hii,

After upgrading RMAN catalog schema from 11g to 12c without upgrading catalog database RMAN catalog related object grants is not working.

Example :

[oracle@ppv1dv07 ~]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 24 13:23:12 2015

Enter user-name: / as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

sql> create user test identified by test;

sql> grant connect,resource to test;

Grant succeeded.

sql> conn dbschder_1/*****

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Database Administration (MOSC)