Service name

Select * from dba_services

alter system set service_names=a,b,c,d;

select service_name from v$session where sid=(select sid from v$mystat where rownum=1) àcheck the service name

select * from v$servicemetric à查看业务情况一起负载。

1.failover

a).connect time failover àclient端实现的

把地址列表加进去，连的时候选择实现。

b).TAF(transparent application failover) àclient端实现的

(FAILOVER_MODE =

(TYPE = SELECT) --select/session(转移session)

(METHOD = BASIC)

(RETRIES = 180) --尝试180次

(DELAY = 5) --每过5ms尝试一次

)

c).TAF(transparent application failover) àservice端实现的

dbms_service package 修改service的属性

exec dbms_service.modify_service(

service_name=>'myrac',

failover_method => dbms_service.failover_method_basic,

failover_type => dbms_service.failover_type_select,

failover_retries=>100,

failover_delay => 5)

---tnsname.ora

MYRAC_TAF_S =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.18.193)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.18.194)(PORT = 1521))

(LOAD_BALANCE = yes)

)

(CONNECT_DATA =

(SERVICE_NAME = myrac)

)

2.load_balance

a).client

主要加了:

(LOAD_BALANCE = yes)

b).server

利用参数：

Remote_listener

[@more@]

ITPub博客

rac failover and load_balance简单使用