ITPub博客

查看连接过来的应用cat listener.log|sed -n '/11-NOV-2015 18:00/,/11-NOV-2015 19:00/p' | sed 's/\*.*SERVICE_NAME=/ /g;s/).*HOST=/ /g;s/).*$//g'&n

监听日志清理

文章转自MOS文档：<span style="font-family:Simsun;font-size:14px;font-weight:bold;line-height:21px;text-align:right;white-space:normal;background-color:#FFFFFF;">Troubleshooting Guide for TNS-12518 TNS listener could not hand off client connection (文档 ID 550859.1)</span><br /><br /><div style="ba...

文章摘自MOS文档：How to Create Multiple Oracle Listeners and Multiple Listener Addresses (文档 ID 232010.1)APPLIES TO:Oracle Net ServicesInformation in this document applies to any platform.Checked for relevance on 08-OCT-2009.***Checked for relevance on 27-nov-201...

文章转自：http://www.oracledatabase12g.com/archives/11gr2-rac-add-listener-static-register.html之前有同学想要给11gR2的RAC添加LISTENER监听器，查看了listener.ora并发现问题:[oracle@vrh2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-DEC-2011 02:51:40Copyright (c) 19...

安装环境：操作系统版本：RHCLE5ORACLE版本：11gR2开启监听器，远程连接报错：ORA-12514: TNS:linstener does not currently know of service requested in connect descriptor解决问题思路：查看监听器状态，关闭后...

本文摘自MOS文档：The Listener Supports No Services (文档 ID 1640082.1)APPLIES TO:Oracle Net Services - Version 11.2.0.1 and laterInformation in this document applies to any platform.SYMPTOMS11.2 RAC listener shows no services registered. Command lsnrctl services reportsLSNRCTL for ...