rac failover and load_balance
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() à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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-734255/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rac failover and load_balance簡單使用AI
- RAC的兩大應用特性FAILOVER和LOAD_BALANCE總結AI
- Oracle RAC Failover 詳解OracleAI
- oracle rac failover 詳解OracleAI
- oracle rac failover的疑惑OracleAI
- Oracle RAC TAF 無縫failoverOracleAI
- 轉:Oracle RAC Failover 詳解OracleAI
- Oracle RAC Failover 詳解[轉帖]OracleAI
- dataguard switchover & failover steps (rac)AI
- 邏輯 rac standby和物理 rac standby的switchover 和 failoverAI
- TNSNAMES TAF TEMPLATE , LOCAL_LISTENER RAC FAILOVERAI
- RAC環境STANDBY的FAILOVER切換AI
- RAC+Dataguard環境中JDBC Failover配置JDBCAI
- 如何配置Oracle RAC Load Balance 及FailOverOracleAI
- Oracle RAC 客戶端故障轉移(failover) TAFOracle客戶端AI
- [zt] Oracle RAC的Failover設定與測試OracleAI
- RAC環境LOGICAL STANDBY的FAILOVER切換AI
- Oracle RAC 客戶端FAILOVER LOADBALANCE特性的配置方法Oracle客戶端AI
- RAC 11g下管理Service資源並測試FailoverAI
- Oracle RAC Failove 之一:Client-Side Connect Time FailoverOracleAIclientIDE
- REMOTE_LISTENER對LOAD_BALANCE的影響(二)REM
- REMOTE_LISTENER對LOAD_BALANCE的影響(一)REM
- redis_failover - Automatic Redis Failover Client/ServerRedisAIclientServer
- Flink -- FailoverAI
- 靜態FAILOVERAI
- 關於failoverAI
- Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE?JDBCAI
- ASA failover配置(A/S)AI
- DG 進行failoverAI
- DataGuard:Physical Standby FailoverAI
- Oracle dataguard failover 實戰OracleAI
- oracle Physical Standby failover stepOracleAI
- Oracle Data Guard Failover(activate)OracleAI
- 主備切換(failover)AI
- In Data Guard,choose switchover or failover?AI
- 10g_dataguard_failoverAI
- DataGuard:Logical Standby FailoverAI
- data guard failover on solaris 10AI