I am trying to create an rman catalog and I have a db that will store the catalog. I have a user rman with the connect, recover_catalog_owner, and resource roles; unlimited tablespace system priv. I created a tablespace rcat_ts. I set the rman users default tablespace to be the rcat_ts tblspc. I executed the following command after launching rman:
create catalog tablespace rcat_ts
I get the following error message:
ORACLE error from recovery catalog database: ORA-01031: insufficient privileges
This is a windows 2000 server machine and oracle 9i. Can anyone help me out?