dataguard broker rac to standalone

[Roshan]

Hello Erman,

Can you please advise how I can proceed with dataguard broker configuration? ENv details are shown below:
ENV.png
 
On standby DB:
DWAREDR =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dwaredr)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = dwaredr)
  )
 )

listener status:
ora12c@dwaredr:/u01/app/ora12c/product/12.1.0/dbhome_1/network/admin$ lsnrctl status

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-NOV-2020 09:46:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dwaredr.telecom.mu)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias           LISTENER
Version          TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date        18-AUG-2020 15:44:57
Uptime          76 days 18 hr. 1 min. 39 sec
Trace Level        off
Security         ON: Local OS Authentication
SNMP           OFF
Listener Parameter File  /u01/app/ora12c/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File     /u01/app/ora12c/diag/tnslsnr/dwaredr/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dwaredr)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "dwaredr" has 1 instance(s).
 Instance "dware1", status READY, has 1 handler(s) for this service...
The command completed successfully

Primary DB:DWARE1 =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dware-scan)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = dware1)
  )
 )

On Primary node:
ora12c@dware1:/u01/app/ora12c/product/12.1.0/dbhome_1/network/admin$ lsnrctl status

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 03-NOV-2020 09:47:02

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias           LISTENER
Version          TNSLSNR for Solaris: Version 19.0.0.0.0 - Production
Start Date        05-OCT-2020 19:41:39
Uptime          28 days 14 hr. 5 min. 24 sec
Trace Level        off
Security         ON: Local OS Authentication
SNMP           OFF
Listener Parameter File  /u01/app/grid/network/admin/listener.ora
Listener Log File     /u01/app/gridbase/diag/tnslsnr/dware1/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.215.227.28)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.215.227.30)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dware1)(PORT=2200))(Presentation=HTTP)(Session=RAW))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dware1)(PORT=5501))(Security=(my_wallet_directory=/u01/app/ora12c/product/12.1.0/dbhome_1/admin/dware1/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+APX" has 1 instance(s).
 Instance "+APX1", status READY, has 1 handler(s) for this service...
Service "+ASM" has 1 instance(s).
 Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
 Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
 Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "SYS$ORAGGEXT.OGG$Q_EXTDWH.DWARE1" has 1 instance(s).
 Instance "dware11", status READY, has 1 handler(s) for this service...
Service "SYS$ORAGGEXT.OGGQ$REPLOGGT.DWARE1" has 1 instance(s).
 Instance "dware11", status READY, has 1 handler(s) for this service...
Service "dware1" has 1 instance(s).
 Instance "dware11", status READY, has 1 handler(s) for this service...
Service "dware1XDB" has 1 instance(s).
 Instance "dware11", status READY, has 1 handler(s) for this service...
The command completed successfully

Thanks,

Roshan

[ErmanArslansOracleBlog]

Hi Roshan,

It is a standard procedure.

The high level steps are;

Create the new listener entry for handling Data Guard Broker based connections & configure tnsnames accordingly.
Enable/Set DG Broker Parameters
Create the Broker configuration & Enable it
(all sites TNS aliases and connect strings used in the configuration and parameters within the RDBMS instances are set correctly then the configuration should be enabled successfully without error.)

Check this MOS note to get the idea : Data Guard Physical Standby - RAC Primary to RAC Standby using a second network (Doc ID 1349977.1) -- it may be a little different than yours, as it is focusing on building a data guard broker configuration that uses a network other than the public network for enabling the broker configuration and shipping of logs between the sites. It is also focused on RAC to RAC DG Broker configuration.. But, the flow of actions is similar..