The listener supports no services解决一例Listener动态监听静态监听注册实例今天做Advacned Replication实验的时候碰到一个问题，启动目标库监听时，出现The listener supportsno services[oracle@adrep ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:11:38Copyright (c) 1991, 2011,Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:please wait...TNSLSNR forLinux: Version 11.2.0.3.0 - ProductionSystem parameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to/u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNRfor Linux: Version 11.2.0.3.0 - ProductionStart Date 14-SEP-2013 10:11:38Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: LocalOS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))The listener supports no servicesThe command completed successfully由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上本地登录到Oracle实例，手动注册实例也无果，问题依旧SQL> alter system register;System altered.SQL> ![oracle@adrep ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:13:03Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNRfor Linux: Version 11.2.0.3.0 - ProductionStart Date 14-SEP-2013 10:11:38Uptime 0 days 0 hr. 1 min. 25 secTrace Level offSecurity ON: LocalOS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))The listener supports no servicesThe command completed successfully[oracle@adrep ~]$ lsnrctl reloadListener Log File /u01/app/LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:16:13Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))The command completed successfully[oracle@adrep ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:13:18Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNRfor Linux: Version 11.2.0.3.0 - ProductionStart Date 14-SEP-2013 10:11:38Uptime 0 days 0 hr. 1 min. 40 secTrace Level offSecurity ON: LocalOS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))The listener supports no servicesThe command completed successfully[oracle@adrep ~]$ lsnrctl stopLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:17:03Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))The command completed successfully[oracle@adrep ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:18:53Copyright (c) 1991, 2011, Oracle. All rightsreserved.Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:please wait...TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionSystem parameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to/u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNRfor Linux: Version 11.2.0.3.0 - ProductionStart Date 14-SEP-2013 10:18:53Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: LocalOS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))The listener supports no servicesThe command completed successfully[oracle@adrep ~]$于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID这个SID绝对是strmtarget没错的，global name即servicename也确实是target，这个可以由以下参数获得佐证SQL> show parameter nameNAME TYPE VALUE------------------------------------ -----------------------------------------db_file_name_convert stringdb_name string strmtargdb_unique_name string strmtargetglobal_names boolean TRUEinstance_name string strmtargetlock_name_space stringlog_file_name_convert stringprocessor_group_name stringservice_names string target也可以通过v$instance视图查到SID是正确的SQL> select instance_name from v$instance;INSTANCE_NAME----------------strmtarget难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = target) (SID_NAME = strmtarget) ))其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可这里只需要重新加载一次监听就可以注册上实例了[oracle@adrep ~]$ lsnrctl reloadLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:32:06Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))The command completed successfully[oracle@adrep ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201310:32:14Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNRfor Linux: Version 11.2.0.3.0 - ProductionStart Date 14-SEP-2013 10:18:53Uptime 0 days 0 hr. 13 min. 21 secTrace Level offSecurity ON: LocalOS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Services Summary...Service "target" has 1 instance(s). Instance "strmtarget", status UNKNOWN, has 1handler(s) for this service...The command completed successfully[oracle@adrep ~]$这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的注意：动态和静态监听可以共存，如：[oracle@zlm ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-201309:52:23Copyright (c) 1991, 2011, Oracle. All rightsreserved.Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNRfor Linux: Version 11.2.0.3.0 - ProductionStart Date 14-SEP-2013 09:15:04Uptime 0 days 0 hr. 37 min. 19 secTrace Level offSecurity ON: LocalOS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Services Summary...Service "zlm11g" has 2 instance(s). Instance "zlm11g", status UNKNOWN, has 1handler(s) for this service... Instance "zlm11g", status READY, has 1handler(s) for this service...Service "zlm11gXDB" has 1 instance(s). Instance "zlm11g", status READY, has 1handler(s) for this service...The command completed successfully[oracle@zlm ~]$以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个oraerror：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。
爱华网本文地址 » http://www.aihuau.com/a/25101015/260063.html
更多阅读
我是蔓蔓的妈妈，蔓蔓出院一个月后，病情已经得到了控制，当时我很高兴的告诉周营养师，而小蔓蔓现在平均每天都只发一串，而且发作时幅度变小。孩子现在也愿意坐很长时间，而且咯咯笑很长时间，感觉有很大进步了。孩子的变化让我对治疗更加有信心
可能是树大招风，近期总是能看到和王老师有关的卦例讨论，不管质疑也好，赞成也好，都说明王老师的影响越来越大的吧。这个也是龙隐上的一个案例。考虑到篇幅，就不一一引用了，直接看王老师的卦;公布答案：此卦是某大师在其《六爻预测自修宝典》
一例犬肘关节脱位的手术治疗前几天接诊一只5个月的小狗，双前肢站不起来，拍了X光片以后，发现双前肢肘关节创伤性脱位，左前肢肱骨外侧髁有骨折，X光片如下：因为时间太长，没办法闭合性整复，和主人沟通后，决定开放性整复，C
绝招治痔疮无一例复发 鸡蛋用酒煮 快速治疗风湿、类风湿2011-06-08 18:14:18|分类： （引用）就知道看 |标签： |字号大中小订阅本文引用自jzxfzh《绝招治痔疮无一例复发 鸡蛋用酒煮 快速治疗风湿、类风湿》绝招治痔疮无一例复发 鸡蛋用酒煮
脐带血干细胞移植治疗2型糖尿病一例张垒医生微信及电话15176845655【关键词】脐带血干细胞；糖尿病；糖尿病是一组以慢性血葡萄糖水平增高为特征的代谢性疾病，是由于胰岛素分泌和（或）作用缺陷所引起。本病使患者生活质量降低，寿命缩短，病
爱华网