IT168RACLoadBalancingFailoverWord文档格式.docx
- 文档编号:18409551
- 上传时间:2022-12-16
- 格式:DOCX
- 页数:22
- 大小:2.85MB
IT168RACLoadBalancingFailoverWord文档格式.docx
《IT168RACLoadBalancingFailoverWord文档格式.docx》由会员分享,可在线阅读,更多相关《IT168RACLoadBalancingFailoverWord文档格式.docx(22页珍藏版)》请在冰豆网上搜索。
负载均衡
Client-sideLoadBalancing
Þ
ConnectionBalancing=client-sideconnect-time
LB
Server-sideLoadBalancing
ListenerBalacing=server-sideconnect-timeLB
RuntimeServiceBalancing=runtimeconnection
loadbalancing
TNSNAMES.ORA:
RACDB=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=vip1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=vip2)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=vip3)(PORT=1521))
(LOAD_BALANCE=yes)
)
(CONNECT_DATA=
(SERVICE_NAME=racdb)
)
netmgr
Listener(Connection)Balancing
Oracle9iandHigher
ServiceBalancing
OnlyonOracle10gR2andHigher
ListenerBalancing
sql>
ALTERsystemSET
REMOTE_LISTENER='
LISTENERS_RAC'
scope=BOTH;
LISTENERS_RAC=
ListenerLog
Oracle10g:
$ORACLE_HOME/log
Oracle11g:
diagnostic_dest/diag/tnslsnr/<
hostname>
/listener/tr
ace
ServiceRegister
18-11月-200911:
54:
07*service_register*orcl11g*0
ServiceUpdate
13*service_update*orcl11g*0
LoadBased&
SessionBased
PREFER_LEAST_LOADED_NODE_
Ø
UndocumentedparameteronOracle9.2.0.3andhigher
Defaultsto“ON”
PREFER_LEAST_LOADED_NODE_<
LISTENER_NAME>
=OFF
<
=listener_nodename
After10gR2,settheCLB_GOALonthe
service
Powerfulautomaticworkloadmanagement
DefinePREFERREDinstances
DefineAVAILABLEinstances
srvctladdservice-dorcl-sorclcluster-r"
orcl1,orcl2"
-a"
orcl3,orcl4"
Runtimeloadbalancing
OppositetoConnecttimeloadbalancing
ServiceStatistics
LoadBalancingAdvisory
Oracle10gR2andAbove
Allowslistenerstodistributeconnectionrequeststobest
instances.
Howtoenable
EXECUTEDBMS_SERVICE.MODIFY_SERVICE(
service_name=>
'
OE'
-,
goal=>
DBMS_SERVICE.GOAL_SERVICE_TIME-,
clb_goal=>
DBMS_SERVICE.CLB_GOAL_SHORT);
DBMS_SERVICE.MODIFY_SERVICE
GOALType
GOAL_NONE
GOAL_SERVICE_TIME
GOAL_THROUGHPUT
CLBGOALType
CLB_GOAL_SHORT
CLB_GOAL_LONG
Value
1
2
Description
LoadBalancingAdvisoryisdisabled
LoadBalancingAdvisoryisenabled
ConnectionloadbalancingusesLoad
BalancingAdvisorybasedonGOALType
Balancesthenumberofconnectionsper
instanceusingsessioncountperservice
LoadBalancingIssues
MetalinkNote:
364855.1
Subject:
RACConnectionRedirectedToWrong
Host/IPORA-12545
ORA-12545:
Connectfailedbecausetargethostorobjectdoesnotexist
ORA-01017whenorapwdfilenotidentical
ORA-01017:
invalidusername/password;
logondenied
Failover
失效接管
Client-sideFailover
ConnectTimeFailover
TransparentApplicationFailover(TAF)
Serer-sideFailover
TransparentApplicationFailover(TAF)with
Service
TnsnamesParameter:
FAILOVER
(failover=on)isdefaultforADDRESS_LISTs,
DESCRIPTION_LISTs
Client-sideConnectTimeFailover
TAF
FAILOVER_MODE
FeatureoftheOracleCallInterface(OCI)driverat
clientside
Mustmodifytnsnames.oramanually
Client-sideTAF
(ADDRESS=(PROTOCOL=TCP)(HOST=vip4)(PORT=1521))
(FAILOVER_MODE=
(TYPE=SELECT)
(METHOD=BASIC))
Server-sideTAF
Usedbms_service.modify_service
orcl1,orcl2”-PBASIC
executedbms_service.modify_service
(service_name=>
orclcluster'
DBMS_SERVICE.GOAL_SERVICE_TIME,
dbms_service.CLB_GOAL_SHORT,
failover_method=>
dbms_service.FAILOVER_METHOD_BASIC,
failover_type=>
dbms_service.FAILOVER_TYPE_SESSION,
failover_retries=>
20,
failover_delay=>
5,
aq_ha_notifications=>
true);
OnlyBASICmethodissupportedwithserver
sideTAF(whichistosay,PRECONNECTis
notsupported).
Boththeclientandservermustbe10.2and
aq_ha_notificationsmustbesettotrueforthe
service.
Onlyserversideservicesettings
FailoverIssues
ORA-01034withGLOBAL_DBNAME
SID_LIST_LISTENER_PROD2=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=prod)
(ORACLE_HOME=/oracle/product/9.2)
(SID_NAME=prod2)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- IT168RACLoadBalancingFailover