Java开发网 - [Oracle]Connection reset by peer error

Topic: [Oracle]Connection reset by peer error

1.[Oracle]Connection reset by peer error	Copy to clipboard
Posted by: muziq Posted on: 2003-07-19 13:38 Weblogic Server和pl/sql developer经常会出现这种错误，然后WLS只能重启，PL/SQL只能重连服务器。使用oracle8i服务器。不知道是不是跟oracle的什么设置有关系？还是网络有问题？

2.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: why Posted on: 2003-07-19 21:12 Could you please show us the complete error message? well, I mean what's after "Connection reset by peer error" but before the next line.

3.Re:[Oracle]Connection reset by peer error [Re: why]

Copy to clipboard

Posted by: muziq
Posted on: 2003-08-01 16:51

这几天一直平安无事，知道刚才的那一刻，它终于回来了：


javax.servlet.jsp.JspTagException: Connection reset by peer: socket write error
        at org.apache.taglibs.input.Select.doStartTag(select.java:157)
        at jsp_servlet._jsps._view._wscl.__singleratepayingapply._jspService(__singleratepayingapply.java:274)
        at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
        at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:306)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5445)
        at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:780)
        at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3105)
        at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2588)
        at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:213)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:189)

4.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: runaway Posted on: 2003-08-04 13:56 这是网络连接断掉引起的，一般是由于通过了防火墙，而防火墙一般都会有超时的机制，在网络连接长时间不传输数据时，会切断这个TCP的session，这时就会导致Connection reset by peer error

5.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: muziq Posted on: 2003-08-04 14:57 hi runaway: 那如果应用服务器与数据库服务器都连在一台交换机上就不应该出现这个错误了？

6.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: SimonLei Posted on: 2003-08-04 16:14 客户端或浏览器非正常关闭也会产生这种错误。是不是因为你没有close connection造成的，例如没有在 finally 当中close.

7.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: runaway Posted on: 2003-08-08 09:57 如果应用服务器与数据库服务器都连在一台交换机上,而且直接通信的话，是不会有这种问题的。或者可以采用定时通信的keep alive机制

8.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: muziq Posted on: 2003-08-08 10:18 谢谢各位！

9.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: andy Posted on: 2003-08-19 10:36 我的jboss+mssql也有这个问题。。。到底怎么解决呢？

10.Re:[Oracle]Connection reset by peer error [Re: andy]	Copy to clipboard
Posted by: muziq Posted on: 2003-08-19 10:46 andy wrote: 我的jboss+mssql也有这个问题。。。到底怎么解决呢？把你的错误提示贴出来大家好一起帮你看看

11.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: andy Posted on: 2003-08-19 10:53 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error

12.Re:[Oracle]Connection reset by peer error [Re: muziq]	Copy to clipboard
Posted by: andy Posted on: 2003-08-22 08:00 up