This discussion is archived
11 Replies Latest reply: Mar 7, 2013 6:13 PM by 939686 RSS

Repeatable db connection issue (around 5 minutes) for SQL Developer

939686 Newbie
Currently Being Moderated
While using SQL developer around 5 minutes, I will see the below error message:
"Your database connection has been reset. Any pending transactions or session state has been lost."

Here attached the log from Wireshark showing that the TCP is broken. Please advise any network configuration we should apply to avoid below issue.

Frame 237: 60 bytes on wire (480 bits), 60 bytes captured (480 bits)
Ethernet II, Src: 44:d3:ca:5c:8d:0a (44:d3:ca:5c:8d:0a), Dst: Giga-Byt_25:6b:b8 (6c:f0:49:25:6b:b8)
Internet Protocol Version 4, Src: 10.107.129.32 (10.107.129.32), Dst: 10.13.236.60 (10.13.236.60)
Transmission Control Protocol, Src Port: ncube-lm (1521), Dst Port: 51964 (51964), Seq: 1, Len: 0
Source port: ncube-lm (1521)
Destination port: 51964 (51964)
[Stream index: 0]
Sequence number: 1 (relative sequence number)
Acknowledgement number: Broken TCP. The acknowledge field is nonzero while the ACK flag is not set
Header length: 20 bytes
Flags: 0x04 (RST)
Window size value: 8192
[Calculated window size: 8192]
[Window size scaling factor: -2 (no window scaling used)]
Checksum: 0x4a41 [validation disabled]

No. Time Source Destination Protocol Length Info
238 261.818943 10.107.129.32 10.13.236.60 TCP 60 ncube-lm > 51964 [RST] Seq=1 Win=8192 Len=0

Edited by: 936683 on 2013年3月6日 上午1:37

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points