Re: TNS problem: ORA-12571

From: Sylvain Leclerc <SLeclerc_at_magrit.com>
Date: Fri, 16 Oct 1998 10:24:58 -0400
Message-ID: <044CD796C702D111B56800608CCC51D0094896@INT_04>

I still get from time to time that type of error (but we're using 7.3.3 on Win NT 4).

I'm copying here an answer I got from Oracle support. Didn't help me much but that's
all Oracle had to offer me.

---

You are getting error tns-12571 intermittently connecting from an application (Oracle's or 3rd party).
12571 TNS:packet writer failure notification appeared in the trace files
1. One suggestion was to search for possible network or network related equipment problems such as a bad router card. Faulty network equipment is likely to cause this error.

2.	EDIT SQLNET.ORA FILE ON THE CLIENT AND SERVER
		Remove the following entry from the
$ORACLE_HOME/NETWORK/ADMIN/SQLNET.ORA file
		on both the client and server:
SQLNET.EXPIRE_TIME=0
3.	Increase the connect_timeout_listener = 300. You can also try
performance tuning on either the router or Token Ring.
4.	This error is caused because the NT interface driver is not

functioning correctly.
The solution is to upgrade to Service Pack 5. This applies to any 32-bit OS.

---

Sylvain Leclerc
sleclerc_at_magrit.com

> -----Original Message-----
> From: Dmitry G. Bezgodov [SMTP:dima_at_profit.maginfo.net]
> Posted At: Friday, October 16, 1998 5:44 AM
> Posted To: server
> Conversation: TNS problem: ORA-12571
> Subject: TNS problem: ORA-12571
>
> I can't connect to RDBMS v 7.3.4 by sqlplus v 8.0.5 for Linux.
> I've got this result :
> ========================
> $ tnsping DB
>
> TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on
> 16-OCT-98
> 15:12:48
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact
> (ADDRESS=(PROTOCOL=TCP)(Host=192.8.200.3)(Port=1521))
> OK (10 msec)
>
> $ sqlplus scott/tiger_at_DB
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Fri Oct 16 15:12:4 1998
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12571: TNS:packet writer failure
>
> =========================
> The connections to RDBMS v 8.0.4 and 8.0.5 are OK.
> I'm sure Linux is not reason of the trouble.
>
> Any ideas?
>
> --
> Regards, Dmitry Bezgodov,
> Profit Research Group, Russia.
> Phones: +7-(3511)-201469,+7-(3511)-200975, Fax: +7-(3511)-213612
> http://profit.maginfo.net
>
>
Received on Fri Oct 16 1998 - 09:24:58 CDT