srvctl add service -d asmdb -s asmdbs -r “asmdb1,asmdb2″ -P BASIC
srvctl start service -d asmdb -s asmdbs
srvctl config service -d asmdb
SQL> select name,service_id from dba_services where name = ‘asmdbs’;
SQL> select name, failover_method, failover_type, failover_retries,goal,
clb_goal,aq_ha_notifications from dba_services where service_id = 4;
SQL> execute dbms_service.modify_service (service_name => ‘asmdb’ -
, 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);
srvctl start service -d asmdb -s asmdbs
srvctl config service -d asmdb
SQL> select name,service_id from dba_services where name = ‘asmdbs’;
SQL> select name, failover_method, failover_type, failover_retries,goal,
clb_goal,aq_ha_notifications from dba_services where service_id = 4;
SQL> execute dbms_service.modify_service (service_name => ‘asmdb’ -
, aq_ha_notifications => true -
, failover_method => dbms_service.failover_method_
, failover_type => dbms_service.failover_type_
, failover_retries => 180 -
, failover_delay => 5 -
, clb_goal => dbms_service.clb_goal_long);