_BALANCE=YES)
(
CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RACDB)
(
FAILOVER_MODE= (TYPE=session/select)(METHOD=basic) (RETRIES=180)(DELAY=5)
)
)
)
配置服务器的TAF
添加Service-side TAF
1、检查是否配置了Service-side TAF
[grid@dou_rac2 ~]$ srvctl config service -d racdb
--无返回结果，说明没有配置service
2、检查监听中是否注册监听了Service-side TAF 服务
[grid@dou_rac2 ~]$ lsnrctl status LISTENER_SCAN1
[oracle@rac2 admin]$ srvctl add service -d racdb -s racdb_taf -r "racdb1,racdb2" -P basic
[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....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@rac2 admin]$ srvctl enable service -d racdb -s racdb_taf
PRKP-1018 : Service racdb_taf already enabled.
启动服务
[oracle@rac2 admin]$ srvctl start service -d racdb -s racdb_taf
确认服务状态。Online 说明已启动
[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....DB1.srv application ONLINE ONLINE rac1
ora....DB2.srv application ONLINE ONLINE rac2
ora...._taf.cs application ONLINE ONLINE rac1
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
未配置前的service 名
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string RACDB
配置后的，新建的服务会自动添加到初始话参数中：
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string racdb_taf, RACDB
并且监听里面也有了
[oracle@rac1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 12-OCT-2013 21:09:04
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 12-OCT-2013 20:08:37
Uptime 0 days 1 hr. 0 min. 27 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP OFF
Listener Parameter File /opt/ora10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/ora10g/product/10.2.0/db_1/network/log/l