Optimize Distributed Workload - Expert Oracle RAC Performance Diagnostics and Tuning - page 510

Step 1
The first step in the process is to ensure that the server pools required for the workshop have been configured using
the following commands:
[oracle@sskyl1p1 -]$ $GRID_HOME/bin/srvctl config srvpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: SCDB_POOL
Importance: 0, Min: 3, Max: 3
Category:hub
Candidate server names:
Server pool name: SCDB_POOL2
Importance: 0, Min: 0, Max: 1
Category:
Candidate server names:
Step 2
The next step in configuring the applications defined in Table 15-5 is to map them to their respective instances and
implement the preferred/available rules. For our example, we define these services to database mapping using the
srvctl utility:
[oracle@ssky1l1p1 ~]$ srvctl modify service -d SCDB -service TAPS -pdb SPDB -g SCDB_POOL
[oracle@ssky1l1p1 ~]$ srvctl modify service -d SCDB -service FIPS -pdb SPDB -g SCDB_POOL
[oracle@ssky1l1p1 ~]$ srvctl modify service -d SCDB -service SSKY -pdb SPDB -g SCDB_POOL
[oracle@ssky1l1p1 ~]$ srvctl modify service -d SCDB -service TICKS -pdb SPDB -g SCDB_POOL2
[oracle@ssky1l1p1 ~]$ srvctl modify service -d SCDB -service GRUD -pdb SPDB -g SCDB_POOL
Step 3
At this point, the user has to decide if the applications will use the FAN feature called FCF or the standard Transparent
Application Failover (TAF) feature or both. If the application will use the TAF feature to enable failover, then based
on the criticality of the application the appropriate TAF policies, it should be added to the service definition using the
srvctl utility. The remainder of the applications will be configured to have the BASIC policy.
srvctl modify service -d SCDB -s FIPS -P BASIC -failovertype SELECT -failovermethod BASIC
-failoverdelay 25 -failoverretry 125
srvctl modify service -d SCDB -s SSKY -P BASIC -failovertype SELECT -failovermethod BASIC
-failoverdelay 25 -failoverretry 125 -notification TRUE
srvctl modify service -d SCDB -s GRUD -P NONE -failovertype SELECT -failovermethod BASIC
-failoverdelay 25 -failoverretry 125 -notification TRUE