Oracle11gR2RACService-SideTAF configuration example

Oracle11gR2RACService-SideTAF configuration example

Oracle 11gR2 RAC Service-Side TAF configuration example

How To Configure Server Side TransparentApplication Failover [ID 460982.1]

[Oracle @ db1 bin] $./srvctl add service-d orcl-s server_taf-r "orcl1, orcl2"-P BASIC

-- Here, orcl is the database name, And orcl1 and orcl2 are instance names.

[Oracle @ db1 bin] $./srvctl start service-d orcl-s server_taf

[Oracle @ db1 bin] $./srvctl config service-d orcl

Service name: server_taf

Service is enabled

Server pool: orcl_server_taf

Cardinality: 2

Disconnect: false

Service role: PRIMARY

Management policy: AUTOMATIC

DTP transaction: false

Aq ha specifications: false

Failover type: NONE

Failover method: NONE

TAF failover retries: 0

TAF failover delay: 0

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: NONE

TAF policy specification: BASIC

Edition:

Preferred instances: orcl1, orcl2

Available instances:

SQL> select name, service_id from dba_services where name = 'server _ taf ';

NAME SERVICE_ID

--------------------------------------------------------------------------

Server_taf 3

SQL> execute dbms_service.modify_service (service_name => 'server _ taf '-
, Aq_ha_configurications => true-
, Failover_method => dbms_service.failover_method_basic-
, Failover_type => dbms_service.failover_type_select-
, Failover_retries = & gt; 180-
, Failover_delay => 5-
, Clb_goal => dbms_service.clb_goal_long );

6.Confirm parameter modification:

Col name format a15
Col failover_method format a11 heading 'method'
Col failover_type format a10 heading 'type'
Col failover_retries format 9999999 heading 'retries'
Col goal format a10
Col clb_goal format a8
Col aq_ha_ications ications format a5 heading 'aqnot'

SQL> select name, failover_method, failover_type, failover_retries, goal, clb_goal, aq_ha_ications ications from dba_services where service_id = 3;

Name method type retries goal CLB_GOAL AQNOT

-------------------------------------------------------------------

Server_taf basic select 180 NONE LONG YES

SQL>