主库参数

log_archive_dest_2='service=standby lgwr async affirm valid_for=(online_logfiles,primary_role) db_unique_name=standby'

告警日志alert_orcl.log 报错

Error 12170 received logging on to the standby

FAL[server, ARC3]:FAL archive failed,see trace file.

ARCH:FAL archive failed. Archiver continuing

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_nsa2_13032.trc:

ORA-12154: TNS: could not resolve the connect identifier specified

##############################

我在主库用  

sqlplus  sys/oracle@standby  as  sysdba  

登录备库，登录成功。是否说明 standby 这个TNS_NAME 是没有问题的？

然后看D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_nsa2_13032.trc:

OCIServerAttach failed -1

Detailed OCI error val is 12170 and errmsg is 'ORA-12170: TNS:Connect timeout ocurred

Error 12170 received logging on to the standby

Error 12170 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'standby'

Error 12170 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'standby'

Error 12170 for archive log file 3 to 'standby'

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

ORA-12170 :TNS: Connect timeout occurred

Destination is specified with ASYNC=61440

##########################################

看这个tracefile，看不出有用的东西。

老师能否给一个思路，怎么排查这种问题