4 Replies Latest reply: Feb 24, 2013 3:49 PM by brunors RSS

    After created a catalog

    brunors
      Hello, I was create a catalog in my enviroment. But, after that a error in the user SYSTEM that is "ORA-01031: insufficient privileges". Any explanation?

      [oracle@dba10g-1 admin]$ rman

      Recovery Manager: Release 10.2.0.1.0 - Production on Tue Feb 12 20:56:16 2013

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

      RMAN> connect catalog rman/rman@orac1

      connected to recovery catalog database

      RMAN> connect target system@orac1

      target database Password:
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      ORA-01031: insufficient privileges




      Kind regard,
      Bruno Reis.

      Edited by: brunors on 12/02/2013 21:05

      Edited by: brunors on 13/02/2013 01:07
        • 1. Re: After create a catalog
          mseberg
          Hello;

          I think your target command might be the reason.

          Instead of this :

          RMAN> connect target system@orac1

          Try this :


          RMAN> connect target /

          I generally don't have a reason to connect with SYSTEM to the catalog. I have a schema owner for it and use that to connect.

          Another thought

          If you are connecting to the TARGET database from the catalog database, you need to provide the username and password of sys user of TARGET database to perform backup operations.

          Best Regards

          mseberg
          • 2. Re: After create a catalog
            L-MachineGun
            You are not only trying to connect to the catalog database as "target", but also using an account without necessary privileges.
            :p
            PS: having the rman catalog in the same database you wish to backup defeats the purpose of an rman catalog for recovery of that database.

            Edited by: L-MachineGun on Feb 12, 2013 7:07 PM
            • 3. Re: After create a catalog
              Hemant K Chitale
              As L-MachineGun points out, the Recovery Catalog should be a separate database from the target database.

              Connecting to the target from RMAN requires an account with the SYSDBA privilege. The SYSTEM account does not, by default, have this privilege. Either use SYS or setup an account with the SYSDBA privilege.


              Hemant K Chitale
              • 4. Re: After created a catalog
                brunors
                Hi, my problem was solved. I ran the backup after that. Thanks for all.

                RMAN> connect target /

                connected to target database: PROD (DBID=219404539)





                RMAN> connect catalog rman/rman@orac1

                connected to recovery catalog database

                Regards, Bruno Reis.