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!