SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_6VWG4Mar 6 2013 — edited Mar 7 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2013

Added on Mar 6 2013

#connection, #db, #issue, #sql-developer

11 comments

2,780 views