insufficent error when creating an rman catalog

[jayjabour]

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?

[ebrian]

How are you connecting to RMAN?

[vision]

you need connect to the database with sysdba privileges in order to created rman catalog

[jayjabour]

I am connecting to rman like this:
rman catalog rman/pwd@cma
pwd is rman's password and cma is the database that is going to hold the catalog.

[ebrian]

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.

[craigdba]

You need to grant recovery_catalog_owner ( It is something like that) to the rman admin user

[jayjabour]

I have specifically granted unlimited quota on the rcat_ts tablespace, and rman has the recovery_catalog_owner role. I tried just typing in create catalog and get the same error.

[ebrian]

Any luck with doing it like this:

set oracle_sid=cma
rman catalog rman/pwd
RMAN> create catalog;

[jayjabour]

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.

[ebrian]

You may want to try and drop and recreate your rman user.