1.创建TAFService
[oracle@rac1 ~]$ srvctl add service -d pandb -s server_taf -r "pandb1,pandb2" -P BASIC
2. 启动server_taf服务
[oracle@rac1 ~]$ srvctl start service -d pandb -s server_taf
3. 检查service运行情况
[oracle@rac1 ~]$ srvctl config service -d pandb
4.确认serviceID
SQL> select name,service_id from dba_services where name = 'server_taf';
5.给service添加参数:
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);
6. 确认参数修改:
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_NOTIFICATIONS format a5 heading 'AQNOT'
SQL> select name, failover_method,failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3;
7. 检查service注册情况:
[oracle@db1 bin]$ lsnrctl services1.创建TAFService
[oracle@rac1 ~]$ srvctl add service -d pandb -s server_taf -r "pandb1,pandb2" -P BASIC
2. 启动server_taf服务
[oracle@rac1 ~]$ srvctl start service -d pandb -s server_taf
3. 检查service运行情况
[oracle@rac1 ~]$ srvctl config service -d pandb
4.确认serviceID
SQL> select name,service_id from dba_services where name = 'server_taf';
5.给service添加参数:
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);
6. 确认参数修改:
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_NOTIFICATIONS format a5 heading 'AQNOT'
SQL> select name, failover_method,failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3;
7. 检查service注册情况:
[oracle@db1 bin]$ lsnrctl services
[oracle@rac1 ~]$ srvctl add service -d pandb -s server_taf -r "pandb1,pandb2" -P BASIC
2. 启动server_taf服务
[oracle@rac1 ~]$ srvctl start service -d pandb -s server_taf
3. 检查service运行情况
[oracle@rac1 ~]$ srvctl config service -d pandb
4.确认serviceID
SQL> select name,service_id from dba_services where name = 'server_taf';
5.给service添加参数:
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);
6. 确认参数修改:
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_NOTIFICATIONS format a5 heading 'AQNOT'
SQL> select name, failover_method,failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3;
7. 检查service注册情况:
[oracle@db1 bin]$ lsnrctl services1.创建TAFService
[oracle@rac1 ~]$ srvctl add service -d pandb -s server_taf -r "pandb1,pandb2" -P BASIC
2. 启动server_taf服务
[oracle@rac1 ~]$ srvctl start service -d pandb -s server_taf
3. 检查service运行情况
[oracle@rac1 ~]$ srvctl config service -d pandb
4.确认serviceID
SQL> select name,service_id from dba_services where name = 'server_taf';
5.给service添加参数:
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);
6. 确认参数修改:
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_NOTIFICATIONS format a5 heading 'AQNOT'
SQL> select name, failover_method,failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3;
7. 检查service注册情况:
[oracle@db1 bin]$ lsnrctl services