>The three different types of workload management techniques are:
1.client side connect time load balancing
2.client side connect time failover
3.server side connect time load balancing
>Incase of client side connect time load balancing we need to specify load_balance=yes
in tnsnames.ora.If specified oracle randomizes the connection among the all available
listener entries.
>Incase of client side connect time failover we need to specify failover=yes in tnsnames.ora
>Incase of server side connect time load balancing, we need to set an init.ora parameter i.e; remote_listener
to an entry that describes the list of all available listener entries in tnsnames.ora
init.ora
———–
Remote_listener=listeners_hrms
tnsnames.ora
————-
(Addresslist=(protocol=TCP)(host=lnx01-vip)(port=1521))
(Addresslist=(protocol=TCP)(host=lnx02-vip)(port=1521))
