Time for action – configuring FCF for JDBC connections

Let's see an example of how we can configure FCF for JDBC clients.

1. In order to run FCF as we configured it, we need to create database services where TAF or aq_ha_notifications is disabled. As we discussed, in 11gR2, it's possible to create role-specific database services so that service is automatically enabled or disabled whenever there is a role change. The following statements can be run on the primary and standby clusters to create a database service for a production service OLTP:

   • For the primary cluster, use the following:

     srvctl add service -d ORCL_PRIM -s OLTP -r prim_node1,prim_node2 -l PRIMARY -q FALSE -e NONE -m NONE -w 0 -z 0

   • For the standby cluster, use the following:

     srvctl add service -d ORCL_STD -s OLTP -r std_node1,std_node2 -l    PRIMARY -q FALSE -e NONE -m NONE -w 0 -z 0

   If needed, the following statements will create a read-only service for reporting on the physical standby database:

   • For the primary cluster, use the following...