As the Grid Infrastructure owner add the following lines to the listener.ora and restart the listener. This to be done on both the compute nodes. On exadb01 SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=DEVPD_SB_DGMGRL.gav.com.au) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=DEVPD1) ) ) On exadb02 SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=DEVPD_SB_DGMGRL.gav.com.au) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=DEVPD2) ) ) Note: Restart the listener on both nodes after making changes to the listener.ora Add parameters required for Data Broker Note: Do this on both Primary as well as Standby database SQL> system set dg_broker_config_file1='+DATAC1/devpd/dr1.dat' sid='*' scope=both; SQL> System altered. SQL> alter system set dg_broker_config_file2='+DATAC1/devpd/dr2.dat' sid='*' scope=both; System altered. SQL> alter system set dg_broker_start=true scope=both; SQL> System altered.
As the Grid Infrastructure owner add the following lines to the listener.ora and restart the listener. This to be done on both the compute nodes. On exadb01 SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=DEVPD_SB_DGMGRL.gav.com.au) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=DEVPD1) ) ) On exadb02 SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=DEVPD_SB_DGMGRL.gav.com.au) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=DEVPD2) ) ) Note: Restart the listener on both nodes after making changes to the listener.ora Add parameters required for Data Broker Note: Do this on both Primary as well as Standby database SQL> system set dg_broker_config_file1='+DATAC1/devpd/dr1.dat' sid='*' scope=both; SQL> System altered. SQL> alter system set dg_broker_config_file2='+DATAC1/devpd/dr2.dat' sid='*' scope=both; System altered. SQL> alter system set dg_broker_start=true scope=both; SQL> System altered.
Create-Data-Guard-Physical-Standby-on-Exadata.docx