I have configured Active-Passive Oracle Database using Fail Safe between Active and Passive Node. Also successfully configured Data Guard between Active Node to Standby Node.
1. Oracle Database Version: Oracle 11g R2
2. Oracle Fail Safe: 3.4.2
3. OS: Windows Server 2008 R2
Now after fail over the database to Passive node, to check whether the DR is functioning or not, archive logs are not transferring to Standby node. In the Passive Node aler log file error is showing:
"ORA-01031: insufficient privileges
PING[ARC2]: heartbeat failed to connect to standby órcldr´. Error is 1031
Could anyone please let me know the possible reason for this and the resolution.
I'm thinking password file. It needs to be the same copy on all instances.
Did you copy and rename it as needed?
And you need to restart using the correct copy of the password file too.
So a Standby for example must startup on the correct copy of the password file or you will still get the error.
Edited by: mseberg on Nov 14, 2012 9:46 AM