insufficent error when creating an rman catalog
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?
How are you connecting to RMAN?
you need connect to the database with sysdba privileges in order to created rman catalog
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.
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.
You need to grant recovery_catalog_owner ( It is something like that) to the rman admin user
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.
Any luck with doing it like this:
rman catalog rman/pwd
RMAN> create catalog;
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.
You may want to try and drop and recreate your rman user.
Click Here to Expand Forum to Full Width