[20211020]XXXX_DGB服务名.txt

[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就存在并且建立一个动态服务名。