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!
Subscribe to:
Post Comments (Atom)
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!
ReplyDeleteSo 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
Looks like recreating orapwd files on all nodes with ignorecase=y would be an option. However, this involves downtime...
ReplyDeleteRegards,
Martin
Another option might be to copy orapwd from primary instance 1 to primary instance 2 and standby.
ReplyDeleteYes, verified, that works:
ReplyDeletecopy 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!!!