Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.