很急手 Io 异常: End of TNS data channel

不禁女色 2011-06-01 03:23:04
请各高手帮忙 服务不定时的老挂，重启就好了。
Io 异常: End of TNS data channel
15:07:25,109 ERROR [STDERR] java.sql.SQLException: Io 异常: End of TNS data channel
15:07:25,109 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
15:07:25,109 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
15:07:25,109 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
15:07:25,109 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:1224)
15:07:25,109 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManage
dConnection.java:429)
15:07:25,109 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:525)
15:07:25,109 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:155)
15:07:25,109 ERROR [STDERR] at com.ddtech.bdingonline.listener.ReplyTask.run(ReplyTask.java:30)
15:07:25,109 ERROR [STDERR] at java.util.TimerThread.mainLoop(Timer.java:512)
15:07:25,109 ERROR [STDERR] at java.util.TimerThread.run(Timer.java:462)
15:07:25,281 INFO [STDOUT] server:RmiJndiInitialContextFactoryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.180.12.70:2680](remote
),objID:[79002359:13048bcfb12:-7ffe, -8407673329275631937]]]]

...全文
760 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
loveofmylife 2011-06-02
  • 打赏
  • 举报
 回复
2L引用的是共享服务器连接所导致的问题，专用服务器就不会有这个问题
让你的DBA去监控一下发生这个问题是数据库的状态吧
不禁女色 2011-06-02
  • 打赏
  • 举报
 回复
严重: Caught exception rolling back connection: java.sql.SQLException: Io 异常: End of TNS data channel
java.sql.SQLException: Io 异常: End of TNS data channel
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1380)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:581)
at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:340)
at groovy.sql.Sql.rollback(Sql.java:1238)
at sun.reflect.GeneratedMethodAccessor619.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)
at com.ddtech.base.GroovyControler.run(GroovyControler.groovy:158)
at com.ddtech.base.DDGroovyControlServlet.doGet(DDGroovyControlServlet.java:27)
at com.ddtech.base.DDGroovyControlServlet.doPost(DDGroovyControlServlet.java:35)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2011-06-02 11:16:33,844 DEBUG [org.jboss.resource.connectionmanager.TxConnectionManager] Unfinished local transaction was rolled back.org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1876db1[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@aa0a07 handles=0 lastUse=1306984496031 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@d04073 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@377f10 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@17877dc txSync=null]
2011-06-02 11:16:33,844 ERROR [STDERR] java.sql.SQLException: Io 异常: End of TNS data channel
2011-06-02 11:16:33,844 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
2011-06-02 11:16:33,844 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
2011-06-02 11:16:33,844 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
2011-06-02 11:16:33,844 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1380)
2011-06-02 11:16:33,844 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:581)
2011-06-02 11:16:33,844 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:340)
2011-06-02 11:16:33,844 ERROR [STDERR] at groovy.sql.Sql.rollback(Sql.java:1238)
2011-06-02 11:16:33,844 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor619.invoke(Unknown Source)
2011-06-02 11:16:33,844 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2011-06-02 11:16:33,844 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
2011-06-02 11:16:33,844 ERROR [STDERR] at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)
2011-06-02 11:16:33,859 ERROR [STDERR] at com.ddtech.base.GroovyControler.run(GroovyControler.groovy:158)
2011-06-02 11:16:33,859 ERROR [STDERR] at com.ddtech.base.DDGroovyControlServlet.doGet(DDGroovyControlServlet.java:27)
2011-06-02 11:16:33,859 ERROR [STDERR] at com.ddtech.base.DDGroovyControlServlet.doPost(DDGroovyControlServlet.java:35)
2011-06-02 11:16:33,859 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
2011-06-02 11:16:33,859 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
2011-06-02 11:16:33,859 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
2011-06-02 11:16:33,875 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
2011-06-02 11:16:33,875 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2011-06-02 11:16:33,875 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
2011-06-02 11:16:33,875 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
2011-06-02 11:16:33,875 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
2011-06-02 11:16:33,875 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
2011-06-02 11:16:33,875 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
不禁女色 2011-06-02
  • 打赏
  • 举报
 回复
我先谢谢大家的帮忙！
不禁女色 2011-06-02
  • 打赏
  • 举报
 回复
Io 异常: End of TNS data channel
有时间刷新页面也会出现这个错误，但在刷新一次又正常了。
不禁女色 2011-06-02
  • 打赏
  • 举报
 回复
是用户多时才会有这错误。
wei_wxx 2011-06-02
  • 打赏
  • 举报
 回复
java.sql.SQLException: Io 异常: End of TNS data channel

提示的是DB的错误。你先去看下DB。
不禁女色 2011-06-02
  • 打赏
  • 举报
 回复
谢谢啊
wohaolou 2011-06-01
  • 打赏
  • 举报
 回复
莫非是有connection没有及时关闭导致服务器内存不够？
_斑驳旳青春 2011-06-01
  • 打赏
  • 举报
 回复
端口换了试试
Oracle 18c rac+dg+13.3的emcc部署配置
1、CentOS 7.3的安装及其基本配置2、18c的rac+单实例的dg的部署3、13.3的EMCC的安装及其使用4、配置DG环境中的无缝切换（同一个TNS当主库挂掉的时候自动切换到备库）
Io 异常: End of TNS data channel; nested exception is java.sql.SQLException: Io
[code="java"] 用dblink 连接的远程库，间隔一段时后执行时报下面错误Io 异常: End of TNS data channel; nested exception is java.sql.SQLException: Io 异常: End of TNS data channel ，如果重启服后务问题就消失（但间隔一段时间还会出现），如不重启每交执行还会接着报 org.spr...
java.sql.SQLException:IO Exception : End of TNS data channel
Error "IO Exception : End of TNS data channel" When Connecting with Multiple ADDRESS_LIST. (Doc ID 750796.1) To Bottom Modified:28-Aug-2012Type:PROBLEMStatus:PUBLIS
oracle共享服务器创建成功后，通过jdbc连接数被限制，报错：java.sql.SQLException: Io 异常: End of TNS data channel解决方法
错误描述：在对oracle进行了共享服务器的配置后，单独一个用户进程通过共享服务器连接到oracle实例没有任何问题！但是通过jdbc依次创建100个oracle实例的连接（业务系统需要）就会报java.sql.SQLException: Io 异常: End of TNS data channel错误，通过写java程序通过jdbc连接的测试，发现circuits参数决定了同时能通过共享服务器的
oracle共享服务器创建成功后，通过jdbc连接数被限制，报错：java.sql.SQLException: Io 异常: End of TNS data channel解决方法...
错误描述：在对oracle进行了共享服务器的配置后，单独一个用户进程通过共享服务器连接到oracle实例没有任何问题！但是通过jdbc依次创建100个oracle实例的连接（业务系统需要）就会报java.sql.SQLException: Io 异常: End of TNS data channel错误，通过写java程序通过jdbc连接的测试，发现circuits参数决定了同时能通过共享服务器的...
Java EE

67,515

社区成员

225,878

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章