https://communities.sas.com/t5/Architecture/Connect-to-Database-with-Multiple-IPs-with-One-Hostname/m-p/861323#M427 <P>Load Balancing means that there is&nbsp;<U>one</U> 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.</P> <P>So the Oracle client on the SAS server should be set up to do the balancing for a schema.</P> Tue, 28 Feb 2023 10:57:54 GMT Kurt_Bremser 2023-02-28T10:57:54Z https://communities.sas.com/t5/Architecture/Connect-to-Database-with-Multiple-IPs-with-One-Hostname/m-p/861322#M426 <P>Hi,</P> <P>&nbsp;</P> <P>We have an Oracle Database that s load balanced. (One hostname with multiple IPs)</P> <P>&nbsp;</P> <P>Now we want SAS to use the hostname of the Oracle DB. Seems this approach will not work?</P> <P>Modify&nbsp; /etc/hosts like:</P> <P>123.123.123.1&nbsp; ABC</P> <P>123.123.123.2&nbsp; ABC</P> <P>123.123.123.3&nbsp; ABC</P> <P>&nbsp;</P> <P>May I know how we can achieve this setup? Like what we need to be added in the infrastructure?</P> <P>&nbsp;</P> <P>Thanks!</P> Tue, 28 Feb 2023 10:50:15 GMT https://communities.sas.com/t5/Architecture/Connect-to-Database-with-Multiple-IPs-with-One-Hostname/m-p/861322#M426 alko13 2023-02-28T10:50:15Z https://communities.sas.com/t5/Architecture/Connect-to-Database-with-Multiple-IPs-with-One-Hostname/m-p/861323#M427 <P>Load Balancing means that there is&nbsp;<U>one</U> 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.</P> <P>So the Oracle client on the SAS server should be set up to do the balancing for a schema.</P> Tue, 28 Feb 2023 10:57:54 GMT https://communities.sas.com/t5/Architecture/Connect-to-Database-with-Multiple-IPs-with-One-Hostname/m-p/861323#M427 Kurt_Bremser 2023-02-28T10:57:54Z