Connect to Database with Multiple IPs with One Hostname

[alko13]

Hi,

We have an Oracle Database that s load balanced. (One hostname with multiple IPs)

Now we want SAS to use the hostname of the Oracle DB. Seems this approach will not work?

Modify  /etc/hosts like:

123.123.123.1  ABC

123.123.123.2  ABC

123.123.123.3  ABC

May I know how we can achieve this setup? Like what we need to be added in the infrastructure?

Thanks!

[Kurt_Bremser · Accepted solution]

Load Balancing means that there is one load balancer in front of the cluster, with one name and IP address. Often, the balancer is the client app which knows all the servers and spreads requests out.

So the Oracle client on the SAS server should be set up to do the balancing for a schema.