加载中…oracle 连接 异常 Acquisition Attempt Failed!!! Clearing pendi
(2014-07-15 09:23:37)
标签：
cp30minpoolsizemaxpoolsizesessionprocess |
分类： 数据库 |
Java代码 http://www.iteye.com/images/icon_star.png连接 异常 Acquisition Attempt Failed!!! Clearing pendi" />
-
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1429b9f
-- Acquisition Attempt Failed!!! Clearing pending acquires. -
-
While
trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition -
- attempts
(30). Last acquisition attempt exception: -
java.sql.SQLException:
Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647040)(ERR=12519)(ERROR_STACK=(ERROR= -
- (CODE=12519)(EMFI=4))))
-
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) -
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) -
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333) -
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:404) -
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468) -
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) -
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135) -
at com.mchange.v2.c3p0.WrapperConnectionPoolDat aSource.getPooledConnection(WrapperConnectionPoolDat aSource.java:182) -
at com.mchange.v2.c3p0.WrapperConnectionPoolDat aSource.getPooledConnection(WrapperConnectionPoolDat aSource.java:171) -
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool $1PooledConnectionResourc ePoolManager.acquireResource -
- (C3P0PooledConnectionPool
.java:137) -
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) -
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) -
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) -
at com.mchange.v2.async.ThreadPoolAsynchronousRu nner$PoolThread.run(ThreadPoolAsynchronousRu nner.java:547)
Java代码 http://www.iteye.com/images/icon_star.png连接 异常 Acquisition Attempt Failed!!! Clearing pendi" />
-
SQL>
select count(*) from v$process; -
-
COUNT(*) -
----------
-
44 -
-
SQL>
select count(*) from v$session; -
-
COUNT(*) -
----------
-
39
Java代码 http://www.iteye.com/images/icon_star.png连接 异常 Acquisition Attempt Failed!!! Clearing pendi" />
-
alter
system 250set processes= scope=spfile;
后来找来高手分析了一下，修改数据库连接的jdbc.properties中的cpool.maxPoolSize为20.重启之后问题解决。其实修改数据库连接数应该也没有问题，我想应该是没有重启数据库服务的原因吧。写下该文章一方面留一备忘，另外希望大拿指正。
喜欢
0
赠金笔