Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack

登录
sqlplus / as sysdba

取得进程数的上限
select value from v$parameter where name = 'processes'; 

当前数据库中参数sessions的值
show parameter sessions;


这二者的关系是：sessions=(1.1*processes+5)
alter system set processes=300 scope=spfile;
alter system set sessions=335 scope=spfile;


shutdown immediate;
startup;