oracle连接池问题
1、数据来源。
控制台地址:172.30.252.164:7001/console 登陆: weblogic/weblogic#123
数据库jdbc:oracle:thin:@172.30.252.123:1521:pndb smartposdb_test/CDE#4rfv
根据上面的内容可以得到：
（1）数据库类型是oracle.
（2）采用的是java的jdbc的thin瘦方式连接数据库。
（3）数据库服务器的ip和端口分别是172.30.252.123和1521。
（4）数据库SID是pndb。
（5）数据库服务器的用户名和密码分别是smartposdb_test和CDE#4rfv。
（6）控制台地址就是浏览器中的网址，因此在浏览器中直接输入。控制台的用户名和密码分别是weblogic和weblogic#123。
#####################################################################
2、日志如下。
---------------------
2018-07-04T01:42:59.888+0800|INFO |SIGUSR2 handler|c.u.x.d.DyncmicDataSourceBySignal|recive signal Swtich2MainDataSource...|LID=[],ID=[],RID=[]
2018-07-04T01:42:59.888+0800|INFO |SIGUSR2 handler|c.u.x.d.DynamicDataSourceHolder|Switch DataSource from [DBSOURCE2 ] to [DBSOURCE1 ]|LID=[],ID=[],RID=[]
2018-07-04T01:42:59.888+0800|INFO |SIGUSR2 handler|c.u.x.datasource.ApplicationSettings|Switch TRANS_NO_PREFIX to N06|LID=[],ID=[],RID=[]
2018-07-04T01:43:03.667+0800|INFO |tLoopGroup-4-61|com.ums.netty.RequestLogger|收到报文：SockAddr=/10.2.131.5:40351, {"reqDetail":"{\"extBillNo\":\"\",\"appId\":\"\",\"printData\":{\"devBatchNo\":\"201801280001\",\"needPrnUMSAdQr\":true},\"location\":\"116.079335|43.937325\",\"pinblock\":\"\",\"currency\":\"156\",\"amount\":\"000000021600\",\"cardNo\":\"\",\"timestamp\":\"20180704014307\",\"extOrderNo\":\"\",\"serviceCode\":\"82\",\"selfDefined048\":\"504235314132303030303030303220202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020203030303030303033381F5103504F53FF5512313334353232343932383038393435333438FF610133FF42044646464623\",\"extFld01\":{\"0201\":\"2\",\"0301\":\"2\",\"0302\":\"1\",\"0202\":\"1\"},\"transToken\":\"20180704014306069c39ef5a5546aca1d634ff23fb7a19\"}","appInfo":"{\"appName\":\"POS 通\",\"usinNO\":\"guest\",\"tokenWay\":\"1\",\"bizName\":\"消费\",\"packName\":\"com.ums.tss.mastercontrol\",\"bizId\":\"00010008\"}","chnId":"003","mac":"3936393930324239","method":"com.ums.noncard.post.consume","deviceInfo":"{\"prodCode\":\"N900\",\"devSn\":\"N9NL10108327\",\"firmCode\":\"11\"}","version":"3"}|LID=[7b3e628b916840ceab5ec9b7e5e6fadd],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|INFO |ool-4-thread-78|c.u.x.d.DynamicDataSourceHolder|Current DataSource [DBSOURCE1 ]|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|Cannot obtain connection: driverURL = jdbc:weblogic:pool:jdbc/xposp_n2, props = {EmulateTwoPhaseCommit=false, connectionPoolID=jdbc/xposp_n2, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=jdbc/xposp_n2}|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.667+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|Cannot obtain connection: driverURL = jdbc:weblogic:pool:jdbc/xposp_n2, props = {EmulateTwoPhaseCommit=false, connectionPoolID=jdbc/xposp_n2, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=jdbc/xposp_n2}|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.668+0800|ERROR|ool-4-thread-78|c.ums.frame.AbstractExceptionHandler|异常：|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..; nested exception is weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at com.ums.base.dao.hibernate.HibernateGenericDao.findBySql(HibernateGenericDao.java:620)
at com.ums.xposp.device.dao.impl.DeviceDaoImpl.findUnionDeviceBySN(DeviceDaoImpl.java:38)
at com.ums.xposp.device.service.impl.DeviceServiceImpl.findUnionDeivceBySN(DeviceServiceImpl.java:94)
at $Proxy96.findUnionDeivceBySN(Unknown Source)
at com.ums.xposp.tcpservice.XpospProxyServiceAsync.process(XpospProxyServiceAsync.java:117)
at com.ums.frame.filter.LinkedFilterChain.process(LinkedFilterChain.java:24)
at com.ums.frame.filter.JsonConvertFilter.process(JsonConvertFilter.java:88)
at com.ums.frame.filter.LinkedFilterChain.process(LinkedFilterChain.java:24)
at com.ums.netty.NettyInvokeService.processInvoke(NettyInvokeService.java:49)
at com.ums.netty.RequestHandler$1.run(RequestHandler.java:53)
at com.ums.frame.TaskExecutor$1.run(TaskExecutor.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:251)
at weblogic.jdbc.pool.Driver.connect(Driver.java:142)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)
at weblogic.jdbc.jts.Driver.connect(Driver.java:127)
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at net.bull.javamelody.JdbcWrapper$2.invoke(JdbcWrapper.java:681)
at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:282)
at $Proxy102.connect(Unknown Source)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:548)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:513)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:506)
at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:162)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.ums.base.dao.hibernate.HibernateGenericDao$9.doInHibernate(HibernateGenericDao.java:624)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 20 common frames omitted
2018-07-04T01:43:03.669+0800|INFO |ool-4-thread-78|com.ums.netty.NettyExceptionHandler|完成异步业务应答: com.ums.noncard.post.consume, 耗时: 3|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.669+0800|INFO |ool-4-thread-78|com.ums.netty.NettyInvokeService|请求处理结束|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[]
2018-07-04T01:43:03.669+0800|INFO |tLoopGroup-4-61|com.ums.netty.ResponseLogger|应答报文: /10.2.131.5:40351
{"retCode":"9999","retMsg":"系统繁忙，请重试"}|LID=[],ID=[51991472beec46bf85ee4bde95c6ec3d],RID=[087cbf9c6df79f1896147ea51f89bc82459dd2044fd0736be4b33d41ad0e964f]
ces to applications..|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.232+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.232+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|Cannot obtain connection: driverURL = jdbc:weblogic:pool:jdbc/xposp_n2, props = {EmulateTwoPhaseCommit=false, connectionPoolID=jdbc/xposp_n2, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=jdbc/xposp_n2}|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.232+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.232+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.232+0800|WARN |ool-4-thread-78|o.h.util.JDBCExceptionReporter|SQL Error: 0, SQLState: null|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.232+0800|ERROR|ool-4-thread-78|o.h.util.JDBCExceptionReporter|Cannot obtain connection: driverURL = jdbc:weblogic:pool:jdbc/xposp_n2, props = {EmulateTwoPhaseCommit=false, connectionPoolID=jdbc/xposp_n2, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=jdbc/xposp_n2}|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.233+0800|ERROR|ool-4-thread-78|c.ums.frame.AbstractExceptionHandler|异常：|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..; nested exception is weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at com.ums.base.dao.hibernate.HibernateGenericDao.findBySql(HibernateGenericDao.java:620)
at com.ums.xposp.device.dao.impl.DeviceDaoImpl.findUnionDeviceBySN(DeviceDaoImpl.java:38)
at com.ums.xposp.device.service.impl.DeviceServiceImpl.findUnionDeivceBySN(DeviceServiceImpl.java:94)
at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
at $Proxy96.findUnionDeivceBySN(Unknown Source)
at com.ums.xposp.tcpservice.XpospProxyServiceAsync.process(XpospProxyServiceAsync.java:117)
at com.ums.frame.filter.LinkedFilterChain.process(LinkedFilterChain.java:24)
at com.ums.frame.filter.JsonConvertFilter.process(JsonConvertFilter.java:88)
at com.ums.frame.filter.LinkedFilterChain.process(LinkedFilterChain.java:24)
at com.ums.netty.NettyInvokeService.processInvoke(NettyInvokeService.java:49)
at com.ums.netty.RequestHandler$1.run(RequestHandler.java:53)
at com.ums.frame.TaskExecutor$1.run(TaskExecutor.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool jdbc/xposp_n2 is Suspended, cannot allocate resources to applications..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:251)
at weblogic.jdbc.pool.Driver.connect(Driver.java:142)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)
at weblogic.jdbc.jts.Driver.connect(Driver.java:127)
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at net.bull.javamelody.JdbcWrapper$2.invoke(JdbcWrapper.java:681)
at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:282)
at $Proxy102.connect(Unknown Source)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:548)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:513)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:506)
at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:162)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.ums.base.dao.hibernate.HibernateGenericDao$9.doInHibernate(HibernateGenericDao.java:624)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 20 common frames omitted
2018-07-04T01:43:05.233+0800|INFO |ool-4-thread-78|com.ums.netty.NettyExceptionHandler|完成异步业务应答: com.ums.noncard.post.guarantee, 耗时: 1|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.233+0800|INFO |ool-4-thread-78|com.ums.netty.NettyInvokeService|请求处理结束|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[]
2018-07-04T01:43:05.233+0800|INFO |tLoopGroup-4-62|com.ums.netty.ResponseLogger|应答报文: /10.2.131.5:40355
{"retCode":"9999","retMsg":"系统繁忙，请重试"}|LID=[],ID=[aaf7362bad7947efa4ddc85c09746cff],RID=[972cb5f6152437c2e390cdb30e286b740dde28eff38b8995442b78af1299faa4]
##########################################################################
3、问题分析。
4、问题解决。
