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?
Since the rcat_ts is the rman users default tablespace, you should be able to just run CREATE CATALOG. If this still fails, you may want to specifically grant QUOTA UNLIMITED ON RCAT_TS to the rman user. The rman user shouldn't have to be SYSDBA to create repository.
I get a different error
error occurred in source file: krmk.pc, line: 6779
text of failing SQL statement: ¶ως?
ORACLE error from recovery catalog database: ORA-00955: name is already used by
an existing object
I then tried to create the catalog specifying a diff. tablespace but got the same error.