Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have Oracle10g running on Solaris 10. The configuration of the OS is standard, and there is a packet filter firewall running on the server.

When I run a long query using sqldeveloper, the server reset the connection after 15 minutes of inactivity.

The timeline is:

  1. client establishes the connection to server port 1521, no ssl
  2. server accept and receives the query from the client. the last packet exchanged is a TCP ACK from the server to the client
  3. ... 15 minutes (to the second) pass
  4. server send a RST packet to the client, and nothing else is exchanged between the hosts afterward

I couldn't find any timeout parameter for TNS listener, so I'm guessing it might be a solaris or packet filter issue ?

share|improve this question
    
Do you have packet captures from both the client and server showing that reset? –  becomingwisest Oct 6 '11 at 19:49
    
nope, from the client only –  Julien Vehent Oct 6 '11 at 19:55
    
Then it could be some firewall in between the two systems too. –  becomingwisest Oct 6 '11 at 20:53
    
Correct, that's actually a sonicwall tcp timeout. Found the parameter, thanks for the hint. –  Julien Vehent Oct 6 '11 at 22:15
add comment

1 Answer 1

up vote 1 down vote accepted

The problem was located in a border firewall, a sonicwall, that had a default tcp timeout set at 15 minutes.

Not a solaris or oracle problem then.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.