oracle经常连接超时—高分
来源:百度知道 编辑:UC知道 时间:2024/06/27 18:02:17
我们都是XP系统,防火墙没开。 逛了好多论坛,相同的问题存在,不过不见答案!
那么久都没有合适的答案,不过我已经自己总结出经验了。
发生这个问题的原因是我们局域网有的电脑装了卡巴,没装卡巴的电脑445攻击装了卡巴的机子,然后装了卡巴的电脑就把攻击方连接屏蔽了,通讯要掉
应该是和Oracle会话设置有关,把oracle补丁打全,完全退出客户端再尝试,希望下面的信息有用:
Setting the Session Time Out
Timing out iSQL*Plus sessions helps to reduce machine load and to maximize resources. The time out interval is set by the session-timeout element. It defines the time a session can be idle before it is expired.
You can edit the web.xml configuration file to change the timeout interval. The web.xml file is located in the directory:
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/WEB-INF
In the web.xml file, search for the <session-timeout> element inside <session-config>. The syntax of the line to change in the configuration file is:
<session-config>
<session-timeout>15</session-timeout>
</session-config>
Where the value is the number of whole minutes of idle time before the session times out. It has a default value of 15 minutes. It can be set to any value from 1 to 1440 minutes.