五月天青色头像情侣网名,国产亚洲av片在线观看18女人,黑人巨茎大战俄罗斯美女,扒下她的小内裤打屁股

歡迎光臨散文網(wǎng) 會員登陸 & 注冊

主備庫間出現(xiàn)間歇性的ORA-12570報錯

2022-02-24 17:36 作者:夜灬長夢多  | 我要投稿

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.


主備庫間出現(xiàn)間歇性的ORA-12570報錯的評論 (共 條)

分享到微博請遵守國家法律
汉源县| 宜良县| 无极县| 黑河市| 张家口市| 永春县| 玉林市| 灵丘县| 青州市| 沅陵县| 上林县| 蓝山县| 皋兰县| 乐亭县| 铁岭市| 灵石县| 天峨县| 虞城县| 福建省| 蛟河市| 武邑县| 河南省| 新建县| 陵川县| 原阳县| 桦甸市| 延津县| 剑河县| 弋阳县| 称多县| 和田县| 绥宁县| 南宫市| 屯昌县| 凌海市| 韩城市| 丽水市| 塔城市| 沂南县| 都兰县| 葵青区|