Tuesday, June 26, 2012

Oracle RAC: TAF Config: Case Study

Oracle RAC: TAF Config: Case Study



Login as oracle user.


grid@infyrac1@INFY_RAC_NODE1 /home/grid$ su - oracle
oracle's Password:
Add Serverside TAF:
oracle@infyrac1@INFY_RAC_NODE1 /home/oracle$ srvctl add service -d PA2ICBL2 -s server_taf -r "PA2ICBL21,PA2ICBL22" -P BASIC


PA2ICBL2: database unique name
PA2ICBL21,PA2ICBL22: Instances


Now start the service:


oracle@infyrac1@INFY_RAC_NODE1 /home/oracle$ srvctl start service -d PA2ICBL2 -s server_taf




Now check:


oracle@infyrac1@INFY_RAC_NODE1 /home/oracle$ srvctl config service -d PA2ICBL2
Service name: server_taf
Service is enabled
Server pool: PA2ICBL2_server_taf
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: 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: PA2ICBL21,PA2ICBL22
Available instances:
oracle@infyrac1@INFY_RAC_NODE1 /home/oracle$




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_notifications => true -
> , failover_method => dbms_service.failover_method_basic -
> , failover_type => dbms_service.failover_type_select -
> , failover_retries => 180 -
> , failover_delay => 5 -
> , clb_goal => dbms_service.clb_goal_long);


PL/SQL procedure successfully completed.






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


NAME
----------------------------------------------------------------
FAILOVER_METHOD
----------------------------------------------------------------
FAILOVER_TYPE
----------------------------------------------------------------
FAILOVER_RETRIES GOAL         CLB_G AQ_
---------------- ------------ ----- ---
server_taf
BASIC
SELECT
             180 NONE         LONG  YES

No comments:

Post a Comment