Re: ORA-12571: TNS:packet writer failure

"Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message news:3dd4f73d.48162894_at_ausnews.austin.ibm.com...

> First time for everything. Yes, it is on the server side. The messages
are in
> the alert log:
>
> Thu Nov 14 15:46:24 2002
> Thread 1 advanced to log sequence 42730
> Current log# 4 seq# 42730 mem# 0: X:\ORAREDO\NPSP\LOG4A.RDO
> Current log# 4 seq# 42730 mem# 1: Y:\ORAREDO\NPSP\LOG4B.RDO
> Thu Nov 14 15:52:51 2002
> Errors in file e:\Oradmin\NPSP\udump\ORA00155.TRC:
> ORA-12571: TNS:packet writer failure
> ORA-02063: preceding line from LN_NMMPDB

Obviously the usual advice to look at the generated trace file applies. IIRC correctly you normally get the ORA-02063: preceding line from LN_NMMPDB when the app is doing a select over a DBlink. If this does turn out to be the case you could see if you get the same or similar errors thru sqlplus run from the server console when you try to connect to the remote database.

I'd agree with others though that it will probably turn out to be network hardware/configuration.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************