Which two statements are true regarding server-side con…

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

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 connecttime 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.

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 service.
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 the instance.
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.References: https://docs.oracle.com/database/121/JJDBC/scan.htm#JJDBC29151
https://docs.oracle.com/database/121/RACAD/hafeats.htm#RACAD7122