ORA-12519: TNS: no appropriate service handler found Solution

ORA-12519, TNS: no appropriate service handler found
The Connection descriptor used by the client was:
192.168.1.200: 1521: orcl
Solution:
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
 
Modify the maximum number of connections:
Alter system set processses = 300 scope = spfile;
 
Restart the database:
Shutdown immediate;
Startup;
 
-- View 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;
 
Author: ERDP Technical Architecture"