操作过程:
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE racdb_b
ora....oltp.cs application ONLINE OFFLINE
ora....cl1.srv application ONLINE OFFLINE
ora....cl2.srv application ONLINE OFFLINE
ora....l1.inst application ONLINE ONLINE racdb_a
ora....l2.inst application ONLINE ONLINE racdb_b
ora....SM1.asm application ONLINE ONLINE racdb_a
ora...._A.lsnr application ONLINE ONLINE racdb_a
ora....b_a.gsd application ONLINE ONLINE racdb_a
ora....b_a.ons application ONLINE ONLINE racdb_a
ora....b_a.vip application ONLINE ONLINE racdb_a
ora....SM2.asm application ONLINE ONLINE racdb_b
ora...._B.lsnr application ONLINE ONLINE racdb_b
ora....b_b.gsd application ONLINE ONLINE racdb_b
ora....b_b.ons application ONLINE ONLINE racdb_b
ora....b_b.vip application ONLINE ONLINE racdb_b
$ srvctl remove service -d orcl -s oltp
oltp PREF: orcl1 orcl2 AVAIL:
Remove service oltp from the database orcl? (y/[n]) y
PRKP-1024 : The service oltp is still running. --猜想Target ONLINE引起的
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE racdb_b
ora....oltp.cs application ONLINE OFFLINE
ora....cl1.srv application ONLINE OFFLINE
ora....cl2.srv application ONLINE OFFLINE
ora....l1.inst application ONLINE ONLINE racdb_a
ora....l2.inst application ONLINE ONLINE racdb_b
ora....SM1.asm application ONLINE ONLINE racdb_a
ora...._A.lsnr application ONLINE ONLINE racdb_a
ora....b_a.gsd application ONLINE ONLINE racdb_a
ora....b_a.ons application ONLINE ONLINE racdb_a
ora....b_a.vip application ONLINE ONLINE racdb_a
ora....SM2.asm application ONLINE ONLINE racdb_b
ora...._B.lsnr application ONLINE ONLINE racdb_b
ora....b_b.gsd application ONLINE ONLINE racdb_b
ora....b_b.ons application ONLINE ONLINE racdb_b
ora....b_b.vip application ONLINE ONLINE racdb_b
$ sh crs_stat.sh
Name Target State Host
------------------------------ ---------- --------- -------
ora.orcl.db ONLINE ONLINE racdb_b
ora.orcl.oltp.cs ONLINE OFFLINE
ora.orcl.oltp.orcl1.srv ONLINE OFFLINE
ora.orcl.oltp.orcl2.srv ONLINE OFFLINE
ora.orcl.orcl1.inst ONLINE ONLINE racdb_a
ora.orcl.orcl2.inst ONLINE ONLINE racdb_b
ora.racdb_a.ASM1.asm ONLINE ONLINE racdb_a
ora.racdb_a.LISTENER_RACDB_A.lsnr ONLINE ONLINE racdb_a
ora.racdb_a.gsd ONLINE ONLINE racdb_a
ora.racdb_a.ons ONLINE ONLINE racdb_a
ora.racdb_a.vip ONLINE ONLINE racdb_a
ora.racdb_b.ASM2.asm ONLINE ONLINE racdb_b
ora.racdb_b.LISTENER_RACDB_B.lsnr ONLINE ONLINE racdb_b
ora.racdb_b.gsd ONLINE ONLINE racdb_b
ora.racdb_b.ons ONLINE ONLINE racdb_b
ora.racdb_b.vip ONLINE ONLINE racdb_b
$ crs_stop -f ora.orcl.oltp.cs --改变Target 到OFFLINE状态
Target set to OFFLINE for `ora.orcl.oltp.cs`
$ crs_stop -f ora.orcl.oltp.orcl1.srv --改变Target 到OFFLINE状态
Target set to OFFLINE for `ora.orcl.oltp.orcl1.srv`
$ crs_stop -f ora.orcl.oltp.orcl2.srv --改变Target 到OFFLINE状态
Target set to OFFLINE for `ora.orcl.oltp.orcl2.srv`
$ srvctl remove service -d orcl -s oltp --移除service
oltp PREF: orcl1 orcl2 AVAIL:
Remove service oltp from the database orcl? (y/[n]) y
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE racdb_b
ora....l1.inst application ONLINE ONLINE racdb_a
ora....l2.inst application ONLINE ONLINE racdb_b
ora....SM1.asm application ONLINE ONLINE racdb_a
ora...._A.lsnr application ONLINE ONLINE racdb_a
ora....b_a.gsd application ONLINE ONLINE racdb_a
ora....b_a.ons application ONLINE ONLINE racdb_a
ora....b_a.vip application ONLINE ONLINE racdb_a
ora....SM2.asm application ONLINE ONLINE racdb_b
ora...._B.lsnr application ONLINE ONLINE racdb_b
ora....b_b.gsd application ONLINE ONLINE racdb_b
ora....b_b.ons application ONLINE ONLINE racdb_b
ora....b_b.vip application ONLINE ONLINE racdb_b
查看数据字典内容,这个时候还没有清除
sys@ORCL> select name,failover_method,failover_type,goal,clb_goal from dba_services;
oltp BASIC SELECT LONG
sys@ORCL> begin
2 dbms_service.delete_service(service_name=>'oltp');
3 end;
4 /
PL/SQL procedure successfully completed.
删除数据字典中的内容
到此移除完成。