2 dswhope1985 dswhope1985 于 2014.05.27 16:24 提问

ORA-12516, TNS: listener could not find available

项目启动后几秒种就报该异常。

ORA-12516, TNS: listener could not find available handler with matching protocol stack'

SQL> show parameter processes;

NAME TYPE VALUE


aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150

我查了下资料,网上说是processes问题,我查了下数据库的processes信息,但不知道如何解决。

1个回答

u014530814
u014530814   Rxr 2014.08.22 19:13

通过命令行登陆SQLPLUS修改
sqlplus /nolog
SQL> conn / as sysdba
SQL> show parameter processes;
SQL> alter system set processes=600 scope=spfile;

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!
其他相关推荐
RAC 中 ORA-12516: TNS: listener could not find available handler with matching protocol stack
现象在DB上执行sqlplus apps/apps正常,如果执行sqlplus apps/apps@prod1 就会出现ORA-12516的错误。   SQLNet.log中的日志: Fatal NI connect error 12516, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=compardrac1)(POR
ora-12516 tns listener could not find available handler with matching protocol
      今天EPP(Enterprise Product Protal)系统间客户端连线出现如题ORA-12516错误.      根据其需求,首先确认服务器端监听器和DB并没有问题后,即判断为客户端连接问题;其二,查找ORA-12516错误引起的原因,发现为Processes数量导致,Oacle的sessions和processes的关系是sessions=1.1*processes +
ORA-12516, TNS: listener could not find available handler with matching protocol stack'
Error: 'Oracle XE: ORA-12516, TNS: listener could not find available handler with matching protocol stack' When Running the RunETL Process [ID 1100982.1]   修改时间 28-DEC-2011     类型 PROB
ORA-12520: TNS:listener could not find available handler
https://community.oracle.com/thread/2534525
TNS:listener could not find available handler with matching protocol stack
在Java连接数据库时出现以下问题: ORA-12516:TNS:listener could not find available handler with matching protocol stack 原因:可能是连接的会话过多(也就是多次打开connection) 解决方法,就是在Java中减少连接的次数
Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack
出现错误场景:通常是由于很多人连接数据库,导致连接数(session)数量超出限制。 解决办法定位原因-- 以sysdba身份登陆PL/SQL sqlplus / as sysdba; -- 查看当前连接进程数 SQL>select count(*) from v$process; -- 查看连接数上限 SQL>select value from v$parameter where name =
ora-12516 tns listener could not find available handler with matching protocol
ora-12516 tns listener could not find available handler with matching protocol 公司数据库安装的是 Oracle10g XE(Oracle Database Express Edition 10g release 2)。 最近连接Oracle总出现ora-12516错误,百思不得其解。刚才CUUG群里在讨论or
TNS-12516及ORA-12516错误解决
在客户端进行sqlplus连接报错如下: ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程序 在/home/oracle/product/10.2.0/db_1/network/log/listener.log中查看到错误如下: TNS-12516: TNS:listener could not find available handler with matchin
TNS-12520 TNS:listener could not find available handler for requested type of server
今天数据库连接老是会断开,重连时显示 TNS-12520 TNS:listener could not find available handler for requested type of server 错误rj
ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLER WITH MATCHING PROTOCOL STACK
ERROR : ORA-12516: TNS:listener could not find available handler with matching protocol stackCAUSE : 进程到了最大值    alter system set processes=300 scope=spfile;    alter system set sessions=300 sc