Using a TAF Configured URL

To ensure that the EMS server does not lose its connection to the database during a database failover, the server should connect to the database using a Transparent Application Failover (TAF) configured URL. For example:

jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
Note: True Transparent Application Failover is not supported. If a database failover occurs while the EMS server is performing a transactional activity, the EMS server does not replay or restart the failed transaction. However, a TAF connection allows the EMS server to recover fully as long as no transaction was taking place at the time of the failover.