This discussion is archived
1 Reply Latest reply: Nov 8, 2012 6:33 AM by mseberg RSS

Standby -> ORA-01031: insufficient privileges

vk82 Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points