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
Welcome to the forum! It appears the problem you face is TCP instability; the db connection reset in SQL Developer is just a symptom. Using the latest production release (3.2.20.09.87) will help in that manual Reconnect works much better, but the underlying problem remains.
It is impossible to guess whether you might solve the problem by changing TCP tunable parameters, as here for Oracle Solaris:
or whether you have network hardware issues. I am unsure which Oracle forum may be more appropriate than this one. Probably better to focus on the provider of your network hardware/software. Contact them or search their website.
SQL Developer Team
Edited by: Gary Graham on Mar 6, 2013 11:22 AM
Of course, network hardware includes the NIC inside your PC and any ethernet/coax/wireless router you use to connect.
If you are running the VM under VirtualBox, there is some Tuning TCP/IP stuff here:
But what about the VM guest getting partially paged out of your host's RAM on a periodic basis? Have you considered that? Does your host system have a sufficient margin of RAM above and beyond what the guest is configured to use?
Ah well, so far I have only gotten to play with VM's under VirtualBox. Oracle VM Server (either for x86 or SPARC) has its own forums, of which you may be aware already:
Also, a question on slow tcp/ip data transfer from the x86 forum: Oracle VM 2.2.2 - TCP/IP data transfer is very slow
Probably you will have more success obtaining TCP tuning tips on one of the Virtualization forums. If that is not enough, I would advise following up with Oracle Support.
Sorry for not clarifying. The link on slow TCP was only an example of a search result from that forum.
I very much doubt we are going to be able to blame the repeatable disconnect issue on SQL Developer. I found the following SQL Developer forum threads on disconnects / lost connections, which may not be relevant either: SQLD 3.1EA Closed Connection Bug SQL Developer 3.x Disconnection Problem
The solutions or workarounds in these involve SHARED vs DEDICATED server, disabling JDBC Out-of-Band-Breaks, and even a third-party product that was interfering -- nothing specific to the tool itself. I wonder if your disconnects are reproducible under SQL*Plus.
You may be in uncharted territory and probably have your work cut-out for you.
I am afraid it is not a relevant information to our case as the performance is not slow but a repeatable db disconnect around 5 minutes.
How can anyone else know what might be relevant when you won't provide information ask for that might give us a clue.
Post the details of the OS and memory and software of all of the machines involved.
Sql developer and Oracle VM versions 2 and 3 work just fine for me using OEL5, OEL6, within VirtualBox just about everything I have tried.
Repost the question in one of the VM forums.
That page only lists two of the forums (there are more) but we can't suggest which one is 'relevant' since we have no idea what hardware and software you are using.
Good luck with your problem.
Details of the OS and memory and software of all the machines involved.
SQL developer version 3.2.09, window 7 (32 bits), 4G RAM
Oracle database version 184.108.40.206, OEL 5 (v5.8) OVM 3.1.1, 30G RAM and 8 processers for that VM. Utilization is only 4%
As the issue is TCP broken around 5 minutes, any suggestions for TCP network configuration/firewall setting related to similar case ?
Edited by: 936683 on 2013年3月7日 下午6:12