oracle注册服务到监听器,【LISTENER】使用Oracle隐含参数禁止“_XPT”服务注册到监听器...

在Oracle的10.2版本中，Oracle不仅会将数据库的实例注册到监听器，与此同时还会注册生成一个名为_XPT(以数据库的SID开头，以XPT结尾，中间是下划线)的服务，这个服务是用于Data Guard环境，对正常数据库连接没有影响。鉴于_XPT服务的作用，我们完全有理由取消这个注册。这里给出禁止_XPT服务注册到监听器的方法。我们可以通过将隐含参数“__dg_broker_service_names”内容置空的方法达到这个目的。1.“__dg_broker_service_names”隐含参数的含义可以通过x$ksppi和x$ksppcv获取隐含参数的当前值和说明信息。查询结果如下。sys@ora10g> select a.ksppinm param_name,b.ksppstvl param_value,a.ksppdesc param_description from x$ksppi a,x$ksppcv b where a.indx = b.indx and a.ksppinm = '__dg_broker_service_names';PARAM_NAME                 PARAM_VALUE   PARAM_DESCRIPTION-------------------------- ------------- ----------------------------__dg_broker_service_names  ora10g_XPT    service names for broker use2.监听器状态信息ora10g@secdb /home/oracle$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-AUG-2011 21:19:58Copyright (c) 1991, 2005, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=secdb)(port=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date                22-AUG-2011 21:19:12Uptime                    0 days 0 hr. 0 min. 46 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /oracle/ora10gR2/product/10.2.0/db_2/network/admin/listener.oraListener Log File         /oracle/ora10gR2/product/10.2.0/db_2/network/log/listener.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb.localdomain)(PORT=1521)))Services Summary...Service "ora10g" has 1 instance(s).Instance "ora10g", status READY, has 1 handler(s) for this service...Service "ora10g_XPT" has 1 instance(s).Instance "ora10g", status READY, has 1 handler(s) for this service...The command completed successfully其中“ora10g_XPT”便是我们所提到的_XPT服务。我们的目标就是去除这个注册信息。3.将“__dg_broker_service_names”隐含参数置空sys@ora10g> alter system set "__dg_broker_service_names" = '';System altered.注意，此隐含参数为动态参数，可以直接进行调整。4.重启监听器后查看监听状态1)停止监听器LSNRCTL> stopConnecting to (DESCRIPTION=(address=(protocol=tcp)(host=secdb)(port=1521)))The command completed successfully2)启动监听器LSNRCTL> startStarting /oracle/ora10gR2/product/10.2.0/db_2/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /oracle/ora10gR2/product/10.2.0/db_2/network/admin/listener.oraLog messages written to /oracle/ora10gR2/product/10.2.0/db_2/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb.localdomain)(PORT=1521)))Connecting to (DESCRIPTION=(address=(protocol=tcp)(host=secdb)(port=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date                22-AUG-2011 21:22:40Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /oracle/ora10gR2/product/10.2.0/db_2/network/admin/listener.oraListener Log File         /oracle/ora10gR2/product/10.2.0/db_2/network/log/listener.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb.localdomain)(PORT=1521)))The listener supports no servicesThe command completed successfully3)等待数据库实例注册到监听后查看监听器状态ora10g@secdb /home/oracle$ lsnrctlLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-AUG-2011 21:23:00Copyright (c) 1991, 2005, Oracle.  All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> statusConnecting to (DESCRIPTION=(address=(protocol=tcp)(host=secdb)(port=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date                22-AUG-2011 21:22:40Uptime                    0 days 0 hr. 0 min. 21 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /oracle/ora10gR2/product/10.2.0/db_2/network/admin/listener.oraListener Log File         /oracle/ora10gR2/product/10.2.0/db_2/network/log/listener.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb.localdomain)(PORT=1521)))Services Summary...Service "ora10g" has 1 instance(s).Instance "ora10g", status READY, has 1 handler(s) for this service...The command completed successfully此时ora10g_XPT服务已经不在监听中注册。任务完成。5.小结在非Data Guard环境的Oracle 10.2版本及以上环境，我们都可以使用此方法实现禁止_XPT服务注册到监听器。消除一切疑惑的内容，将数据库的运行状态掌握在自己的手中。Good luck.secooler11.08.22-- The End --