Network Admin   «Prev 

Example of tnsnames.ora file for connection load balancing

Oracle tns names
Oracle TNS names

Location 1 This switch must be set ON to tell Net8 to use the connection load balancing feature.
Location 2 This states that if the chosen address fails to make a connection, other addresses listed will automatically be tried.
Locations 3, 4 Here are two addresses listing two distinct database nodes that will participate in connection load balancing.
Location 5 The service name for all the nodes must be the same. In this example, it is HOUSEOPETS.COM