Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bhoomi_walmart
Contributor
Contributor

2 Host Name

I want to add 2 host name in creating connection of oracle

1.  HOST=edc.mart.com , HOST=cdc.mart.com 

2. Directly I can add this string in creating connection

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))))

Please suggest how I can do this.

Labels (2)
1 Reply
molinaantonio
Contributor II
Contributor II

I may be outdated regarding oracle versions, but there wasn't a file for oracle configurations on windows called TNSnames.ora?

If it's still the case I would duplicate the entry with both host names and that's it.