Oracle错误解决：ORA

来源：懂视网责编：小采时间：2020-11-09 08:02:50

Oracle错误解决：ORA

Oracle错误解决：ORA:问题： java.sql.SQLException : Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handlerfound 解决：超过连接数，所以要扩大。在oracle中执行sql语句 select val

推荐度：

点击下载本文 文档为doc格式

导读Oracle错误解决：ORA:问题： java.sql.SQLException : Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handlerfound 解决：超过连接数，所以要扩大。在oracle中执行sql语句 select val

问题： java.sql.SQLException : Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handlerfound 解决：超过连接数，所以要扩大。在oracle中执行sql语句 select value from v$parameter where name ='proc

问题：java.sql.SQLException: Listener refused the connection with the following error:

ORA-12519, TNS:no appropriate service handlerfound

解决：超过连接数，所以要扩大。在oracle中执行sql语句

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

alter system set processes = 300 scope =spfile; 重新设置连接数

alter system set sessions=335 scope=spfile; 设置SESSIONS = PROCESSES * 1.1 + 5

重启数据库:
shutdown immediate;
startup;

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com