本文介绍了ORA-03113:ASP.Net应用中长时间不活动后,通信通道上的文件结束的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经使用ODAC/ODP.Net驱动程序的10.1.0.301版在IIS5上实现了负载平衡(不使用会话状态)ASP.Net 2.0应用程序,该应用程序运行回单个Oracle 10g服务器.长时间不活动(几个小时)后,看似随机的应用程序将引发Oracle异常:

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g server, using version 10.1.0.301 of the ODAC/ODP.Net drivers. After a long period of inactivity (a few hours), the application, seemingly randomly, will throw an Oracle exception:

...堆栈的Oracle部分到此结束...

...Oracle portion of the stack ends here...

我们将根据每个请求创建新的连接,并打开& close包裹在try/catch/finally中,以确保正确关闭连接,整个内容包裹在using(OracleConnection yadayada){...}块中.由于不活动而被分解后,此问题似乎没有链接到ASP.Net应用程序的重新启动.

We are creating new connections on every request, have the open & close wrapped in a try/catch/finally to ensure proper connection closure, and the whole thing is wrapped in a using (OracleConnection yadayada) {...} block. This problem does not appear linked to the restart of the ASP.Net application after being spun down for inactivity.

我们还没有自己重现问题.有想法,祈祷,有帮助吗?

We have yet to reproduce the problem ourselves. Thoughts, prayers, help?

更多:经过IT的检查,防火墙未设置为杀死这些服务器之间的连接.

More: Checked with IT, the firewall isn't set to kill connections between those servers.

推荐答案

该数据库是否在通知您不再存在网络连接.这可能是因为:

Is the database letting you know that the network connection is no more. This could be because:

  1. 网络问题-连接错误或防火墙问题
  2. 为您提供服务的数据库服务器进程意外死亡.

对于1)(防火墙),在tahiti.oracle.com中搜索SQLNET.EXPIRE_TIME.这是一个sqlnet.ora参数,它将以可配置的时间间隔定期发送网络数据包,即:设置此参数将使防火墙认为该连接处于活动状态.

For 1) (firewall) search tahiti.oracle.com for SQLNET.EXPIRE_TIME. This is a sqlnet.ora parameter that will regularly send a network packet at a configurable interval ie: setting this will make the firewall believe that the connection is live.

对于1)(网络)与您的网络管理员交谈(连接可能不可靠)

For 1) (network) speak to your network admin (connection could be unreliable)

对于2)检查alert.log是否有错误.如果服务器进程失败,将出现错误消息.此外,还将编写跟踪文件以使支持人员能够识别问题.错误消息将引用跟踪文件.

For 2) Check the alert.log for errors. If the server process failed there will be an error message. Also a trace file will have been written to enable support to identify the issue. The error message will reference the trace file.

支持问题

这篇关于ORA-03113:ASP.Net应用中长时间不活动后,通信通道上的文件结束的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-23 12:55
查看更多