PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.

重建Data Guard遭遇错误 PING[ARC2]: Heartbeat failed to connect to standby 'jzh ddg'. Error is 16032.
主库端archivelog无法传至备库端，主库端报如下错误：
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:45:11 2016
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:51:46 2016
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:52:28 2016
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 14:56:28 2016
PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.
Thu Apr 07 15:02:14 2016
Thread 1 advanced to log sequence 7110 (LGWR switch)
  Current log# 2 seq# 7110 mem# 0: +DATA3/jzhd/redo02.log
Thu Apr 07 15:02:14 2016
Archived Log entry 17363 added for thread 1 sequence 7109 ID 0x68b07be9 dest 1:
Thu Apr 07 15:02:14 2016
FAL[server, ARC3]: Error 16032 creating remote archivelog file 'jzhddg'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance jzhd1 - Archival Error. Archiver continuing.
Thu Apr 07 15:06:46 2016
标红字体显示hearbeat failed，似乎是网络问题，但是tnsping没有问，sqlplus连接也没有问题，参数全检查了都没有问题，于是查看trc文件发现：
*** TRACE FILE RECREATED AFTER BEING REMOVED ***
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
*** 2015-12-14 12:04:06.749 4320 krsh.c
Error 12154 received logging on to the standby
*** 2015-12-14 12:04:06.749 915 krsu.c
Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'jzhddg'
Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'jzhddg'
*** 2015-12-14 12:04:06.749 2932 krsi.c
krsi_dst_fail: dest:2 err:12154 force:0 blast:1
kcrrwkx: unknown error:12154
*** 2015-12-14 13:57:17.587
*** 2015-12-14 13:57:17.587 4645 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!
Standby parameter STANDBY_ARCHIVE_DEST string is invalid at host 'jzhddg'
Error 16032 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'jzhddg'
*** 2015-12-14 13:57:17.592 2932 krsi.c
krsi_dst_fail: dest:2 err:16032 force:0 blast:1
kcrrwkx: unknown error:16032

STANDBY_ARCHIVE_DEST参数在11gR2被废弃掉了，检查备库，确实设置该参数
alter system set STANDBY_ARCHIVE_DEST=''之后，日志传输正常，应用正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10271187/viewspace-2077141/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10271187/viewspace-2077141/