Ora-12519:tns:no appropriate service handler found resolution

http://java-xp.iteye.com/blog/1682532

Ora-12519:tns:no appropriate service handler found resolution

When the data source is replaced with C3P0, it is found that there is an error ORA-12519 when running multiple tests, and it is suspected that many people run the test at the same time, causing too many connections and not releasing, causing the current number of connections on the database to exceed the maximum value it can handle.


Select COUNT (*) from v$process; --Current number of connections
Select value from v$parameter where name = ' processes '; --Maximum number of connections allowed for the database
To modify the maximum number of connections:
SELECT * from V$license; Query the maximum number of concurrent databases since startup
alter system SET processes = + scope = SPFile;
To restart the database:
Shutdown immediate;
Startup
Can.


--See which users are currently using the data
SELECT Osuser, a.username,cpu_time/executions/1000000| | ' S ', Sql_fulltext,machine
From V$session A, V$sqlarea b
where a.sql_address =b.address order by cpu_time/executions Desc;

Ora-12519:tns:no appropriate service handler found resolution