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)
)
- What does the LOAD_BALANCE=ON for single SCAN-address ?
- 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!