Adding jdbc connection string for failover

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hst20w110m3)(PORT=1511))(SERVICE_NAME=PS1SID))(ADDRESS=(PROTOCOL=TCP)(HOST=hst20w114m3)(PORT=1511))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVICE_NAME=PS2SID)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180))))

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hst20w110m3)(PORT=1511))(SERVICE_NAME=PS1SID)(ADDRESS=(PROTOCOL=TCP)(HOST=hst20w114m3)(PORT=1511))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVICE_NAME=PS2SID)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180))))

 

jdbc:oracle:thin:@(DESCRIPTION_LIST = (FAILOVER = yes)(LOAD_BALANCE = no)(DESCRIPTION =(LOAD_BALANCE = yes)(ADDRESS = (PROTOCOL= TCP) (HOST= uathst5w80m7) (PORT = 1611)) (CONNECT_DATA = (SERVICE_NAME = US1SID)))(DESCRIPTION =(LOAD_BALANCE = yes)(ADDRESS = (PROTOCOL= TCP) (HOST= uathst5w80m7) (PORT= 1611))(CONNECT_DATA = (SERVICE_NAME = US1SID))))
jdbc:oracle:thin:@(DESCRIPTION_LIST = (FAILOVER = yes)(LOAD_BALANCE = no)(DESCRIPTION =(LOAD_BALANCE = yes)(ADDRESS = (PROTOCOL= TCP) (HOST= hst20w110m3) (PORT = 1511)) (CONNECT_DATA = (SERVICE_NAME = PS1SID)))(DESCRIPTION =(LOAD_BALANCE = yes)(ADDRESS = (PROTOCOL= TCP) (HOST= hst20w114m3) (PORT= 1511))(CONNECT_DATA = (SERVICE_NAME = PS2SID))))
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl)))

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sithst5w88m7.xyzcorp.com)(PORT =1690)))(CONNECT_DATA=(SERVICE_NAME=SS1SIDX)))
jhstc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sithst4w100m7.xyzcorp.com)(PORT =1881)))(CONNECT_DATA=(SERVICE_NAME=SR1BPMS)))

 

Leave a Reply

Your email address will not be published. Required fields are marked *