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

Question

Options

• AIt is based on performance metrics provided by the database instances LREG processes.
• BLOCAL_LISTENER must be configured to point to the SCAN to enable server-side load
• CThe service's connection load balancing goal must be manually configured to enable server-side
• DIt's enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
• EServer-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

• A
  6% (1)
• B
  18% (3)
• C
  71% (12)
• D
  6% (1)

Explanation

C: With server-side load balancing, the SCAN listener directs a connection request to the best instance currently providing the service, based on the -clbgoal and -rlbgoal settings for the E: The SCAN is an essential part of Database configuration. So, by default, the REMOTE_LISTENER parameter is set to the SCAN, assuming that the Database is created using standard Oracle tools. This enables the instances to register with the SCAN Listeners as remote listeners to provide information on what services are being provided by the instance, the current load, and a recommendation on how many incoming connections should be directed to Note: Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster. Incorrect Answers: B: You must set the LOCAL_LISTENER parameter to the node-VIP. If you need fully qualified domain names, then ensure that the LOCAL_LISTENER parameter is set to the fully qualified domain name. By default, a node listener is created on each node in the cluster during cluster configuration. With Oracle Grid Infrastructure, the node listener runs out of the Oracle Grid Infrastructure home and listens on the node-VIP using the specified port. D: LOAD_BALANCE=on, not LOAD_BALANCE=YES, is used. https://docs.oracle.com/database/121/JJDBC/scan.htm#JJDBC29151 https://docs.oracle.com/database/121/RACAD/hafeats.htm#RACAD7122

No community discussion yet for this question.