Problem with ORA-12519, TNS: no appropriate service handler found

ORA-12519, TNS: no appropriate service handler found problem 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 solution: the current number of connections in the Java code database has exceeded the maximum number it can process. 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; www.2cto.com -- view which users are currently using data SELECT osuser,. username, cpu_time/executions/1000000 |'s, SQL _fulltext, machine from v $ session a, v $ sqlarea B where. SQL _address = B. address order by cpu_time/execut Ions desc; Note: If you are prompted that you do not have the shutdown permission, you can use conn/as sysdba dba Java code SQL> conn/as sysdba; connected. SQL> alter system set processes = 300 scope = spfile; the system has been changed. SQL> shutdown immediate; the database has been closed. The database has been detached. The ORACLE routine has been disabled. SQL> startup; the ORACLE routine has been started. Www.2cto.com Total System Global Area 599785472 bytes Fixed Size 1288820 bytes Variable Size 176162188 bytes Database Buffers 419430400 bytes Redo Buffers 2904064 bytes
The database has been loaded. The database has been opened. Author: smartan