insufficent error when creating an rman catalog
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: insufficent error when creating an rman catalog

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    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?

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    How are you connecting to RMAN?

  3. #3
    Join Date
    May 2006
    Posts
    51
    you need connect to the database with sysdba privileges in order to created rman catalog

  4. #4
    Join Date
    Mar 2005
    Posts
    143
    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.

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    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.

  6. #6
    Join Date
    Feb 2003
    Posts
    63
    You need to grant recovery_catalog_owner ( It is something like that) to the rman admin user

  7. #7
    Join Date
    Mar 2005
    Posts
    143
    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.

  8. #8
    Join Date
    Apr 2006
    Posts
    377
    Any luck with doing it like this:

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

  9. #9
    Join Date
    Mar 2005
    Posts
    143
    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.

  10. #10
    Join Date
    Apr 2006
    Posts
    377
    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
  •  



Click Here to Expand Forum to Full Width