告警短信:can't connect DB,maybe down!,TNS-12520,TNS-12519,TNS-12516
在listener log里面发现如下信息:
10-JUL-2012 14:14:27 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58503)) * establish * xxx * 0
10-JUL-2012 14:14:37 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58632)) * establish * xxx * 0
10-JUL-2012 14:14:37 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))(SERVER=dedicated)) * (ADDRESS=(PR
OTOCOL=tcp)(HOST=10.10.41.125)(PORT=58640)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:14:37 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58641)) * establish * xxx * 0
10-JUL-2012 14:14:37 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))(SERVER=dedicated)) * (ADDRESS=(PR
OTOCOL=tcp)(HOST=10.10.41.125)(PORT=58642)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:14:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=cmg))(SERVICE_NAME=xxx)(FAILOVER_MODE=(TYPE=SELECT)(MET
HOD=BASIC)(RETRIES=20)(DELAY=10))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.710.233.38)(PORT=50144)) * establish * xxx * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack
10-JUL-2012 14:14:46 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=pss_tuner.9i)(HOST=host1)(USER=prec))) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.10.41.125)(PORT=58720)) * establish * xxx * 0
10-JUL-2012 14:14:46 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=pss_tuner.9i)(HOST=host1)(USER=prec))(SERVER=dedicated)) * (ADDR
ESS=(PROTOCOL=tcp)(HOST=10.10.41.125)(PORT=58721)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:14:47 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58726)) * establish * xxx * 0
10-JUL-2012 14:14:47 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))(SERVER=dedicated)) * (ADDRESS=(PR
OTOCOL=tcp)(HOST=10.10.41.125)(PORT=58734)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:14:47 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58735)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:14:57 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58985)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:14:57 * (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=oracle)(HOST=host1)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.70.213.215)(PORT=58993)) * establish * xxx * 12519
TNS-12519: TNS:no appropriate service handler found
10-JUL-2012 14:15:01 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ebusi)(INSTANCE_NAME=xxx)(CID=(PROGRAM=db2.pl)(HOST=zjdaov
01)(USER=yiyang))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.70.240.82)(PORT=49245)) * establish * xxx * 12520
TNS-12520: TNS:listener could not find available handler for requested type of server
10-JUL-2012 14:15:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=cmg))(SERVICE_NAME=xxx)(FAILOVER_MODE=(TYPE=SELECT)(MET
HOD=BASIC)(RETRIES=20)(DELAY=10))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.70.203.7)(PORT=59045)) * establish * xxx * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack
这个问题之前遇到过,看了下如下参数的值:
SQL> select name,value from v$spparameter where name in('sessions','processes');
NAME VALUE
-------------------- ------
processes 500
sessions 555
SQL> select count(*) from v$process;
COUNT(*)
----------
495
SQL> select count(*) from v$session;
COUNT(*)
----------
481
至于为什么会报这样的错误,以及实际的process数量并没有达到500,但是应用无法连接,看如下的Metalink解释:
instance registration, PMON is responsible for updating the listenerwith information about a particular instance such as load and dispatcherinformation. Maximum load for dedicated connections is determined by thePROCESSES parameter. The frequency at which
PMON provides SERVICE_UPDATEinformation varies according to the workload of the instance. The maximuminterval between these service updates is 10 minutes.
The listener counts the number of connections it has established to the instancebut does not immediately get information about connections that have terminated.
Only when PMON updates the listener via SERVICE_UPDATE is the listenerinformed of current load. Since this can take as long as 10 minutes, there can bea difference between the current instance load according to the listenerand the actual instance load.
When the listener believes the current number of connections has reached maximumload, it may set the state of the service handler for an instance to "blocked"and begin refusing incoming client connections with either of the following
errors:
TNS-12516 TNS:listener could not find instance with matching protocol stack
TNS-12519 TNS:no appropriate service handler found
Additionally, an ORA-12520 error may appear in the listener log.The output of the LSNRCTL services command will likely show that the service handler is "blocked".
e.g. '"DEDICATED" established:1 refused:0 state:blocked'
分享到:
相关推荐
BLOG_【故障处理】Oracle_lhr_TNS-12518、TNS-00517和 Linux Error:32:Broken pipe.pdfBLOG_【故障处理】Oracle_lhr_TNS-12518、TNS-00517和 Linux Error:32:Broken pipe.pdf
TNS-12500解决过程 TNS-12500解决过程 TNS-12500解决过程
TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 文章转自:http://www.luocs.com/archives/464.html 此文版权归作者 – yaogang所有,转载请注明yaogang©www.luocs.com。 ...
介绍TNS-G12864FGDFN的物理参数,外形尺寸图,光电特性,引脚连接等。
oracleTNS报错oracleTNS报错oracleTNS报错
listener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsname
TNS-240320RGUSW-6W液晶源代码
oracle 常见问题 TNS- 无法解析指定的连接标识符
收集的关于 ORA-12516 or ORA-00020 TNS 监听程序无法找到匹配协议栈的可用句柄
ORA-12560 TNS 协议适配器错误
TNS-中国移动XXXX年客户满意度研究项目建议书.pptx
ORA-12560_TNS协议适配器错误_的问题
该存储库已弃用,当前tns-template-blank-svelte软件包的来源为halfnelson / svelte-native-template 带Svelte本机空白模板的NativeScript 应用程序模板可帮助您使用内置的UI元素和最佳实践来快速启动本机跨平台...
ORA-12518 TNS:监听程序无法分发客户机连接,在您安装好数据库后配置连接数据库的过程中遇到这类问题应该很头疼吧,不过,当您还是四处查资料来解决您遇到的另你头疼的问题时,如果不经意间看到了这则贴子,那请您升...
当发生协议适配器错误时,不要灰心,打开管理工具中的服务,按部就班解决。
tns-微信 用于NativeScript项目的微信插件。 目前,该插件仅支持Android平台,iOS即将推出。 我想分享我的东西给微信 对于Android开发人员,请确保您已从Tecent获得了AppID 。 否则它将无法与微信平台共享任何内容。...
Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack
带有Angular 2和BrightWork的NativeScript模板 Telerik NativeScript模板,其前端使用 ,后端使用... tns create my-app-name --template tns-template-brightwork-ng cd my-app-name tns platform add ios为iOS tns
ORACLE数据库-TNS协议分析详解ORACLE数据库-TNS协议分析详解ORACLE数据库-TNS协议分析详解ORACLE数据库-TNS协议分析详解
tns-android-wear-test