连接oracle数据库偶尔超时
服务器 winserver 64 位 oracle11g 64位 rose双机热备
客户端连接数据库服务器,偶尔超时,每天差不多超时 10次左右,每次超时的时间都不固定!
ERROR (2013-05-06 02:41:57,431) WinSrv.QMDBA:0 >> System.Data.OracleClient.OracleException (0x80131938): ORA-12170: TNS: 连接超时
at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at WinSrv.QMDBA.Open()
ERROR (2013-05-06 02:41:57,431) WinSrv.QMDBA:0 >> System.InvalidOperationException: Invalid operation. The connection is closed.
at System.Data.OracleClient.OracleCommand.GetStatementHandle()
at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
at WinSrv.QMDBA.ExecuteNonQuery(String SqlStr)
tnsping 偶尔出现超时!
请问,该情况如何分析,处理??