这个服务不会导致什么问题,它仅仅打算使用在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的服务了