rebuild Data Guard encountered an error
PING[ARC2]: Heartbeat failed to connect to standby ‘jzh
ddg’. Error is 16032.
archivelog in the main library cannot be transferred to the backup library. The main library is reporting the following error:
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 span>
red font displays hearbeat failed, seems to be a network problem, but tnsping didn’t ask, up sqlplus connection is no problem, parameters all checked no problem, then check the TRC files found:
*** 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 749 915 krsu. C Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host ‘JZHDDG ‘Error 12154 749 2932 krsi.c
krsi_dst_fail: dest:2 err: dest: 12154 force:0 blast:1
KCRRWKX: 587*** 2015-12-14 13:57:17.587** 2015-12-14 13:57:17.587 4645 krsu. C
0 1 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 592 2932 krsi.ckrsi_dst_fail: dest:2 err:16032 force:0 blast:1
KCRRWKX: Unknown error:16032
STANDBY_ARCHIVE_DEST
0 alter system set 1
reproduced in: http://blog.itpub.net/10271187/viewspace-2077141/ p>