DR switchover ORA-12514 TNS listener does not currently know of service requested in connect descrip
edited Oct 7, 2013 1:08AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered ✓
Hallo!I have setup a test Active Dataguard db with live db called DC and standby db called DR.Replication works well.Next,I have setup Data Guard Broker via steps below
Created folder ADGCONFIG on DATA and FRA ASM disk groups on both Live and DR dbs as below
For Live db
SQL>alter system set dg_broker_config_file1='+DATA/DC/ADGCONFIG/adg_config01.ora';
SQL> alter system set dg_broker_config_file2='+FRA/DC/ADGCONFIG/adg_config02.ora; '
For DR db
SQL>alter system set dg_broker_config_file1='+DATA/DR/ADGCONFIG/adg_config01.ora;
Created folder ADGCONFIG on DATA and FRA ASM disk groups on both Live and DR dbs as below
For Live db
SQL>alter system set dg_broker_config_file1='+DATA/DC/ADGCONFIG/adg_config01.ora';
SQL> alter system set dg_broker_config_file2='+FRA/DC/ADGCONFIG/adg_config02.ora; '
For DR db
SQL>alter system set dg_broker_config_file1='+DATA/DR/ADGCONFIG/adg_config01.ora;
0