如何停掉在listener中的_XPT服务

在oracle 10gR2中当一个instance注册到listener时,除了正常的服务名称外,还会有一个<sid>_XPT 服务。
这个服务不会导致什么问题,它仅仅打算使用在data guard环境中.
如何停掉这个服务，只需要在init.ora中添加一个参数就可以，详细测试如下

[oracle@test1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 03-SEP-2007 11:32:06

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 03-SEP-2007 11:31:41
Uptime 0 days 0 hr. 0 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/oracle/product/10.2.3/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1)(PORT=1521)))
Services Summary...
Service "yxyup" has 1 instance(s).
Instance "yxyup", status READY, has 1 handler(s) for this service...
Service "yxyupXDB" has 1 instance(s).
Instance "yxyup", status READY, has 1 handler(s) for this service...
Service "yxyup_XPT" has 1 instance(s).
Instance "yxyup", status READY, has 1 handler(s) for this service...
The command completed successfully

SQL> create pfile='/home/oracle/pfile.ora' from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

在init.ora中加入__dg_broker_service_names=''(前面是两个_)

SQL> startup pfile='/home/oracle/pfile.ora' ;
ORACLE instance started.

Total System Global Area 159383552 bytes
Fixed Size 1260648 bytes
Variable Size 134218648 bytes
Database Buffers 20971520 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.
SQL> host
[oracle@test1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 03-SEP-2007 11:36:04

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 03-SEP-2007 11:31:41
Uptime 0 days 0 hr. 4 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/oracle/product/10.2.3/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1)(PORT=1521)))
Services Summary...
Service "yxyup" has 1 instance(s).
Instance "yxyup", status READY, has 1 handler(s) for this service...
Service "yxyupXDB" has 1 instance(s).
Instance "yxyup", status READY, has 1 handler(s) for this service...
The command completed successfully

已经看不到yxyup_XPT的服务了

[url=http://www.bjlytdys.com/]不干胶印刷[/url]技术

this.value