O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required