https://community.qlik.com/t5/Connectivity-Data-Prep/2-Host-Name/m-p/2091323#M12481 <P>I want to add 2 host name in creating connection of oracle</P> <P>1.&nbsp;&nbsp;<SPAN>HOST=edc.mart.com ,&nbsp;HOST=cdc.mart.com&nbsp;</SPAN></P> <P><SPAN>2. Directly I can add this string in creating connection </SPAN></P> <P><SPAN>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edc.mart.com)(PORT=61290))(ADDRESS=(PROTOCOL=TCP)(HOST=cdc.mart.com)(PORT= 61290))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=usmppp1.gec.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(LOAD_BALANCE=ON)(DELAY=5))))</SPAN></P> <P><SPAN>Please suggest how I can do this.</SPAN></P> Fri, 07 Jul 2023 04:12:36 GMT Bhoomi_walmart 2023-07-07T04:12:36Z https://community.qlik.com/t5/Connectivity-Data-Prep/2-Host-Name/m-p/2091323#M12481 <P>I want to add 2 host name in creating connection of oracle</P> <P>1.&nbsp;&nbsp;<SPAN>HOST=edc.mart.com ,&nbsp;HOST=cdc.mart.com&nbsp;</SPAN></P> <P><SPAN>2. Directly I can add this string in creating connection </SPAN></P> <P><SPAN>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edc.mart.com)(PORT=61290))(ADDRESS=(PROTOCOL=TCP)(HOST=cdc.mart.com)(PORT= 61290))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=usmppp1.gec.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(LOAD_BALANCE=ON)(DELAY=5))))</SPAN></P> <P><SPAN>Please suggest how I can do this.</SPAN></P> Fri, 07 Jul 2023 04:12:36 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/2-Host-Name/m-p/2091323#M12481 Bhoomi_walmart 2023-07-07T04:12:36Z https://community.qlik.com/t5/Connectivity-Data-Prep/2-Host-Name/m-p/2093847#M12500 <P>I may be outdated regarding oracle versions, but there wasn't a file for oracle configurations on windows called TNSnames.ora?</P> <P>If it's still the case I would duplicate the entry with both host names and that's it.</P> Fri, 14 Jul 2023 09:56:45 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/2-Host-Name/m-p/2093847#M12500 molinaantonio 2023-07-14T09:56:45Z