istener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.200)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RACDB" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
Service "RACDBXDB" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
Service "RACDB_XPT" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
Service "racdb_taf" has 1 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
The command completed successfully
也可以用srvctl 命令查看配置情况
[oracle@rac1 ~]$ srvctl config service -d RACDB -s racdb_taf -a
racdb_taf PREF: RACDB1 RACDB2 AVAIL: TAF: basic
select name, failover_method, failover_type, goal, clb_goal
from dba_services;
---------------------------------------
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
RACDBXDB LONG
RACDB LONG
racdb_taf NONE LONG
用service TAF 修改配置，需要用dbms_service.modify_service包。
SQL> begin
dbms_service.modify_service(
service_name=>'racdb_taf',
failover_method=>dbms_service.failover_method_basic,
failover_type=>dbms_service.failover_type_select,
failover_retries=>180,
failover_delay=>5);
end;
/
确认参数已经生效
SYS$BACKGROUND NONE SHORT
SYS$USERS NONE SHORT
RACDBXDB LONG
RACDB LONG
racdb_taf BASIC SELECT NONE LONG
10） 删除Service
先关闭service：
[oracle@rac1 ~]$ srvctl stop service -d RACDB -s racdb_taf
[oracle@rac1 admin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora.RACDB.db application ONLINE ONLINE rac2
ora....DB1.srv application OFFLINE OFFLINE
ora....DB2.srv application OFFLINE OFFLINE
ora...._taf.cs application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
[oracle@rac1 ~]$ srvctl disable service -d RACDB -s racdb_taf
删除服务：
[oracle@rac1 ~]$ srvctl remove service -d RACDB -s racdb_taf
dcsrv PREF: vic1 AVAIL: vic2
Service dcsrv is disabled.
Remove service dcsrv from the database vic? (y/[n]) y
如果该命令清楚不掉，我们可以加上-f 参数
[oracle@rac2 admin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ap