Home » RDBMS Server » Networking and Gateways » Connection timeout with TNS-12571
Connection timeout with TNS-12571 [message #66564] Thu, 01 August 2002 03:12 Go to next message
Mark Tombs
Messages: 5
Registered: August 2002
Junior Member
My net8 connections get disconnected after about 15 mins of inactivity, and I get a ORA-12571 TNS:packet writer failure. The SQLNET.EXPIRE_TIME parameter is not set in the sqlnet.ora file, so I would expect my connections to last forever.

server: Oracle 8.1.7 on SuSE Linux 7.3.
client: NT4 using 8.1.7 client.

Any help appreciated, as this is really winding me up.

thanks

Mark
Re: Connection timeout with TNS-12571 [message #66567 is a reply to message #66564] Sun, 04 August 2002 10:42 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
hi,

i think it will not the problem.in your user profile
they will set the idel time for 15 minutes.net8 connections get disconnected after about 15 mins of inactivity.so increase the idle time for the user profile.

k.sreenivasan
Re: Connection timeout with TNS-12571 [message #66571 is a reply to message #66567] Mon, 05 August 2002 02:59 Go to previous messageGo to next message
Mark Tombs
Messages: 5
Registered: August 2002
Junior Member
Hi,

I've checked the user profile and the idle time value is set to unlimited. I've tried setting it to 60, but I still get disconnected way before that.

thanks

Mark
Re: Connection timeout with TNS-12571 [message #66585 is a reply to message #66564] Thu, 15 August 2002 11:40 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
SQLNET.EXPIRE_TIME is used for Dead Connection Detection and has nothing to do with disconnecting clients. This parameter will kill Oracle server processes that no longer have a client connection. Do you have software installed that disconnects your session if it gets no I/O in 15 minutes?
Re: Connection timeout with TNS-12571 [message #66587 is a reply to message #66564] Thu, 15 August 2002 23:37 Go to previous message
Mark Tombs
Messages: 5
Registered: August 2002
Junior Member
Solved! the database server in question is in a DMZ (behind a firewall) and the firewall was disconnecting me. Thanks for the hint.
Previous Topic: listener log
Next Topic: PL/SQL procedure ending after retreiving n number of rows and not going through the complete table
Goto Forum:
  


Current Time: Thu Feb 29 09:24:51 CST 2024