RMAN ERROR 01919
677029Dec 23 2008 — edited Nov 15 2011I am trying to create a RMAN catalog and it throws me an error 01919: role 'RECOVERY_CATALOG_OWNER' does not exist.Am i doing anything wrong here.
SQL> CREATE TABLESPACE RMAN
2 DATAFILE
3 'E:\TIMEDB\DATA\RMAN.dbf'
4 SIZE 100M
5 AUTOEXTEND ON
6 ;
Tablespace created.
SQL> CREATE USER RMAN IDENTIFIED BY RMAN
2 DEFAULT TABLESPACE RMAN
3 TEMPORARY TABLESPACE TEMP
4 QUOTA UNLIMITED ON RMAN;
User created.
SQL> GRANT CONNECT,RESOURCE,RECOVERY_CATALOG_OWNER TO RMAN;
GRANT CONNECT,RESOURCE,RECOVERY_CATALOG_OWNER TO RMAN
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist
SQL> GRANT CONNECT,RESOURCE TO RMAN;
Grant succeeded.
SQL> GRANT RECOVERY_CATALOG_OWNER TO RMAN;
GRANT RECOVERY_CATALOG_OWNER TO RMAN
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist
SQL> SHO USER
USER is "SYS"
SQL> GRANT recovery_catalog_owner to RMAN;
GRANT recovery_catalog_owner to RMAN
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist
SQL> grant CREATE TYPE TO RMAN;
Grant succeeded.
SQL> GRANT recovery_catalog_owner to RMAN;
GRANT recovery_catalog_owner to RMAN
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist
SQL>
Any help is appreciated.Thanks