Implementing Data Guard - Expert Consolidation in Oracle Database 12c - page 347

The Broker syntax is not too daunting, but it is yet another tool to understand in addition to SQL and RMAN,
which are quite common. The main verbs you need to be aware of in the next two sections are edit and show . Each
verb is followed by an object such as the configuration or database. Add the database name as per the configuration
and a property you would like to view or change. The following sections have all the examples you need to manage,
modify, and otherwise maintain the broker configuration. There is also a very useful help function in dgmgrl that
helps you remind yourself of the correct syntax.
Listener configuration
One of the greatest benefits of the Broker over the manual approach is that it fully automates the role transitions.
During these, database restarts are required. As you know, a connection to a database which is shut down requires a
static registration in the listener.ora file. Every listener for every host participating in the Data Guard configuration
has to be amended. Remember that the listener is configured in the Grid home if you are using Oracle Restart.
The Broker uses a database property, called StaticConnectIdentifier to address databases. It is populated by
default and does not normally need to be changed. Using the broker, you can use the show database databaseName
StaticConnectIdentifier command as demonstrated here:
DGMGRL> show database "CDB1DCA" staticConnectIdentifier
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.20)(PORT=1521)) 
(CONNECT_DATA=( SERVICE_NAME=CDB1DCA_DGMGRL )(INSTANCE_NAME=CDB1DCA) 
(SERVER=DEDICATED)))'
DGMGRL>
The service name is the one that has to be registered in the listener.ora file. To follow the example, here is the
listener.ora for the current primary database.
[grid@server1 admin]$ nl listener.ora
1 # listener.ora Network Configuration File: 
/u01/app/grid/product/12.1.0.1/grid/network/admin/listener.ora
2 # Generated by Oracle configuration tools.
3 SID_LIST_LISTENER =
4 (SID_LIST =
5 (SID_DESC =
6 (GLOBAL_DBNAME = CDB1DCA )
7 (ORACLE_HOME = /u01/app/oracle/product/12.1.0.1/dbhome_1)
8 (SID_NAME = CDB1DCA )
9 )
10 (SID_DESC =
11 (GLOBAL_DBNAME = CDB1DCA_DGMGRL )
12 (ORACLE_HOME = /u01/app/oracle/product/12.1.0.1/dbhome_1)
13 (SID_NAME = CDB1DCA )
14 )
[configuration information removed for clarity]
25 )
26 VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET
27 LISTENER =
28 (DESCRIPTION_LIST =
29 (DESCRIPTION =