Database - RAC/Scalability (MOSC)

MOSC Banner

Why LOAD_BALANCE=ON for single host name ?

Hello,
Reading the article https://www.oracle.com/docs/tech/database/cme-oow2017-applicationcontinuity.pdf
I see the LOAD_BALANCE=ON for single SCAN-address:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=primary_scan_vip)(PORT=primary_port))
(LOAD_BALANCE=ON)
)

  1. What does the LOAD_BALANCE=ON for single SCAN-address ?
  2. And what will happen if we don’t specify LOAD_BALANCE=ON?

DNS gives three addresses for each request.
My guess:
In 1st case the DB client will try all 3 IPs to connect to DB.
In 2nd case the DB client will use the 1st IP only.

Am i right ?

Thank you!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center