Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.