oracle dg ora-12154,主库到standby报错解决：Error 12154 received logging on to the standby ORA-12154...

背景：

笔者建库无数，但今天对Oracle 11.2.0.3库使用duplicate新建standby后，主库redo无法通过RFS传输至standby

主库alert.log报错：

Thu Jun 14 14:05:20 2018

Error 12154 received logging on to the standby

主库报错生成trc文件：

*** 2018-06-14 14:25:20.581

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

'

*** 2018-06-14 14:25:20.585 4320 krsh.c

Error 12154 received logging on to the standby

*** 2018-06-14 14:25:20.585 915 krsu.c

Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'agile9dg'

Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'agile9dg'

*** 2018-06-14 14:25:20.585 4320 krsh.c

PING[ARC2]: Heartbeat failed to connect to standby 'agile9dg'. Error is 12154.

*** 2018-06-14 14:25:20.585 2932 krsi.c

krsi_dst_fail: dest:2 err:12154 force:0 blast:1

主库 v$archive_dest

error依旧是 ORA-12154

分析：

ORA-12154此类问题通常为主库通过log_archive_dest_2使用tnsnames.ora中standby TNS文件无法访问到备库导致，但检查：tnsnames.ora，密码文件 ,各参数，防火墙，selinux等设置均正常

问题确实奇怪，查找官方真有相关问题说明： Adding an new Standby fails with error Ora-12154: TNS:could not resolve the connect identifier specified (ID 1240558.1)

具体内