Issues with DataGuard replication across VPN
Hi,
Both Primary & standby are on Wndows 2008 R2 version 11.2.0.1.0
For over a month we are facing intermittent TNS errors on the primary log. Can't seem to understand why it falls over every 15-20mins.. Any ideas please? The password file has been copied over on numerous times to standby. Can connect & tnsping to PRIM STBY vice versa.
#############################################
Trace file extract...
Redo shipping client performing standby login
*** 2012-08-15 13:02:28.438
OCIServerAttach failed -1
.. Detailed OCI error val is 12170 and errmsg is 'ORA-12170: TNS:Connect timeout occurred
'
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
'
*** 2012-08-15 13:02:29.124 4132 krsh.c
Error 1031 received logging on to the standby
*** 2012-08-15 13:02:29.124 869 krsu.c
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'NAGREPT'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'NAGREPT'
ORA-01031: insufficient privileges
*** 2012-08-15 13:02:29.124 4132 krsh.c
PING[ARCH]: Heartbeat failed to connect to standby 'NAGREPT'. Error is 1031.
*** 2012-08-15 13:02:29.124 2747 krsi.c
krsi_dst_fail: dest:2 err:1031 force:0 blast:1
krsg_ping_by_dest: Assuming there is a gap since ping did not fire