Recently done project encountered a connection to Oracle problem, error title: Ora-12519:tns:no Appropriate service handler found, should be the project some algorithms to all the connections are occupied, there is no way to increase the data connection, The following are the specific practices:
[Plain]View PlainCopy
- select count (*) from v$process --current number of connections
- select value from v$parameter where name = ' processes ' --database maximum number of connections allowed
-   
- Modify Maximum number of connections:
- alter system set processes = 300 scope = spfile;
-
- restart database:
- shutdown immediate;
-
-
- --see which users are currently using 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