Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 10

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

Answer options

• 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 LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Correct answer: C

Explanation

The correct answer is C because setting the DB_NAME parameter identically on all databases allows client connections to use the same identifier, facilitating a seamless transition to the new primary database. Options A and B involve more complex configurations that do not guarantee automatic redirection. Option D, while useful for listener registration, does not address the client connection logic needed for automatic redirection during role changes.