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

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 across the wire.

SOLUTION

If disabling the firewall max idle time setting is not an option, the following workaround may resolve the issue:

Set the following parameter in the sqlnet.ora file that would be referenced by each database, primary and standby. This file is usually found in $ORACLE_HOME/network/admin or $TNS_ADMIN.

SQLNET.EXPIRE_TIME=n

Where n is some number of minutes. Preferably below 10.

e.g.

SQLNET.EXPIRE_TIME=5

When this parameter is enabled, a small 10 byte probe packet will be sent from node to node at specific intervals. In our example, at roughly 5 minute intervals after the timer is armed, the probe packet will be sent until the timer is disarmed. This should prevent an idle time termination by the firewall.

Set this parameter in the sqlnet.ora file on both servers, so any change such as switchover between nodes, ensures the parameter is set for both directions.

出现的原因：1，使用的软件安装过程中遗漏安装文件

2、使用软件与现有软件发生冲突

3、就是电脑内存毁散烂不足，我的电脑有时候使用正常软件就会出现突然d出停止

解决方法：

1、右击计算机-属性(如没有计算机选项，可以让用户在左下角开始-计算机-属性也可)，选择左上方的高级系统设置。

2、选择“高级”，再选择性能栏里的“设置”

3、选择“数据执掘禅行保护”，选择纤漏“为除下列选定程序之外的所有程序和服务启用DEP(U)”，再点击下方的“添加”从硬盘中选中该程序即可。

---