Monday, January 10, 2011

Recreating password file using "orapwd" will not work for 11g dataguard on standby database

Using orapwd (Will not work)

[oracle@vmxdb06 ~]$ orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdrorcl password=ora123 force=y ignorecase=no


From: vmxdb05: /u01/app/oracle/diag/rdbms/prorcl/prorcl/trace/prorcl_arc2_4538.trc
*** 2011-01-10 10:25:22.084
Error 3113 detaching RFS from standby instance at host 'drorcl'
krsi_verify_network: Ignoring detach error 3113
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'


From: vmxdb06: /u01/app/oracle/diag/rdbms/drorcl/drorcl/trace/alert_drorcl.log
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[client, ARC0]: Error 16191 connecting to prorcl for fetching gap sequence


Using SCP to copy password from Primary database

[oracle@vmxdb06 dbhome_1]$ scp vmxdb05:$ORACLE_HOME/dbs/orapwprorcl $ORACLE_HOME/dbs/orapwdrorcl
oracle@vmxdb05's password:
orapwprorcl 100% 1536 1.5KB/s 00:00


From: vmxdb05: /u01/app/oracle/diag/rdbms/prorcl/prorcl/trace/prorcl_arc2_4538.trc
*** 2011-01-10 10:34:37.074 2864 krsi.c
krsi_dst_fail: dest:2 err:12528 force:0 blast:1
Redo shipping client performing standby login
*** 2011-01-10 10:34:37.662 4595 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!

4 comments:

  1. I am currently struggling to have this working for RAC, where we have 2 primary instances and a single instance physical standby. when i copy orapwd from primary instance 1 to standby, I get ora-16191 from primary instance 2, when i copy orapwd from primary instance 2 to standby, I get ora-16191 from priamry instance 1!

    So when using RAC primary, copying orapwd is not an option. I am currently working with Support on that issue.

    Regards,
    Martin Decker - OCM11g
    www.ora-solutions.net

    ReplyDelete
  2. Looks like recreating orapwd files on all nodes with ignorecase=y would be an option. However, this involves downtime...

    Regards,
    Martin

    ReplyDelete
  3. Another option might be to copy orapwd from primary instance 1 to primary instance 2 and standby.

    ReplyDelete
  4. Yes, verified, that works:
    copy orapwd from primary instance 1 --> primary instance 2
    copy orapwd from priamry instance 1 --> standby
    Now both RAC primary instances are transmitting archived redo logs successfuly.
    Thanks Decks!!!

    ReplyDelete