主备库间出现间歇性的ORA-12570报错

cqszpx

于 2022-02-24 17:40:59 发布

阅读量1k

点赞数 1

文章标签： oracle 数据库 dba

本文链接：https://blog.csdn.net/cqszpx/article/details/123117174

版权

本文档针对主备Oracle数据库间出现的ORA-12570错误提供解决方案。错误源于防火墙的最大空闲时间设置可能导致连接在未传输数据时被切断。解决方案是在sqlnet.ora文件中设置SQLNET.EXPIRE_TIME参数，以防止因防火墙的空闲超时导致的连接断开。

摘要由CSDN通过智能技术生成

wall between the two nodes, this document may provide a solution.
Alert log shows
Creating archive destination LOG_ARCHIVE_DEST_4: 'Orcl2'
ARC0: Error 12570 Creating archive log file to 'Orcl2'
Sat Sep 29 00:59:48 2007
Errors in file /Software/Oracle/udump/orcl1_arc0_817588.trc:
ORA-12570: TNS:packet reader failure
Udump trace shows
*** 2007-09-29 00:59:48.452
Error 12570 creating standby archive log file at host 'Orcl2'
*** 2007-09-29 00:59:48.453
ARC0: Error 12570 Creating archive log file to 'Orcl2'
*** 2007-09-29 00:59:48.453
kcrrfail: dest:4 err:12570 force:0
ORA-12570: TNS:packet reader failure
CAUSE
If the firewall has a maximum idle time setting, it may be severing the connection between primary and standby databases if it perceives the connection to be idle. This can happen when one side or the other is busy processing rather than transmitting data