This content has been marked as final. Show 7 replies
The password file should be same across all the nodes.
Move and renamed as needed.
On a Standby system you need to cancel recovery and shutdown the database so it starts on the "new" password file.
This error occurs because of the invalid user credentials while attempts to ship redo to standby database .
To solve this issue we have copy the primary password file to standby database and rename the password file. Once the password-file is copied and renamed on standby database then stop and restart the recovery to make password-file in use.
Passwords and Data Guard
Password on source is: /u01/app/oracle/product/18.104.22.168/orapwRECOVER2 SCP to remote host scp /u01/app/oracle/product/22.214.171.124/dbs/orapwRECOVER2 email@example.com:/u01/app/oracle/product/126.96.36.199/dbs/ Then rename the file to : /u01/app/oracle/product/188.8.131.52/dbs/orapwRECLONE
Edited by: mseberg on Nov 8, 2012 10:03 AM
Yes i copied password file from primary to all nodes on standby.
At primary node 1 is shipping logs and is fine.
But coming to nodes 2,3,4 at primary, they are unable to ship logs although all the nodes at standby has password file. So for nodes 2,3,4 to ship logs i copied the same password file from node 1 primary to remaining nodes 2,3,4 of primary. It is working.
1)Now i am in doubt, whether what i did is correct or not? because replacing existing password files in primary nodes 2,,3,4 with node 1 password file.
2)why do i need to copy password files from node 1 in primary to node 2,3,4 in primary. Because i verified all the nodes in primary are using password file and with same sys password. What went wrong with nodes 2,3,4 of primary?
Sorry for the misunderstanding. You don't. Just for the Standby's
why do i need to copy password files from node 1 in primary to node 2,3,4 in primary
Also search for password in this document
Edited by: mseberg on Nov 8, 2012 11:19 AM
I am bit confused... In my case the password files are present in all the nodes of primary and standby. But only node 1 of primary is able to ship logs,where as node 2,3,4 cannot.
So i replaced password files in node 2,3,4 with password file of node 1 at primary. It is working.
Why nodes 2,3,4 were unable to ship logs,although all the nodes at primary have same sys password.
One thing to note that in 11g, it is not enough to set the same password. You need to actually copy the password file itself to the standby machines. At least this was what I found in the last setup I did a few months ago. Very frustrating since in 10g I could just set the password without having to copy the file.