3)确认服务创建成功,offline 表示还没有启动
[Oracle@raw2 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.raw.db application ONLINE ONLINE raw1
ora.raw.dmm.cs application OFFLINE OFFLINE
ora....aw1.srv application OFFLINE OFFLINE
ora.raw.raw.cs application ONLINE ONLINE raw1
ora....aw1.srv application ONLINE ONLINE raw1
ora....w1.inst application ONLINE ONLINE raw1
ora....w2.inst application ONLINE ONLINE raw2
ora....SM1.asm application ONLINE ONLINE raw1
ora....W1.lsnr application ONLINE ONLINE raw1
ora.raw1.gsd application ONLINE ONLINE raw1
ora.raw1.ons application ONLINE ONLINE raw1
ora.raw1.vip application ONLINE ONLINE raw1
ora....SM2.asm application ONLINE ONLINE raw2
ora....W2.lsnr application ONLINE ONLINE raw2
ora.raw2.gsd application ONLINE ONLINE raw2
ora.raw2.ons application ONLINE ONLINE raw2
ora.raw2.vip application ONLINE ONLINE raw2
4)配置这个服务自启动
[oracle@raw2 bin]$ srvctl enable service -d raw -s dmm
PRKP-1018 : Service dmm already enabled.
5)启动服务
[oracle@raw2 bin]$ srvctl start service -d raw -s dmm
6)确认服务状态。Online 说明已启动
[oracle@raw2 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.raw.db application ONLINE ONLINE raw1
ora.raw.dmm.cs application ONLINE ONLINE raw1
ora....aw1.srv application ONLINE ONLINE raw1
ora.raw.raw.cs application ONLINE ONLINE raw1
ora....w1.inst application ONLINE ONLINE raw1
ora....w2.inst application ONLINE ONLINE raw2
ora....SM1.asm application ONLINE ONLINE raw1
ora....W1.lsnr application ONLINE ONLINE raw1
ora.raw1.gsd application ONLINE ONLINE raw1
ora.raw1.ons application ONLINE ONLINE raw1
ora.raw1.vip application ONLINE ONLINE raw1
ora....SM2.asm application ONLINE ONLINE raw2
ora....W2.lsnr application ONLINE ONLINE raw2
ora.raw2.gsd application ONLINE ONLINE raw2
ora.raw2.ons application ONLINE ONLINE raw2
ora.raw2.vip application ONLINE ONLINE raw2
新建的服务会自动添加到初始话参数中:
SQL> show parameter service
NAME TYPE VALUE
----------------------------- ----------- --------------------
service_names string raw, dmm
7)用service TAF 修改配置,需要用dbms_service.Modify_service 包。
SQL> Begin
Dbms_service.modify_service(
Service_name=>'dmm',
Failover_method=>dbms_service.failover_method_basic,
Failover_type=>dbms_service.failover_type_select,
Failover_retries=>180,
Failover_delay=>5
);
End;
/
PL/SQL procedure successfully completed.
8) 确认参数已经生效
SQL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
NAME FAILOVER_METHOD FAILOVER_TYPE GOAL CLB_G
---------------------------------- --------------
SYS$BACKGROUND NONE SHORT
SYS$USERSNONE SHORT
seeddataXDB LONG
seeddata.regress.rdb LONG
rawXDB LONG
rawLONG
dmm BASICSELECT LONG
7 rows selected.
9) 也可以用srvctl 命令查看配置情况
[oracle@raw2 bin]$ srvctl config service -d raw -s dmm -a
dmm PREF: raw1 AVAIL: raw2 TAF: basic
10)删除Service
先关闭service:
[oracle@raw2 bin]$ srvctl stop service -d raw -s dmm
[oracle@raw2 bin]$ srvctl disable service -d raw -s dmm
删除服务:
[oracle@raw2 bin]$ srvctl remove service -d raw -s dmm
dmm PREF: raw1 AVAIL: raw2
Service dmm is disabled.
Remove service dmm from the database raw? (y/[n]) y
如果该命令清楚不掉,我们可以加上-f 参数
[oracle@raw2 bin]# ./srvctl remove service -d raw -s dmm -f
OCR中的信息已经被删除了,但是数据字典中的还有该service的内容,继续清除数据字典中的内容。
先查看数据字典内容:
SQL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
NAME FAILOVER_METHOD FAILOVER_TYPE GOAL CLB_G
-------------------- --------------- ----------------------- -----
SYS$BACKGROUND NONE SHORT
SYS$USERSNONE SHORT
seeddataXDB LONG
seeddata.regress.rdb LONG
rawXDBLONG
raw LONG
dmmBASICSELECT LONG
7 rows selected.
清除数据字典里的内容:
SQL> begin
2 dbms_service.delete_service(service_name=>'dmm');
3 end;
4 /
PL/SQL procedure successfully completed.
再次查询数据字典,没有了数据。清除完成
SQL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
NAME FAILOVER_METHOD FAILOVER_TYPE GOAL CLB_G
-------------------- --------------- ----------------------- -----
SYS$BACKGROUND NONE SHORT
SYS$USERSNONE SHORT
seeddataXDB LONG
seeddata.regress.rdb LONG
rawXDBLONG
raw LONG
6 rows selected.