Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
A.
Services support the balancing of client connections across RAC database instances.
B.
In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
C.
Load balancing can be done by the client or the listener, but not both, for any one connection request.
D.
Client-side connect-time load balancing can balance connection requests across SCAN listeners.
E.
Load balancing can be done by the client, the listener, or both, for any one connection request.
Tricky question, but looks like ACE:
If you configured SCAN for connection requests, then client-side load balancing is not relevant for those clients that support SCAN access. With that in mind, we can have load balancing client-side OR load balancing server-side, not both.
If you are using clients that do not support SCAN (for example, the client version is pre-Oracle Database 11g release 2 (11.2)), then, to use SCAN you must change the client tnsnames.ora to include the SCAN VIPs, and set LOAD_BALANCE=ON to balance requests across the VIPs.
Ref:https://docs.oracle.com/en/database/oracle/oracle-database/19/racad/workload-management-with-dynamic-database-services.html#GUID-10F7892A-92DD-482C-8D68-AE80CE956010
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Tunglinfo9
5 days, 13 hours agopiontk
4 months agoFeaRoX
3 months, 3 weeks ago