all about Oracle RAC Failover(三)
LOAD_BALANCE=YES)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=RAC)
)
)
注意：无论是使用dbca 工具还是使用srvctl 命令来配置service，都无法配置TAF的TYPE,DELAY,RETRIES 三个属性，必须使用dbms_service包来修改这些属性。
注意：
客户端tnsnames.ora 中的service_name 要写我们的service-side TAF的名称。可以通过一下方式查看：
SQL> showparameter service
NAME TYPE VALUE
----------------------------------------------- -----------------
service_names string dave, dave_taf
然后可以验证：
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------
instance_name string rac1
SQL> select sid from v$mystat where rownum=1;
SID
----------
146
SQL> select failover_type,failover_method,failed_over from v$session where sid=146;
FAILOVER_TYPE FAILOVER_M FAILED_OVE
------------- ---------- ----------
SELECT BASIC YES
--如果客户端写的不是SERVICE-SIDE TAF的名称，而是实例的名称，那么不影响数据库的连接，但是无法实现TAF功能。
四． Srvctl 命令测试实例
先查看一下RAC 启动情况：
[root@raw1 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.raw.db application ONLINE ONLINE raw1
ora.raw.raw.cs application ONLINE ONLINE raw1
ora....aw1.srv application ONLINE ONLINE raw1
ora....aw2.srv application ONLINE ONLINE raw2
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
[root@raw1 bin]# ps -ef | grep smon
root 17483 3479 0 07:30 pts/1 00:00:00 grep smon
oracle 26561 1 0 07:06 00:00:01 asm_smon_+ASM1
oracle 27082 1 0 07:06 00:00:05 ora_smon_raw1
一切正常。
1） 查看现有的service
[root@raw1 bin]# su - oracle
[oracle@raw1 ~]$ export ORACLE_SID=raw1
[oracle@raw1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 3 07:45:36 2010
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter service
NAME TYPE VALUE
------------------------------ ----------- ------------------------
service_names string raw
SQL>
2）使用srvctl 命令创建dmm 服务
[oracle@raw2 bin]$ srvctl add service -d raw -s dmm -r "raw1,raw2" -P basic
[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....aw2.srv application OFFLINE OFFLINE
ora....w1.inst a