在我们的一个产品中,我们使用ODP.net托管驱动程序使用存储过程从Oracle数据库中检索数据.
每隔一段时间(大约每1000个查询)我们就会得到以下异常:
(ORA-12570: Network Session: Unexpected packet read error) ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-12570: Network Session: Unexpected packet read error ---> OracleInternal.Network.NetworkException: ORA-12570: Network Session: Unexpected packet read error ---> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: size at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags, SocketError& errorCode) at OracleInternal.Network.ReaderStream.ReadIt(OraBuf OB, Int32 len) --- End of inner exception stack trace --- at OracleInternal.Network.ReaderStream.ReadIt(OraBuf OB, Int32 len) at OracleInternal.Network.ReaderStream.WaitForReset() at OracleInternal.Network.OracleCommunication.Reset() at OracleInternal.TTC.TTCExecuteSql.ReceiveExecuteResponse(Accessor[]& defineAccessors, Accessor[] bindAccessors, Boolean bHasReturningParams, SQLMetaData& sqlMetaData, SqlStatementType statementType, Int64 noOfRowsFetchedLastTime, Int32 noOfRowsToFetch, Int32& noOfRowsFetched, Int64& queryId, Int32 longFetchSize, Int32 initialLOBFetchSize, Int64[] scnFromExecution, Boolean& bAllPureInputBinds, DataUnmarshaller& dataUnmarshaller, MarshalBindParameterValueHelper& marshalBindParamsHelper, Boolean bDefineDone, Boolean& bMoreThanOneRowAffectedByDmlWithRetClause) --- End of inner exception stack trace --- at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex) at OracleInternal.TTC.TTCExecuteSql.ReceiveExecuteResponse(Accessor[]& defineAccessors, Accessor[] bindAccessors, Boolean bHasReturningParams, SQLMetaData& sqlMetaData, SqlStatementType statementType, Int64 noOfRowsFetchedLastTime, Int32 noOfRowsToFetch, Int32& noOfRowsFetched, Int64& queryId, Int32 longFetchSize, Int32 initialLOBFetchSize, Int64[] scnFromExecution, Boolean& bAllPureInputBinds, DataUnmarshaller& dataUnmarshaller, MarshalBindParameterValueHelper& marshalBindParamsHelper, Boolean bDefineDone, Boolean& bMoreThanOneRowAffectedByDmlWithRetClause) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int32 lobPrefetchSize, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
似乎ODP.net 使用无效的大小参数(<= 0或大于缓冲区长度减去offset参数的值)调用System.Net.Sockets.Socket.Receive.
该异常不能手动重现,并且在执行具有不同参数的不同过程时(即它是随机的)永远不会引发异常.
配置:ODP.net托管驱动程序版本:4.121.1.0 .net框架4.5 Oracle服务器版本:Oracle数据库11g企业版版本11.2.0.4.0(Linux)
有没有人经历过这个问题?有没有可用的修复程序?
提前致谢!