ORA-12519, TNS:no appropriate service handler found数据库连接池问题

雾霾下的精彩 发布于 2012/05/04 10:59
阅读 4K+
收藏 0

tomcat 7.5   连接池  bonecp      系统 windows 7 

总是 报客户端连接间歇性失败  更改   本地配置的 连接池属性设置  也没有多大的改变  想 问一下具体更改哪的设置  可以 彻底解决这个问题

ERROR [BoneCP-pool-watch-thread] - Failed to acquire connection. Sleeping for 7000ms. Attempts left: 2
 java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
 
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:185)
 at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:230)
 at com.jolbox.bonecp.ConnectionHandle.obtainInternalConnection(ConnectionHandle.java:197)
 at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:154)
 at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:121)
 at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:102)
 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: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
 
 at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
 at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
 ... 14 more

加载中
0
wendal
wendal
服务器端的可接纳连接数,少于bonecp中配置的连接数
返回顶部
顶部