ORA-12519: TNS: noappropriateservicehandlerfound Solution

Recently encountered a connection to Oracle project problem, error such as: ORA-12519: TNS: no appropriate service handler found, it should be some of the project algorithm to all connections are occupied, there is no way to increase data connections. The specific method is as follows:

Select count (*) from v $ process -- current number of connections select value from v $ parameter where name = 'processs' -- maximum number of connections allowed by the database to change the maximum number of connections: alter system set processes = 300 scope = spfile; restart Database: shutdown immediate; startup; -- check which users are currently using data SELECT osuser,. username, cpu_time/executions/1000000 |'s, SQL _fulltext, machine from v $ session a, v $ sqlarea bwhere. SQL _address = B. address order by cpu_time/executions desc;