本案例用到的主要軟硬件如下:
主機:Sun-Fire-V210
操作系統(tǒng):SunOS 5.9 Generic_117171-07
光纖卡:Emulex LightPulse FC9002L
陣列:EMC CLARiiON CX500
Cluster軟件:VERITAS STORAGE FOUNDATION FOR ORACLE RAC 4.0
Oracle版本:Oracle9.2.0.4
1.安裝操作系統(tǒng)
安裝基本系統(tǒng)以后,應用到最新的補丁
# uname -a
SunOS cluster1 5.9 Generic_117171-07 sun4u sparc SUNW,Sun-Fire-V210
配置hosts文件,設置相應別名,配置一個浮動ip(配置Cluster時需要)
# cat /etc/hosts## Internet host table#127.0.0.1 localhost 172.16.33.71 cluster2 cluster2.hurray.com.cn loghost172.16.33.70 cluster1 cluster1.hurray.com.cn 172.16.33.74 cluster cluster.hurray.com.cn
2.安裝光纖卡
本例使用的是Emulex的光線卡,Emulex LightPulse FC9002L光線卡需要到網(wǎng)站上下載最新的驅動安裝
使用光盤上的驅動系統(tǒng)會莫名其妙的循環(huán)重起,極度郁悶
光線卡安裝日志參考:
Emulex_LightPulse_FC9002L_Solaris9_Install
光纖卡安裝以后需要配置兩個參數(shù)文件:
完成這個步驟后重新啟動機器,使配置生效,把主機和光纖交換機及EMC陣列相連接
3.安裝EMC Navisphere AGENT(NAVIAGENT)
安裝EMC Navisphere AGENT(NAVIAGENT)
安裝完成后,重新啟動服務器,此時agent會自動啟動,自EMC陣列控制器上應該可以看到主機節(jié)點
4.分配磁盤組
在EMC陣列端,把劃好的磁盤組分配給主機
分配磁盤組后,重起主機
5.安裝VERITAS STORAGE FOUNDATION FOR ORACLE RAC 4.0軟件
安裝Veritas Storage Fundation For Oracle Rac4.0
6.配置共享磁盤
7.修改系統(tǒng)內(nèi)核參數(shù)
為安裝Oracle做準備
在/etc/system文件末尾追加以下參數(shù),兩臺主機都需要修改:
* kernal parameter for Oracle database add by:gqgaiset shmsys:shminfo_shmmax=4294967295set shmsys:shminfo_shmmin=1set shmsys:shminfo_shmmni=100set shmsys:shminfo_shmseg=10set semsys:seminfo_semmni=1024set semsys:seminfo_semmsl=1510set semsys:seminfo_semmns=3010set semsys:seminfo_semopm=100set semsys:seminfo_semvmx=32767
修改后重新啟動主機
8.劃分裸設備
根據(jù)實際需要劃分裸設備
vxassist -g oradg -U gen make system 800mvxassist -g oradg -U gen make temp 1000mvxassist -g oradg -U gen make users 1000mvxassist -g oradg -U gen make redo101 100mvxassist -g oradg -U gen make redo102 100mvxassist -g oradg -U gen make redo103 100mvxassist -g oradg -U gen make redo201 100mvxassist -g oradg -U gen make redo202 100mvxassist -g oradg -U gen make redo203 100mvxassist -g oradg -U gen make undo11 1000mvxassist -g oradg -U gen make undo21 1000mvxassist -g oradg -U gen make spfile 100mvxassist -g oradg -U gen make ctlfile1 100mvxassist -g oradg -U gen make ctlfile2 100mvxassist -g oradg -U gen make srvcfg 500m
修改屬主信息:
vxedit -g oradg set user=oracle mode=644 systemvxedit -g oradg set user=oracle mode=644 temp vxedit -g oradg set user=oracle mode=644 users vxedit -g oradg set user=oracle mode=644 redo101vxedit -g oradg set user=oracle mode=644 redo102vxedit -g oradg set user=oracle mode=644 redo103 vxedit -g oradg set user=oracle mode=644 redo201vxedit -g oradg set user=oracle mode=644 redo202vxedit -g oradg set user=oracle mode=644 redo203vxedit -g oradg set user=oracle mode=644 undo11 vxedit -g oradg set user=oracle mode=644 undo21 vxedit -g oradg set user=oracle mode=644 spfile vxedit -g oradg set user=oracle mode=644 ctlfile1 vxedit -g oradg set user=oracle mode=644 ctlfile2vxedit -g oradg set user=oracle mode=644 srvcfg
9.復制相應的庫文件
# cd /opt/ORCLcluster/lib# ls9iR2# cd *# lslibskgxn2_32.so libskgxn2_32.so.1 libskgxn2_64.so libskgxn2_64.so.1 libskgxp92_32.so libskgxp92_64.so# cp libskgxn2_64.so ../libskgxn2.so# lslibskgxn2_32.so libskgxn2_32.so.1 libskgxn2_64.so libskgxn2_64.so.1 libskgxp92_32.so libskgxp92_64.so
10.安裝Oracle軟件
11.檢查srvcfg設置
檢查/var/opt/oracle下srvConfig.loc文件,確保包含同樣的鏈接:
srvconfig_loc=/dev/vx/rdsk/oradg/srvcfg
兩邊應該有同樣的配置,否則gsd則不能啟動.
12.配置裸設備列表
設置DBCA_RAW_CONFIG環(huán)境變量
創(chuàng)建DBCA_RAW_CONFIG.txt配置文件
control1=/dev/vx/rdsk/oradg/ctlfile1
control2=/dev/vx/rdsk/oradg/ctlfile2
redo1_1=/dev/vx/rdsk/oradg/redo101
redo1_2=/dev/vx/rdsk/oradg/redo102
redo1_3=/dev/vx/rdsk/oradg/redo103
redo2_1=/dev/vx/rdsk/oradg/redo201
redo2_2=/dev/vx/rdsk/oradg/redo202
redo2_3=/dev/vx/rdsk/oradg/redo203
spfile=/dev/vx/rdsk/oradg/spfile
system=/dev/vx/rdsk/oradg/system
temp=/dev/vx/rdsk/oradg/temp
users=/dev/vx/rdsk/oradg/users
undotbs1=/dev/vx/rdsk/oradg/undo11
undotbs2=/dev/vx/rdsk/oradg/undo21
在user profile文件中設置:
DBCA_RAW_CONFIG=/opt/oracle/admin/Rac9i/create/DBCA_RAW_CONFIG.txt
export DBCA_RAW_CONFIG
13.開始創(chuàng)建數(shù)據(jù)庫