Ora-12519,tns:no appropriate service handler found problem exceeds number of connections

Http://www.2cto.com/database/201205/133542.html

ora-12519,tns:no appropriate service handler found issues

Java code  ora-12519, tns:no appropriate service handler found  the Connection descriptor used by the client was:  110.16.1.17:1521:ORCL    www.2cto.com    Solutions:  java code   The current number of connections on the database has exceeded the maximum value it can handle.    select Count (*) from v$process--current number of connections  select value from V$parameter where name = ' processes '--number Maximum number of connections allowed by the library   modify Maximum connections:  alter system set processes = SPFile;     Restart database:  shutdown immediate;  startup;    www.2cto.com    --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/execut Ions desc;    Note: If prompted without shutdown permissions you can use  conn/as sysdba Dba  java code  SQL> conn/as sysdba;   is connected.  SQL> alter system SET processes = + scope = SPFile; The     system has changed.    sql> Shutdown immediate;   database is closed.   has uninstalled the database. The  oracle routine has been closed.    SQL> startup; The  oracle routine has been started.      www.2cto.com  total System Global area  599785472 bytes  fixed Size     &NBSP ;            1288820 bytes  variable Size             17616 2188 bytes  database buffers          419430400 bytes  redo buffers     &NBSP ;          2904064 bytes  
The database is loaded.    The database is already open. Author Smartan

Ora-12519,tns:no appropriate service handler found problem exceeds number of connections