Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to configure and test TAF in oracle". In daily operation, I believe many people have doubts about how to configure and test TAF in oracle. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts about "how to configure and test TAF in oracle"! Next, please follow the small series to learn together!

1. Add services_taf: [root@ora19crac1 ~]# su - oracleLast login: Tue Mar 3 18:06: CST 2020 on pts/1[oracle@ora19crac1 ~]$ srvctl add service -d woo -s server_taf -r "woo1,woo2" -P BASIC II, Start server_taf[oracle@ora19crac1 ~]$srvctl start service -d woo -s server_taf three, Check server_taf runtime [oracle@ora19crac1 ~]$ srvctl config service -d wooService name: server_tafServer pool: Cardinality: 2Service role: PRIMARYManagement policy: AUTOMATIC DTP transaction: falseAQ HA notifications: falseGlobal: falseCommit Outcome: falseFailure type: Failure method: Failover retries: Failover delay: Failover restore: NONEConnection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Pluggable database name: Hub service: Maximum lag time: ANYSQL Translation Profile: Retention: 86400 secondsReplay Initiation Time: 300 secondsDrain timeout: Stop option: Session State Consistency: DYNAMICGSM Flags: 0Service is enabledPreferred instances: woo1,woo2Available instances: CSS critical: noService uses Java: SQL> select name,service_id from dba_services where name ='server_taf'; NAME SERVICE_ID--------------- ----------server_taf SQL> col name format a15 SQL> col failover_method format a11 heading 'METHOD'SQL> col failover_type format a10 heading 'TYPE'SQL> col failover_retraces format 99999 heading 'RETRIES'SQL> col goal format a10SQL> col clb_goal format a8SQL> col AQ_HA_NOTIFICATIONS TIPS format a5 heading 'AQNOT'SQL> select name, failover_method, failover_type, failover_retraces, goal, clb_goal,aq_ha_notifications 2 from dba_services where service_id = 3; NAME METHOD TYPE RETRIES GOAL CLB_GOAL AQNOT--------------- ----------- ---------- -------- ---------- -------- -----server_taf 0 NONE LONG NO VI, Repair fault transfer parameter strategy [oracle@ora19crack1 ~]$ srvctl modify service -d woo -s server_taf -m BASIC -e SELECT -q TRUE -j LONG[oracle@ora19crack1 ~]$ srvctl config service -d wooService name: server_tafServer pool: Cardinality: 2Service role: PRIMARYManagement policy: AUTOMATIC DTP transaction: falseAQ HA notifications: trueGlobal: falseCommit Outcome: falseFailure type: SELECTFailure method: BASICFailover retries: Failover delay: Failover restore: NONEConnection Load Balancing Goal: LONGRuntime Load Balancing Goal: NONETAF policy specification: BASICEdition: Pluggable database name: Hub service: Maximum lag time: ANYSQL Translation Profile: Retention: 86400 secondsReplay Initiation Time: 300 secondsDrain timeout: Stop option: Session State Consistency: DYNAMICGSM Flags: 0Service is enabledPreferred instances: woo1,woo2Available instances: CSS critical: noService uses Java: false VII. Examining the service again, we can see that the values all have SQL> col name format a15 SQL> col failover_method format a11 heading 'METHOD'SQL> col failover_type format a10 heading 'TYPE'SQL> col failover_repeats format 99999 heading 'RETRIES'SQL> col goal format a10SQL> col clb_goal format a8SQL> col AQ_HA_NOTIFICATIONS format a5 heading 'AQNOT'SQL> select name, failover_method, failover_type, failover_retries,goal, clb_goal,aq_ha_notifications 2 from dba_services where service_id = 3; NAME METHOD TYPE RETRIES GOAL CLB_GOAL AQNOT--------------- ----------- ---------- -------- ---------- -------- -----server_taf BASIC SELECT 0 NONE LONG YES 8. Check if the service is registered to listen [oracle@ora19crac1 ~]$ lsnrctl services LSNRCTL for Linux: Version 19.0.0.0- Production on 19-MAR-2020 16:58:22 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Services Summary...……Service "server_taf" has 1 instance(s). Instance "woo1", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "woo" has 1 instance(s). Instance "woo1", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER SQL> col host_name format a11;SQL> select instance_name,host_name from v$instance; INSTANCE_NAME HOST_NAME---------------- -----------woo2 ora19crac2 XI. Open a new window to close this instance SQL> shut abortORACLE instance shut down. XII. The query can proceed normally, but there will be temporary locks SQL> col host_name format a11;SQL> select instance_name,host_name from v$instance; INSTANCE_NAME HOST_NAME---------------- -----------woo2 ora19crac2 At this point, the study of "how to configure and test TAF in oracle" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.