Archiver Failing With Ora-12571: Tns:Packet Writer Failure (文件 ID 1143523.1)

wuweilong發表於2013-08-13
Archiver Failing With Ora-12571: Tns:Packet Writer Failure (文件 ID 1143523.1)轉到底部轉到底部

修改時間:2013-1-1型別:PROBLEM狀態:PUBLISHED優先順序:3
沒有任何註釋註釋 (0)為此文件評級通過電子郵件傳送此文件的連結在新視窗中開啟文件可列印頁

In this Document

Symptoms
Cause
Solution

APPLIES TO:

Oracle Net Services - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked relevance on 31-DEC-2012***

SYMPTOMS

Log shipment between primary and standby machines failing reporting ORA-12571: TNS:packet writer failure

SQL> select dest_id,status,error from v$archive_dest;

DEST_ID STATUS ERROR
-------- --------- -------------------------------------------------------
1 VALID
2 ERROR ORA-12571: TNS:packet writer failure
3 INACTIVE
4 INACTIVE
5 INACTIVE
6 INACTIVE
7 INACTIVE
8 INACTIVE
9 INACTIVE
10 INACTIVE

Alert log shows

Wed Jun 30 13:54:47 2010
Errors in file e:\oradata\orcl\admin\bdump\orcl_arca_4784.trc:
ORA-12571: TNS:packet writer failure

CAUSE

Firewall installed between servers with packet inspection enabled.

SOLUTION

Disabled the packet inspection. Any changes made to Oracle Net packets between send and receive will cause the session to fail.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-768393/,如需轉載,請註明出處,否則將追究法律責任。

相關文章