连接oracle11g报错：ORA-12516 TNS:listener could not find available handler with matching protocol stack

客户端连接oracle11g报错：ORA-12516 TNS:listener could not find available handler with matching protocol stack

解决方法：

1.先查询连接限制数

select value from v$parameter where name = 'processes';

2.查询已经连接

select count(*) from v$process;

3.修改连接数

alter system set processes=500 scope=spfile;

alter system set sessions=555 scope=spfile;

4.重启oralce

注意：上述语句可直接通过安装oracle服务器进入命令：

以sysdba身份登陆PL/SQL
sqlplus / as sysdba;