-
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:
Code:
set oracle_sid=cma
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|