I have seen a lot information about correct configurations of Oracle Real Application Cluster’s environment to provided Server Side Load Balancing with good information. But most of it relates to dedicated server configurations. What about shared server configurations ?
The main problem is one like with dedicated server configuration – if we don’t specify HOST of the dispatcher then PMON will take result of locally executed command hostname, which is in most cases public node name, and bind dispatcher’s listening end-points on it – which IS WRONG!
So we have to provide VIP nodename/address for dispatchers like this:
We have to provide different values for DISPATCHERS parameter for each instance:
ALTER SYSTEM SET DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip))" SID='INST1';
ALTER SYSTEM SET DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip))" SID='INST2';
And DO NOT specify LISTENER parameter for DISPATCHERS!
PMON will register dispatcher’s listening end-points with listeners specified in REMOTE_LISTENER parameter – which also works for dedicated server configuration.
Have a nice RACcing!