In the iXp AdminTool we have setup following database connection url:
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(LOAD_BALANCE=OFF)(ADDRESS=(PROTOCOL=TCP)(host=hostname1)(port=1521))(ADDRESS=(PROTOCOL=TCP)(host=hostname2)(port=1521)))(CONNECT_DATA=(SERVICE_NAME=autoint.prod.local)))
However IXP didn't switch on the secondary DB when the primary DB wasn't available.
Release : 11.3.5 and 11.4
Component : iXp
JDBC thin client driver ("jdbc:oracle:thin") itself does not support TAF.
Workaround
1. change hostname order
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(LOAD_BALANCE=OFF)(ADDRESS=(PROTOCOL=TCP)(host=hostname2)(port=1521))(ADDRESS=(PROTOCOL=TCP)(host=hostname1)(port=1521)))(CONNECT_DATA=(SERVICE_NAME=autoint.prod.local)))
Restart iXp
or
2. Use the Secondary Connection in AdminTool.