Oracle exceeds database connection (ORA-12519)

Shulou Source: shulou.com Published: 2022-06-01 16:57:56 11月16日 Update

1. Log in using sqlplus, query the current number of connections select count (*) from vprocessors 2, set the maximum number of connections (default is 150) select value from v$parameter where name = 'processes';3, modify the maximum number of connections alter system set processes = 600 scope = spfile; 4, restart the oralce service