ORA-12571: TNS:packet writer failure

Posts   
 
    
Emme
User
Posts: 1
Joined: 05-Dec-2017
# Posted on: 05-Dec-2017 15:37:26   

Hi, I've got the problem that I run into this exception "ORA-12571: TNS:packet writer failure", when my service process falls back into a large idle time. As I have learned that the firewall is the main problem as it closes the idle database connection after one hour of idle time, the solution I've found in the internet doesn't apply for my specific problem. Solution I've found so far: https://garethhooper.com/2011/12/11/ora-12571-tnspacket-writer-failure-one-of-the-hardest-problems-ive-had-to-resolve/

I can not set the attribute "SQLNET.EXPIRE_TIME" (other processes forbid it, don't ask why), so I need another solution for this problem. Is there any possibility to manually activate the pooled connections for a ping/keepalive signal?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 05-Dec-2017 17:41:10   

Could you explain a bit why this is an LLBLGen Pro specific problem, and if so, what version you're using etc. ? simple_smile Your post solely talks about ODP.NET....

Frans Bouma | Lead developer LLBLGen Pro