Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN ERROR 01919

677029Dec 23 2008 — edited Nov 15 2011
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2011
Added on Dec 23 2008
16 comments
2,173 views