iXp and Oracle TAF support using jdbc:oracle:thin

Products

• CA Workload Automation iXP

Issue/Introduction

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.

Environment

Release : 11.3.5 and 11.4

Component : iXp

Resolution

JDBC thin client driver ("jdbc:oracle:thin") itself does not support TAF.

Additional Information

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.