国产精品天干天干,亚洲毛片在线,日韩gay小鲜肉啪啪18禁,女同Gay自慰喷水

歡迎光臨散文網(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報錯的評論 (共 條)

分享到微博請遵守國家法律
龙井市| 万载县| 万安县| 青河县| 九龙县| 岐山县| 常宁市| 阳新县| 大洼县| 东莞市| 克山县| 绥江县| 清流县| 新宁县| 天气| 怀安县| 西峡县| 区。| 高邑县| 荔浦县| 洛宁县| 宜宾市| 敦化市| 青田县| 双牌县| 旬阳县| 大同市| 明溪县| 沂源县| 成武县| 南岸区| 九龙坡区| 东乡县| 太原市| 文化| 衡阳县| 马尔康县| 洛隆县| 宝应县| 重庆市| 前郭尔|