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
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
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.