问题的根源
在使用loadrunner或jmeter压测wcf系统时,有时会出现ORA-12570: 网络会话: 意外的数据包读取错误(odp.net全托管,并开清应用程序连接池)。但是在本机测试不会出现此问题。
问题的根源在于硬件防火墙关闭了TCP连接。
解决方案:
- 更改防火墙配置,牵扯到调整网络结构,此方法一般不可行
- 在连接字符串中添加validate connection=true,此校验会有性能损耗,但是经过压测,在可以控制的范围内。
抓取的错误信息
\ n "ClassName": "System.Exception", \r\ n "Message": "ORA-12570: 网络会话: 意外的数据包读取错误", \r\ n "Data": null, \r\ n "InnerException": {\ r\ n "ClassName": "Oracle.ManagedDataAccess.Client.OracleException", \r\ n "Message": "ORA-12570: 网络会话: 意外的数据包读取错误", \r\ n "Data": null, \r\ n "InnerException": {\ r\ n "ClassName": "OracleInternal.Network.NetworkException", \r\ n "Message": "ORA-12570: 网络会话: 意外的数据包读取错误", \r\ n "Data": null, \r\ n "InnerException": {\ r\ n "NativeErrorCode": 10060, \r\ n "ClassName": "System.Net.Sockets.SocketException", \r\ n "Message": "由于连接方在一段时间后没有正确答复或连接的主机没有反应,连接尝试失败。", \r\ n "Data": null, \r\ n "InnerException": null, \r\ n "HelpURL": null, \r\ n "StackTraceString": " 在 System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)\r\n 在 OracleInternal.Network.ReaderStream.Read(OraBuf OB)", \r\ n "RemoteStackTraceString": null, \r\ n "RemoteStackIndex": 0, \r\ n "ExceptionMethod": "8\nReceive\nSystem, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Net.Sockets.Socket\nInt32 Receive(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags)", \r\ n "HResult": -2147467259, \r\ n "Source": "System", \r\ n "WatsonBuckets": null\ r\ n }, \r\ n "HelpURL": null, \r\ n "StackTraceString": " 在 OracleInternal.Network.ReaderStream.Read(OraBuf OB)\r\n 在 OracleInternal.TTC.OraBufReader.GetDataFromNetwork()\r\n 在 OracleInternal.TTC.OraBufReader.Read(Boolean bIgnoreData)\r\n 在 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)", \r\ n "RemoteStackTraceString": null, \r\ n "RemoteStackIndex": 0, \r\ n "ExceptionMethod": "8\nRead\nOracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342\nOracleInternal.Network.ReaderStream\nInt32 Read(OracleInternal.Network.OraBuf)", \r\ n "HResult": -2147467259, \r\ n "Source": "Oracle.ManagedDataAccess", \r\ n "WatsonBuckets": null\ r\ n }, |