Re: Intermittend ORA-12519, TNS:no appropriate service handler found

This info is new, and crucial.
I think you have a problem with your connection pool; it should not connect at a rate of one or more connections per second. Try to change the database setup and create one or more dispatchers.

I have seen *x systems go down to their knees with many connections, especially because most systems take their time to clean up disconnected sessions.
netstat may be of help here - check if you have many waiting (TIME_WAIT). If you do, the rate of connect/disconnect per time unit may be what's causing your troubles. I do not know of a way to speed up the cleanup of disconnected sessions, but that does not mean there isn't - just my lack of knowledge ;).
Anyway - if indicators point towards disconnects/connects you pooling doesn't work, and dispatchers is the way to go.

Regards,
Frank van Bortel Received on Mon Feb 27 2006 - 07:39:30 CST