Oracle Database 12c: RAC Administration — Question 16

Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

Answer options

• A. It is based on performance metrics provided by the database instances LREG processes.
• B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.
• C. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing.
• D. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
• E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

Correct answer: C, E

Explanation

The correct answers are C and E because server-side connect-time load balancing requires manual configuration of the service’s connection load balancing goal (C) and the REMOTE_LISTENER must point to the SCAN for proper operation (E). Options A, B, and D are incorrect as they do not accurately represent the requirements for server-side load balancing in this context.