[20211020]XXXX_DGB服务名.txt

--//当使用DGMGRL管理dg时，会建立如下两个服务XXXX_DGB,XXXX_DGMGRL.昨天配置是不小心犯了一个小错误做一个记录。

$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-OCT-2021 09:30:48
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.aaa.bbb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                20-OCT-2021 09:27:37
Uptime                    0 days 0 hr. 3 min. 11 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0.3/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.aaa.bbb)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "xxx999XDB" has 1 instance(s).
  Instance "xxx999dg2", status READY, has 1 handler(s) for this service...
Service "xxx999dg2" has 2 instance(s).
  Instance "xxx999dg2", status UNKNOWN, has 1 handler(s) for this service...
  Instance "xxx999dg2", status READY, has 1 handler(s) for this service...
Service "xxx999dg2_DGB" has 2 instance(s).
  Instance "xxx999dg2", status UNKNOWN, has 1 handler(s) for this service...
  Instance "xxx999dg2", status READY, has 1 handler(s) for this service...
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Service "xxx999dg2_DGMGRL" has 1 instance(s).
  Instance "xxx999dg2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

--//xxx999dg2_DGB 服务名存在两个一个动态注册，一个静态注册。静态注册是我写在监听配置文件里面，为什么还存在一个动态注册的
--//服务名呢？

SYS@xxx999dg2> show parameter service
NAME          TYPE   VALUE
------------- ------ ---------
service_names string xxx999dg2

--//仅仅存在一个服务名xxx999dg2。

SYS@xxx999dg2> select name from DBA_SERVICES;
NAME
--------------------
SYS$BACKGROUND
SYS$USERS
xxx999XDB
xxx999
--//也不存在xxx999dg2_DGB服务名。

--//找到一个链接：http://blog.itpub.net/20747382/viewspace-2130664/ =>_DGMGRL and _DGB
Note:  Static entries are only used by the Broker itself via the Broker defined StaticConnectIdentifier property.  They
are NEVER to be used for any other purpose by the user.  This includes using it for the normal DGConnectIdentifier, RMAN
connections or anything else.  Also note that you must never define a static entry for the Broker 'DGB' service.  That
service is for the Broker exclusive use.  Also note that using the "_DGMGRL" or "_DGB" in your TNSNAMES definition is
expressly forbidden.

注意：静态条目仅通过代理定义的静态连接标识符属性使用。用户绝不会将它们用于任何其他目的。这包括使用它用于正常的DG连接器标
识符、RMAN连接或其他任何东西。还要注意，您永远不能为代理"DGB"服务定义静态条目。这项服务是为经纪人独家使用的。还要注意，
在您的名称定义中，使用"_DGMGRL"或"_DGB"是明确禁止的。

--//可以发现提示永远不能为代理"DGB"服务定义静态条目，这项服务是为经纪人独家使用的。
--//也就是根本不需要配置xxx999dg2_DGB服务为静态注册。在监听文件中注解这部分内容。

$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-OCT-2021 16:33:24
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.aaa.bbb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                20-OCT-2021 10:53:09
Uptime                    0 days 5 hr. 40 min. 15 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0.3/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.aaa.bbb)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "xxx999XDB" has 1 instance(s).
  Instance "xxx999dg2", status READY, has 1 handler(s) for this service...
Service "xxx999dg2" has 2 instance(s).
  Instance "xxx999dg2", status UNKNOWN, has 1 handler(s) for this service...
  Instance "xxx999dg2", status READY, has 1 handler(s) for this service...
Service "xxx999dg2_DGB" has 1 instance(s).
  Instance "xxx999dg2", status READY, has 1 handler(s) for this service...
Service "xxx999dg2_DGMGRL" has 1 instance(s).
  Instance "xxx999dg2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

--//xxx999dg2_DGB 这个服务非常特殊，只要使用DGMGRL就存在并且建立一个动态服务名。