On 6 November 2014 05:36, Vasily Kukhta <v.b.kuk...@gmail.com> wrote: > I have received additional details - the application starts getting > "java.sql.SQLException: Listener refused the connection with the following > error: ORA-12519, TNS:no appropriate service handler found", although the > amount of listeners in the DB is large enough. I have some concerns about > the "removeAbandonedTimeout" property, it is set to 5 seconds now. Maybe > the pool abandones every connection after 5 seconds, opens a new > connection, and the previous connection goes to TIME_WAIT status consuming > server resources?
We hit a similar problem 5-6 years ago with Oracle. We found that the pool would close connections from client end successfully. However Oracle has a background thread thread that marks server end connections, and this was a little slow. Until this had closed the connection, and told TNSListener, TNSListener wouldn't allow new connections. Our fix was to increase the number of connections allowed, and the problem went away HTH Chris --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
