日期:2014-05-17  浏览次数:20884 次

ORA-03135: 连接失去联系 的问题
ASP.NET写的程序,oracle9的数据库,用的oracle的链接工具,测试了两个服务器,服务器环境都差不多,但是同样的程序,在一台上过一段时间刷新就会显示:

Server Error in '/' Application.
--------------------------------------------

ORA-03135: 连接失去联系 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Oracle.DataAccess.Client.OracleException: ORA-03135: 连接失去联系

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[OracleException: ORA-03135: 连接失去联系]
  Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure) +969
  Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src) +21
  Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) +3637
  Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +231
  System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
  DCHL_WEBSITE.index.ListBind() in D:\Work_Web\DCHL_WEBSITE\DCHL_WEBSITE\index.aspx.cs:40
  DCHL_WEBSITE.index.Page_Load(Object sender, EventArgs e) in D:\Work_Web\DCHL_WEBSITE\DCHL_WEBSITE\index.aspx.cs:24
  System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
  System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
  System.Web.UI.Control.OnLoad(EventArgs e) +99
  System.Web.UI.Control.LoadRecursive() +47
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

 
另一台服务器上的就没问题。

请问怎么解决

------解决方案--------------------
这么奇怪 我也没遇见过 帮顶