文档解释 ORA-12520: TNS:listener could not find available handler for requested type of server Cause: None of the known and
ORA-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.
。
ORA-12520: TNS Listener could not find available handler for requested type of server是一个基于oracle数据库的例外错误码,指明数据库监听器没有发现用户所请求服务器类型的可用处理程序。
①确认监听器是否已经运行,在windows操作系统上可以运行“lsnrctl status”命令查看;
②检查TNSNAMES.ORA文件的配置以确保正确的TNS监听器和服务名正确,也就是说可以确保在计算机上安装了正确的Oracle客户端,客户端与服务器是兼容的。
③使用tnsping来检查连接,以确保TNS监听器或客户端/服务器之间的通讯正常。
④重新触发监听器,运行“lsnrctl start”命令启动监听器。
--结束END--
本文标题: ORA-12520: TNS:listener could not find available handler for requested type of server ORACLE 报错 故障修复
本文链接: https://www.lsjlt.com/news/530254.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0