1 Reply Latest reply: Nov 8, 2012 8:33 AM by mseberg RSS

    Standby -> ORA-01031: insufficient privileges

    vk82
      Hi Guru's,


      My OS: RHEL5
      DB Version:11.2.0.1.0

      I am getting the above error when try to create physical standby db using rman duplicate. when trying to connect to auxiliary database using rman getting this error.
      I configured tnsnames.ora & listener.ora file and check tnsping for both it will work. But still i am getting the same error.


      Can anyone please help me out to solve this
        • 1. Re: Standby -> ORA-01031: insufficient privileges
          mseberg
          Hello;

          Its probably a missing password file

          scp the password from the primary to the standby and rename.

          Example
          Password on source is:
          /u01/app/oracle/product/11.2.0.2/orapwRECOVER2
          
          SCP to remote host
          scp /u01/app/oracle/product/11.2.0.2/dbs/orapwRECOVER2 oracle@remote.host.com:/u01/app/oracle/product/11.2.0.2/dbs/
          
          Then rename the file to :
          /u01/app/oracle/product/11.2.0.2/dbs/orapwRECLONE
          http://www.visi.com/~mseberg/duprman2.html


          Also

          select * from v$pwfile_users;

          User running must have sysdba role granted.

          A user from a remote machine can connect to the database as sysdba using password file authentication.

          There are generally two method through which a user can connect to oracle database AS SYSDBA :

          OS authentication
          Password file authentication



          Best Regards

          mseberg