当SQL Developer闲置时，我会失去连接 [英] When SQL Developer is idle I lose my connection
问题描述
我的问题是这样的:我正在使用台式机上的VMWare在虚拟机上的Windows 98上运行Oracle 10G.我可以使用SQL Developer(位于我的桌面而不是虚拟机上)连接到多个用户(SYS，HR，OE，...)，但是如果短时间内不运行任何SQL语句，则说大约2分钟后，我失去了连接，并收到错误消息，例如连接已关闭或IO故障:连接被对等方重置.
这与sp_reset_connection有关吗?
当我在虚拟机上打开SQL Plus时，即使它闲置了30分钟或更长时间，我也不会丢失任何连接.所以现在我想在虚拟机和台式计算机之间可能有问题.在此之前一切正常.
我尝试关闭最近安装的反恶意软件应用程序，但没有任何结果. 有人知道我该怎么做才能解决此问题?
亲切的问候， 威克(Veek)
我偶然发现了Keep-alive扩展，并尝试了它，但是没有成功.标准设置为2分钟间隔.我已将此值更改为1并更改为60分钟，但是一旦我停止运行语句一会儿就失去了连接.肯定还有别的东西.我已经安装了最新的SQL Developer版本，但仍然相同. (我确实从早期发行版中导入了设置，也许我不得不尝试不导入它们.) 也许还有其他建议吗?
亲切的问候，
Veek
此扩展适用于SQL Developer 4:
https://github.com/scristalli/SQL-Developer-4-keepalive
免责声明:我是扩展程序的开发人员.我希望答案不被视为广告，因为此扩展程序是开放源代码的(并且以前的非开放源代码扩展程序都可以作为答案).
My problem is this: I am running Oracle 10G on windows 98 on a virtual machine using VMWare on my desktop computer. I can connect to several users (SYS, HR, OE, ... ) with SQL Developer (which is on my desktop not on the virtual machine) but if a don't run any SQL statement for a short while, say about 2 minutes, I lose my connection and get an error like connection closed or IO-fault:connection reset by peer.
Could this have anything to do with the sp_reset_connection?
When I open SQL Plus on my virtual machine itself I don't lose the connection at all, even if it has been idle for 30 minutes or longer. So now I'm thinking there could be a problem between the Virtual Machine and my desktop computer. Before this all worked fine.
I tried closing recently installed anti-malware apps without any result. Anybody has an idea what I could do to fix this problem?
Kind regards, Veek
I stumbled upon the Keep-ALive Extension and tried it as well but without succes. Standard it is set to a 2 minute interval. I've changed this value to 1 and to 60 minutes but as soon as I stop running statements for a short while I lose my connection. There must be something else. I've already installed the newest SQL Developer version but still it is the same. (I did import the settings from my earlier release maybe I have to try without importing them.) Any other suggestions perhaps?
Kind regards,
Veek
This extension works for SQL Developer 4:
https://github.com/scristalli/SQL-Developer-4-keepalive
DISCLAIMER: I'm the developer of the extension. I hope the answer is not considered advertising, because this extension is open source (and the previous non-open-source extensions were accepted as an answer).
这篇关于当SQL Developer闲置时，我会失去连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
