11 Replies Latest reply on Mar 8, 2013 2:13 AM by 939686

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

      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: (, Dst: (
      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 TCP 60 ncube-lm > 51964 [RST] Seq=1 Win=8192 Len=0

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