Your Data Guard environment has two remote physical standby databases. Client applications use the local naming method to define connectivity to the primary database instanc
E.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?
A.
Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.
B.
Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
C.
Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
D.
Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.
A or B.
db_name is identically by design.
B
indeed, B
A is also correct in case of RAC.
“A” would allow (RAC or not) to have connections either to the Primary or to the Stansbys (Real Time Query) before and after the switchover / failover (startup trigger will enable / disable services)
Reference:
https://www.doag.org/formes/servlet/DocNavi?action=getFile&did=6443095&key=
Search for “Create trigger to start service on on the primary database during startup”
This trigger is also on Oracle Education documentation (though I didn’t find it at this time)
This is all true if it was on the PRIMARY, not on the Standbys…
Maybe B ???
B is correct
https://docs.oracle.com/database/121/HABPT/config_fcf.htm#HABPT5389
he Oracle Net alias should specify both the primary and standby SCAN hostnames. For best performance while creating new connections the Oracle Net alias should have LOAD_BALANCE=OFF for the DESCRIPTION_LIST so that DESCRIPTIONs are tried in an ordered list, top to bottom. With this configuration the second DESCRIPTION is only attempted if all connection attempts to the first DESCRIPTION have failed
B is correct!