weblogic连接池重置（Connection reset）问题解决方案

日期：2020-06-02 栏目：程序人生浏览：次

业务系统在高峰时期报错，需要对weblogic的日志进行分析，查看问题出现的原因以及解决方案。
在weblogic的AdminServer.log中的报错信息如下：

####<2017-8-8 下午07时29分43秒 CST> <Warning> <JDBC> <scyy1> <AdminServer> <pool-4514-thread-165> <<anonymous>> <> <> <1502191783426> <BEA-001129> <Received exception while creating connection for pool "CAMSCORE": IO 错误: Connection reset.>

####<2017-8-8 下午07时29分43秒 CST> <Warning> <JDBC> <scyy1> <AdminServer> <pool-4514-thread-252> <<anonymous>> <> <> <1502191783427> <BEA-001129> <Received exception while creating connection for pool "CAMSCORE": IO 错误: Connection reset.>

####<2017-8-8 下午07时29分43秒 CST> <Warning> <JDBC> <scyy1> <AdminServer> <pool-4514-thread-243> <<anonymous>> <> <> <1502191783428> <BEA-001129> <Received exception while creating connection for pool "CAMSCORE": IO 错误: Connection reset.>

####<2017-8-8 下午07时29分43秒 CST> <Warning> <JDBC> <scyy1> <AdminServer> <pool-4514-thread-55> <<anonymous>> <> <> <1502191783428> <BEA-001129> <Received exception while creating connection for pool "CAMSCORE": IO 错误: Connection reset.>

####<2017-8-8 下午07时29分43秒 CST> <Info> <JDBC> <scyy1> <AdminServer> <pool-4514-thread-55> <<anonymous>> <> <> <1502191783429> <BEA-001156> <Stack trace associated with message 001129 follows:

java.sql.SQLRecoverableException: IO 错误: Connection reset

at Oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:467)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:357)

at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:239)

at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1310)

at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1227)

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:451)

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:343)

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:330)

at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:469)

at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363)

at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)

at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:158)

at weblogic.jdbc.pool.Driver.connect(Driver.java:132)

at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)

at weblogic.jdbc.jts.Driver.connect(Driver.java:127)

at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:533)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)

at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)

at com.bocom.jump.bp.service.sqlmap.support.SqlSessionUtils.getSqlSession(SourceFile:116)

at com.bocom.jump.bp.service.sqlmap.impl.SqlMapImpl.a(SourceFile:56)

at com.bocom.jump.bp.service.sqlmap.impl.SqlMapImpl.a(SourceFile:67)

at com.bocom.jump.bp.service.sqlmap.impl.SqlMapImpl.update(SourceFile:167)

at com.bocom.cams.core.base.commons.BaseDao.update(BaseDao.java:37)

at com.bocom.cams.core.base.commons.PersistableDao.update(PersistableDao.java:46)

at com.bocom.cams.core.base.commons.PersistableService.modify(PersistableService.java:101)

at com.bocom.cams.core.cd.calcandclearinterest.service.InterestCalculateService.interestCalculate(InterestCalculateService.java:499)

at com.bocom.cams.core.cd.calcandclearinterest.service.InterestCalculateService$3.toProcess(InterestCalculateService.java:2241)

at com.bocom.cams.core.base.commons.support.AsynchronousProcessor.run(AsynchronousProcessor.java:65)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:662)

Caused By: java.net.SocketException: Connection reset

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at oracle.net.ns.DataPacket.send(DataPacket.java:210)

at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:230)

at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:312)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:260)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:185)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:102)

at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)

at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)

at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:404)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:385)