今天有位兄弟，说是碰到TNS-12520 错误，Oracle客户端连接不上，
查找信息：
TNS-12520 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.
看情况有可能Oracle 的process数目达到了设置值
查证：v$session，会话数为144
查看 processes参数：150(默认值)
情况明了
修改processes参数
alter system set processes = 500 scope = spfile
重启系统，问题解决
阅读(1944) | 评论(0) | 转发(0) |
