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

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.

Switchovers or failovers are possible due to testing or in case of a disaster.

Clients use local TNSNAMES.ORA files to define connection strings to the database instances.

Which three will prevent clients from connecting to the wrong database instances? (Choose three.)

Answer options

• A. Client TNS entries for the databases use the correct service names for the intended service.
• B. A service name is registered with the local listener of each database instance.
• C. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
• D. The LOCAL_LISTENER parameter on the primary database instance must always be set.
• E. The standby database services must be defined statically with the Listeners running on the standby database hosts.
• F. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
• G. The client applications must use the correct TNS entries when requesting connections to the database instances.

Correct answer: C, D, G

Explanation

The correct answers are C, D, and G because establishing Oracle Net connectivity to the primary instance (C) ensures that clients can connect properly. The LOCAL_LISTENER parameter (D) must always be configured to facilitate proper routing of connections. Additionally, using the correct TNS entries (G) is essential for clients to connect to the intended database instances. Options A, B, E, and F are not directly related to preventing clients from connecting to the wrong instances.