Skip to Main Content
  • Questions
  • ORA-12571 : TNS packet Writer Failure

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Anees.

Asked: February 04, 2016 - 11:16 am UTC

Last updated: February 05, 2016 - 1:14 am UTC

Version: 12g

Viewed 50K+ times! This question is

You Asked

Dear Mr. Tom

My Client has around 100 users…they frequently get the below problem

ORA-12571 : TNS packet Writer Failure

May I know what is the reason behind this?

Can u please help coming out of this,

Pls help us…

Regards
Anees

and Connor said...

Lots of possible causes here, mostly related to getting information correctly back and forth across the network. Examples include:

- a firewall is getting in the way
- host name resolution failing
- multiple process colliding on the same port number
- somewhere in the infrastructure there is a timeout, so (for example) a network router may drop inactive connections
- anti-virus software (typically includes a software firewall).

You can see where I'm heading - something is stopping us from successfully sending information between the db and the client across sqlnet.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

So how to Trace this end to end

A reader, February 04, 2016 - 3:45 pm UTC

Is there a way to trace this end to end.

Starting from user application session to DB to Os to Network back to the Os --> DB --> application. Or whatever path it takes as part of the complete workflow.

The complete cycle end to end ?

What tools to use ?

Does OEM offer anything or any other combination of tools or scripts ?


Chris Saxon
February 05, 2016 - 1:14 am UTC

Yeah, these kinds of problems are nasty to solve. The network guys will say its the server, the server guys will say its the db, and the db guys will say its the network :-)

Some good info here on how to setup SQL Net trace.

http://juliandyke.com/Diagnostics/Trace/NetTrace.php

Note - the trace files can be verbose !

It may be the best bet to get as much tracing info as you can, then ask for assistance from Support to dig through it.

Hope this helps.