Workload Management in RAC

>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))

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: