OracleRAC數據庫測試報告

1、1. RAC配置1.1環(huán)境架構網上交易客戶I 口 口客戶日常業(yè)務RA集群業(yè)務直銷中間件局部查詢DSDBServer3DSDBServer4DSDBServer2丿Logical DataGuard硬件DSDBServer1-4 配置相同硬件供應商：HP型號CPUIn tel(R) Xeo n(R) CPU E7 883732內存64GB磁盤網絡主機IPVIP私有IPdsdbserver1dsdbserver22dsdbserver33dsdbserver44對應網卡BOND0BONDO:1ETH2ETH0&&ETH1網速1000Mb/s100Mb/s私有網絡為 百兆建議更換為千

2、兆網絡連接操作系統(tǒng)DSDBServer1-4 配置相同操作系統(tǒng)版本：內核：內核參數:=65536=65536=68719476736=4294967296=4096=250 32000 100 128-max = 101365n et.ipv4.ip_local_port_ra nge = 9000 65500=1048576=1048576=262144=2621441.2數據庫配置1.2.1 架構Public IPPublic VIPPublic IPPublic VIPTNSi!r1AMDB1, 1AMDBN1L_l -TNSPrivate IPCRSCRSASM DISKASM DIS

3、KRAW3EMCPOWERRAW3OCRVotingRAWJRAW2OCRVotingRAW1RAW：1.2.2 版本軟件版本CRSORACLE1.2.3 Spfile核心參數參數項值sga target32Gsga max size32Gpga aggregate target16GProcesses1000sessi ons1100optimizer modeALL ROWSlocal liste ner(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)remote liste nerLISTENERS AMDBspfile+DATA/amd

4、b/1.2.4 表空間分配表空間名字類型表空間大小(M)已使用(M)剩余可擴展空間(M)剩余可利用率DSSYNCPERMANENT1000EXAMPLEPERMANENT10032668STATPERMANENT1005020SYSAUXPERMANENT88031888SYSTEMPERMANENT47032298UNDOTBS1UNDO5520551927248UNDOTBS2UNDO165031118UNDOTBS3UNDO197530793USERSPERMANENT532763XNDSPERMANENT3091234624XNNSPERMANENT6016267521.2.5SQLN

5、et網絡偵聽節(jié)點 dsdbserver2 上 Listener.oraLISTENER_DSDBSERVER2 = (DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep2(PORT = 1521)(IP = FIRST)(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.12)(PORT = 1521)(IP = FIRST) )_)節(jié)點 dsdbserver2 上 tnsnames.oraLISTENERS_AMDB =(ADDRESS_LIST =(AD

6、DRESS = (PROTOCOL = TCP)(HOST = dsdbservep)(PORT = 1521)(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservvjp2(PORT = 1521)(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep3(PORT = 1521)AMDB3 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep3(PORT = 1521) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_

7、NAME = AMDB)(INSTANCE_NAME = AMDB3)AMDB2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep)(PORT = 1521) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = AMDB) (INSTANCE_NAME = AMDB2)AMDB1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep)(PORT = 1521) (CONNECT_DATA =(SERVER

8、= DEDICATED)(SERVICE_NAME = AMDB) (INSTANCE_NAME = AMDB1)AMDB =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep2(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = dsdbservep)(PORT = 1521) (LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER

9、= DEDICATED)(SERVICE_NAME = AMDB)AMDB_STANDBY=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = dsdbserver4)(PORT = 1521) )(CONNECT_DATA =(SERVICE_NAME = AMDB)2. 節(jié)點連接測試2.1單實例節(jié)點連接測試方法配置客戶端對 AMDB2和AMDB3同樣配置，sqlplus命令下逐一登錄NAMDB1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.51

10、)(PORT = 1521)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = AMDB)(INSTANCE_NAME = AMDB1)測試結果測試項測試結果備注AMDB1單節(jié)點連接正常AMDB2單節(jié)點連接正常AMDB3單節(jié)點連接正常2.2基于效勞的多地址連接測試方法配置客戶端，sqlplus命令下登錄NAMDB=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.51)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.

11、52)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.53)(PORT = 1521) (FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = AMDB) (FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 20)(DELAY = 5)222測試結果測試項測試結果備注基于效勞的多地址連接正常3. 負載均衡測試3.1測試方法客戶端配置NAMDB=(DESCRIPTION =(ADDRESS =

12、 (PROTOCOL = TCP)(HOST = 10.88.3.51)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.52)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.53)(PORT = 1521) (FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = AMDB) (FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES =

13、20)(DELAY = 5) 1bat 腳本 test.batecho offfor /l %i in (1,1,1000) do (echo %isqlplus -s system/gfjj1234 namdb )pause2SQL腳本 test.sqlSet headi ng offcol"In sta nce_n ame format a20select in sta nce_n ame from v$in sta nee /Exit;3運行測試4腳本運行完后，統(tǒng)計結果3.2測試結果實例名連接次數AMDB1196AMDB2337AMDB34674. FailOver 測試4.1

14、測試方法1、分別利用以下四種配置連接數據庫連接方式名Tnsn ames配己置NAMDBNAMDB=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.51)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.52)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.53)(PORT = 1521) (FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVIC

15、E_NAME = AMDB) (FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 20)(DELAY = 5)NAMDB00NAMDB00=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.51)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.52)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.53)(PORT = 1521) (CON

16、NECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = AMDB)NAMDB01NAMDBO仁(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.51)(PORT = 1521)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = AMDB)NAMDB1NAMDB1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.3.51)(PORT = 1521)(CONNECT_DATA =(SE

17、RVER = DEDICATED)(SERVICE_NAME = AMDB)(INSTANCE_NAME = AMDB1)2、查看連接的實際實例名select in sta nce_n ame from v$in sta nee;3、關閉實例Shutdow n immediate4、重新查看連接實例名select in sta nce_n ame from v$in sta nee;5、重連數據庫4.2測試結果連接方式名切換結果重連數據庫結果NAMDB成功切換正常NAMDB00斷開正常NAMDB01斷開正常NAMDB1斷開拒絕5. 節(jié)點參加測試5.1測試方法前提：網絡、操作系統(tǒng)級別SSH主機名

18、等RAC配置已完成，詳見 RAC安裝手冊1添加CRS登錄集群一節(jié)點老節(jié)點，執(zhí)行ORA_CRS_HOME/oui/bin的腳本，按提示一步一步做2更新ONS登錄集群一節(jié)點老節(jié)點，執(zhí)行命令ocrdump -stdout -ke yn ame查看ONS端口，或者在 ORA_CRS_HOME/opmn/conf下的查看并記錄端口號例如6200翻開ORA_CRS_HOME/bin目錄執(zhí)行命令./racg ons add_c onfig dsdbserver4:6200執(zhí)行olsondes查看添加效果3添加數據庫登錄集群一節(jié)點老節(jié)點，翻開ORACLE_HOME/out/bin執(zhí)行addNode.sh4更新

19、新節(jié)點網絡配置登錄集群一節(jié)點老節(jié)點，netca重新配置操作節(jié)點與新參加節(jié)點5配置新節(jié)點ASM登錄集群一節(jié)點 老節(jié)點，執(zhí)行 DBCA,選擇 “ con figure automatic storage man ageme nt 選擇新節(jié)點配置 ASM。6配置新節(jié)點實例登錄集群一節(jié)點老節(jié)點用system用戶登錄數據庫，執(zhí)行如下語句alter system set LOG_ARCHIVE_CONFIG= ' SEND, RECEIVE, NODG_CONFIG' scope=both;alter system set log_archive_dest_1='LOCATION=

20、/opt/app/oracle/archive' scope=both;alter system set log archive dest 2=" scope=both;執(zhí)行 DBCA命令->選擇 “ Instanee Management ->"Add Instanee 7更新所有節(jié)點網絡配置任一節(jié)點執(zhí)行netca，對所有節(jié)點listener重新配置5.2測試結果節(jié)點正常參加，并完成壓力測試6. 節(jié)點刪除測試6.1測試方法登陸非刪除節(jié)點1export ORACLE_SID=< 集群實例 >2執(zhí)行 DBCA3 選擇 Instance Mana

21、germent 實例管理 4 選擇 Delete an Instance 刪除實例5選擇需要刪除實例的 RAC數據庫，數據sysdba用戶和密碼6選擇需要刪除的實例，并點擊 Finish 完成，后面點擊 Ok-OK-OK 執(zhí)行： crs_stat 可查詢7執(zhí)行 NETCA8選擇 Cluster configuration 集群配置9選擇被刪除節(jié)點10選擇 Listener configuration 偵聽配置11選擇 Delete ，完成刪除節(jié)點偵聽 執(zhí)行： crs_stat 可查詢12執(zhí)行 srvctl stop asm -n node13執(zhí)行 srvctl remove asm -n no

22、de登陸刪除節(jié)點14刪除 ORACLE_BASEadmin+ASM 和 ORACLE_HOMEdbs*ASM* 附注徹底刪除ASM的步驟：1, 刪除 /etc/oratab 文件對應的 +ASM 記錄2, 刪除$0RACLE_BASE/admin/+ASM1-2下面的 a|b|c|u dump 目錄3, 刪除$ORACLE_HOME/dbs下面與asm有關的文件登陸刪除節(jié)點，執(zhí)行命令 ：15更新刪除節(jié)點 $ORACLE_HOME/oui/bin ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES="

23、;dsdbserver4" -local16執(zhí)行數據庫刪除 可選$ORACLE_HOME/oui/bin/runInstaller -deinstall登陸非刪除節(jié)點，執(zhí)行命令 ：17更新非刪除節(jié)點 $ORACLE_HOME/oui/bin ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=dsdbserver1,dsdbserver2,dsdbserver3"18在任意保存節(jié)點中執(zhí)行racgons命令，刪除ONS配置racgons remove_config node2:

24、remote_port例如：racgons remove_config dsdbserver4:6200remote port 可以登錄被刪除節(jié)點的 CRS_HOME/opmn/conf/ons.config登陸被刪除節(jié)點執(zhí)行以下命令 ：19停止和刪除被刪除節(jié)點的node applicationssrvctl stop nodeapps -n dsdbserver4srvctl remove nodeapps -n dsdbserver420更新被刪除節(jié)點的 CRSB息$ORA_CRS_HOME/oui/bin./runinstaller -updateNodeList ORACLE_HOME

25、=$ORA_CRS_HOME "CLUSTER_NODES=dsdbserver4"CRS=TRUE -local登陸非刪除節(jié)點，執(zhí)行命令：21丨更新非刪除節(jié)點的集群信息$ORA_CRS_HOME/oui/bin./runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME"CLUSTER_NODES=dsdbserver1,dsdbserver2,dsdbserver3" CRS=TRUE22登錄被刪除節(jié)點，刪除 CRS軟件$ORA_CRS_HOME/oui/bin./runInstaller -dei

26、nstall23如果沒有執(zhí)行22步驟，那么登錄被刪除節(jié)點執(zhí)行crsctl stop crs再登錄任意非刪除節(jié)點到$ORA_CRS_HOME/install 丨執(zhí)行./rootdeletenodes dsdbserver4,46.2測試結果將DSDBServer4正常刪除7. 壓力測試7.1測試方法利用swingbench免費軟件，版本安裝 java后，不需配配置文件7.1.1 建立OE數據啟動模板，生成 OE數據。按提示一步一步做，庫存數據庫 10G7.1.2 啟動協調效勞器執(zhí)行，啟動協調效勞器，協調進程啟動成功。7.1.3 注冊節(jié)點到協調效勞器swin gbe nch.bat -co loc

27、alhost -cs 10.88.3.51:1521:AMDB1 -g AMDB1 -dt thinswingbench.bat -co localhost -cs 10.88.3.52:1521:AMDB2 -g AMDB2 -dt thinswingbench.bat -co localhost -cs 10.88.3.53:1521:AMDB3 -g AMDB3 -dt thin7.1.4 修改紅色字體d 1 d 2 d 3 i != 一 i = 端端端端裁 戶戶戶戶戶戶J 7.<?xml version = '1.0' en codi ng = 'UTF

28、-8'?><ClusterOverviewC on figurati on xmln s=":domi ni cgiles/sw in gbe nch"><Coord in ator><HostName>localhost </HostName></Coordin ator><Prefere nces><MonitoredUsers> soe</MonitoredUsers> <RefreshPeriod>5</RefreshPeriod>

29、<Startl nOrder>false</Startl nOrder> <StabilitySamples>10</StabilitySamples> <StabilityTolera nce>2</StabilityTolera nce></Preferen ces><Mon itoredNodes><Mo nitoredNode><Groupld> AMDB1 </GroupId><DisplayName>AMDB1 </DisplayName><Co nn ectStri ng> 10.88.3.51:1521:AMDB1 </Co nn ectStri ng></Mo nitoredNode><Mo nitoredNode><Groupld>AMDB2</Groupld><DisplayName>AM