ORA-12520: TNS: 监听程序无法为请求的服务器类型找到可用的处理程序

问题

oerr ora 12520
12520, 00000, "TNS:listener could not find available handler for requested type of server"
// *Cause: None of the known and available service handlers for requested type 
// of server (dedicated or shared) are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener and that the appropriate handlers are 
// accepting connections. 

排查问题

排查1 - 监听是否正常

lsnrctl services

lsnrctl status 

排查2 - 监听日志

find / -name listener.log
du -sh listener.log

监听器日志文件过大导致该文件无法更新

cat /dev/null > listener.log

排查3 – 系统负载 & 数据库等待事件

top 

uptime 

set line 999
select event,count(*) from gv$session where wait_class<>'Idle' group by  event order by 2;

排查4 – 会话连接情况

select inst_id, count(*) from gv$session group by inst_id;

select inst_id, count(*) from gv$process group by inst_id;

show parameter session

show parameter process