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博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-1058691/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-1058691/