Oracle安裝前準備
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470236JuyS.png"></a>
執行[oracle@rac1 ~]$ vi .bash_profile指令，設定上圖所示環境變量參數（根據實際情況）
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470237RANF.png"></a>
執行[root@rac1 ~]# vi /etc/profile指令，設定上圖所示參數
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470237zVEW.png"></a>
執行[root@rac1 ~]# vi /etc/sysctl.conf指令，設定上圖所示參數
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624702383WUb.png"></a>
執行[root@rac1 ~]# vi /etc/security/limits.conf指令，設定上圖所示參數
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470239a8nO.png"></a>
執行[root@rac1 ~]# vi /etc/pam.d/login指令，設定上圖所示參數
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470240AyvG.png"></a>
執行[root@rac1 ~]# vi /etc/hosts指令，根據實際情況配置IP與主機名對應關系
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470241ajm5.png"></a>
執行[root@rac1 ~]# vi /etc/iscsi.conf指令，在第76行将IP改為FreeNAS的IP并重新開機
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470242WQ5I.png"></a>
執行上圖所示指令對存儲進行分區操作
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624702432rf2.png"></a>
根據實際情況進行分區
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470244wnJo.png"></a>
執行[root@rac1 ~]# vi /etc/sysconfig/rawdevices指令，将分區加入裸裝置中
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_136247024500PF.png"></a>
執行[root@rac1 ~]# vi /etc/udev/permissions.d/50-udev.permissions指令，更改相關權限
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470246UsDH.png"></a>
執行上圖所示指令挂載裸裝置
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470247A9eV.png"></a>
建立SSH互信
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470248RpkR.png"></a>
在節點一進行上圖所示指令操作，建立ssh密鑰
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624702493H02.png"></a>
在節點二進行相同指令操作，建立ssh密鑰
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470251q1Rz.png"></a>
在主節點執行上圖所示指令，建立SSH互信
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470252N6W3.png"></a>
在兩個節點分别執行上圖所示指令，進行ssh互信的确認
安裝CRS
在CRS軟體存放路徑執行上圖所示指令，調出安裝頁面
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470257qfMT.png"></a>
出現歡迎頁面，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624702631rPG.png"></a>
确認第一次安裝所需的清單目錄，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470270t9mo.png"></a>
确認CRS安裝目錄，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624702758S8a.png"></a>
通過先決條件自檢後，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470281Kbm2.png"></a>
增加第二個節點相關資訊，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470288m4jK.png"></a>
通過Edit按鈕，将eth0網卡變為Public公用，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470294xhNZ.png"></a>
挂載OCR的路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470302GmBd.png"></a>
挂載Voting Disk路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470306sYhQ.png"></a>
确認無誤後，點選Install進行安裝
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470308ouRg.png"></a>
安裝完成後，在兩個節點執行上圖所示腳本
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470310JTC5.png"></a>
節點一執行完畢如上圖所示
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470312EsiM.png"></a>
在第二個節點執行腳本時，會報一個錯誤，這是由于Oracle 10g的bug引起的，需要我們手工執行一下vipca指令
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470312CbZU.png"></a>
執行上圖所示指令，調出vip配置頁面
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470314RKuy.png"></a>
在歡迎頁面點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470316jRd1.png"></a>
選擇第一塊網卡（需要Public的網卡），點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470318bgTy.png"></a>
配置兩個節點的vip别名（PS：一定隻用别名即可，不要用全名），點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470320xONY.png"></a>
确認無誤後，點選Finish完成
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470323ld8y.png"></a>
安裝完成後，點選OK按鈕
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470325Jwtz.png"></a>
确認配置摘要，點選Exit退出
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470326dPkE.png"></a>
确定真正腳本執行無誤後，再傳回上圖所示頁面點選OK按鈕（切記）
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470333ecwc.png"></a>
腳本執行OK後，後面一些配置才不會報錯，都做完後，點選Exit按鈕退出
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470335umrk.png"></a>
在兩個節點執行上圖所示指令，應該都可以看到CRS已啟動，至此CRS建立OK
配置ASM
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470336ezTX.png"></a>
在Oracle軟體的存放目錄執行上圖所示指令，調出安裝頁面
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624703424K85.png"></a>
選擇企業版安裝，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624703496s5T.png"></a>
确定ASM安裝路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470355G4IY.png"></a>
确認選擇所有節點，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470360Swhy.png"></a>
确認通過所有先決條件檢查後，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470366AwmS.png"></a>
選擇配置ASM并設定ASM的SYS使用者密碼，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470372qGrc.png"></a>
根據劃分好的裸裝置來進行DATA磁盤組的設定，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470376nhWh.png"></a>
确認無誤後，點選Install開始安裝
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470378e69C.png"></a>
安裝完畢後，在兩個節點執行上圖所示腳本
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470379AfaP.png"></a>
腳本執行完畢
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470382JJky.png"></a>
全部執行完畢後，點選Exit退出
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470387nnhs.png"></a>
重新開機crs後，可以看到ASM服務已經被添加，至此ASM配置完畢
安裝Oracle軟體
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470388LtN7.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470394XdAr.png"></a>
在調出的歡迎頁面中點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704003DTT.png"></a>
選擇企業版安裝模式，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470408SCV5.png"></a>
确定Oracle軟體安裝路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470414YOYj.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470419NRax.png"></a>
确認所有先決條件檢查無誤後，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470425IzH2.png"></a>
選擇僅安裝Oracle軟體，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704321Rth.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470434cFpc.png"></a>
安裝完畢後，執行上圖所示腳本
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470435gwQn.png"></a>
腳本執行完畢後，點選OK按鈕
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470439CglE.png"></a>
确認安裝完畢後，點選Exit退出
更新CRS
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470440kfSQ.png"></a>
首先關閉所有的CRS服務
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470441aDxq.png"></a>
在更新包的存放路徑，執行上圖所示指令，調查安裝頁面
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470443jJiw.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_136247044618c5.png"></a>
選擇CRS安裝路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470449aD6w.png"></a>
預設就是兩個節點，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470452gtg4.png"></a>
确認所有先決條件檢查通過後，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704559bbQ.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470458EGr5.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470460Q5om.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470462iIPu.png"></a>
CRS各項服務會自動啟動，至此CRS更新完畢
更新ASM
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470463Y01x.png"></a>
再次關閉CRS各項服務
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470464slVT.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704665J5a.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470469Urd7.png"></a>
選擇ASM路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470471wxuq.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470474pboL.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470477CIxu.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704791B0A.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470481YRBG.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470483K0gC.png"></a>
全部安裝完畢後，點選Exit退出
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704843WiV.png"></a>
重新開機CRS，至此，ASM更新完畢
更新Oracle軟體
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470485kFlJ.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624704873vPk.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470489ezkC.png"></a>
選擇Oracle軟體安裝路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_136247049395Ff.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470495uL8z.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_136247049884yi.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624705001yfI.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624705010DJB.png"></a>
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470503yePu.png"></a>
一切結束後，點選Exit按鈕退出，至此全部更新結束
建立資料庫
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470505ym4x.png"></a>
執行DBCA指令調出建庫助手，選擇叢集資料庫，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470507ePbb.png"></a>
首先挂載剩下的ASM存儲卷，選擇配置ASM，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470510A00J.png"></a>
選擇所有節點，繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470511HEy0.png"></a>
鍵入ASM的SYS使用者密碼，點選OK繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470512crwF.png"></a>
選擇剩餘的兩個磁盤，為後期閃回恢複區所用，點選OK繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624705148Ucg.png"></a>
确定兩個組都增加了後，點選Finish完成
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_136247086978ll.png"></a>
選擇建立資料庫，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470871nzYt.png"></a>
選擇所有節點，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624708749Lai.png"></a>
選擇通用模版，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470876iRYZ.png"></a>
确定全局資料庫名，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470879Iug2.png"></a>
不配置OEM（我們後面要用到GC），點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470883pr5G.png"></a>
設定sys與system使用者密碼，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470886M26I.png"></a>
選擇ASM存儲方式，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470889YCdx.png"></a>
選擇資料卷，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470891bIA7.png"></a>
确定實體檔案存儲路徑，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624708949FZx.png"></a>
設定閃回區，同樣使用剛才設定好的ASM卷，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470896ixEs.png"></a>
根據實際情況确定是否需要示例方案，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470901DbnG.png"></a>
建立Service故障遷移服務，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470903uYii.png"></a>
字元集選擇UTF8，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_13624709051oYh.png"></a>
可以根據自身情況更改相關存儲檔案大小等配置，點選Next繼續
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470907BMwa.png"></a>
勾選建立資料庫，點選Finish完成
<a href="http://bearlovecat.blog.51cto.com/attachment/201303/5/1293914_1362470909ynKH.png"></a>
确認無誤後，點選OK開始建庫
本文轉自bear_cat51CTO部落格，原文連結： http://blog.51cto.com/bearlovecat/1147645，如需轉載請自行聯系原作者
![【MySQL資料庫】資料庫索引事務1.索引2.事務[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)