Oracle RAC环境部署文档.docx
《Oracle RAC环境部署文档.docx》由会员分享,可在线阅读,更多相关《Oracle RAC环境部署文档.docx(51页珍藏版)》请在冰豆网上搜索。
OracleRAC环境部署文档
OracleRAC环境部署文档
概要:
oracle10gforSunSolaris9,采用ASM方式的部署过程。
目录
一、硬件
二、操作系统
三、网络配置
四、配置系统内核
五、配置oracle环境
六、共享磁盘分区
七、安装oraclecluster
八、安装配置ASM+
九、配置vipca
十、配置ASM(如果增加ASM设备也从该处配置)
十一、建库
十二、最后检查
十三、客户端管理
十四、参考
一、硬件
SunV490X2,共享阵列,每台2块以上网卡(rac需要两块),接同一交换机
二、操作系统
1、基本环境
SunOS5.9+推荐补丁
2、必需包
#pkginfo-iSUNWarcSUNWbtoolSUNWheaSUNWlibCSUNWlibmSUNWlibmsSUNWsprotSUNWsproxSUNWtooSUNWi1ofSUNWi1csSUNWi15csSUNWxwfnt
3、必需补丁
AllinstallationsPatchesforSolaris9(SPARC):
PatchesforSolaris9(SPARC):
112233-11,SunOS5.9:
KernelPatch
111722-04,SunOS5.9:
MathLibrary(libm)patch
4、特殊补丁(不必需)
PL/SQLnativecompilation,Pro*C/C++,OracleCallInterface,OracleC++CallInterface,OracleXMLDeveloper'sKit(XDK):
PatchesforSolaris8andSolaris9(SPARC):
112758-02,dbx7.1:
PatchforS1S8CCDebugger
112760-05,C5.5:
PatchforS1S8CCCcompiler
112763-06,CompilerCommonS1S8CC:
PatchforS1S8CCCC++F77F95
113817-03,C++5.5:
PatchforS1S8CCC++compiler
113820-02,CompilerCommon7.1:
PatchforS1S8CCMathLibraries
113823-03,ILD4.1:
PatchforS1S8CCIncrementalLinker
三、网络配置
1、列出系统网卡信息和已经激活的网卡信息
1)列出系统网卡信息
#grepnetwork/etc/path_inst
2)激活的网卡信息
#ifconfig–a
2、激活尚未活动的第二块网卡
db1:
#ifconfigce1plumb
#ifconfigce1inet10.10.10.1netmask255.255.255.0up
================================
db2:
#ifconfigce1plumb
#ifconfigce1inet10.10.10.2netmask255.255.255.0up
3、配置网络参数文件
db1:
#cat/etc/hosts
#127.0.0.1localhost
192.168.11.61db2
192.168.11.60db1
10.10.10.1db1_pri
10.10.10.2db2_pri
192.168.11.58db1_vip
192.168.11.59db2_vip
#cat/etc/hostname.ce1
db1_pri
==================================
db2:
#cat/etc/hosts
#127.0.0.1localhost
192.168.11.61db2
192.168.11.60db1
10.10.10.1db1_pri
10.10.10.2db2_pri
192.168.11.58db1_vip
192.168.11.59db2_vip
#cat/etc/hostname.ce1
db2_pri
注意:
1)ce0为公用网卡,ce1为私有网卡,私有网卡不能和公用网卡在同一网段,vip是oraclerac自动分配,必须和公用网卡在同一网段。
2)oracle的一个bug。
如果设置的外网的ip地址是10开始或者172.16-172.31或者192.168开始,oracle将会提示这个错误。
解决办法:
运行完毕root.sh脚本后,手工运行vipca(需要图形界面)
四、配置系统内核
db1:
#cat/etc/system
setnoexec_user_stack=1
setsemsys:
seminfo_semmni=100
setsemsys:
seminfo_semmns=1024
setsemsys:
seminfo_semmsl=256
setsemsys:
seminfo_semvmx=32767
setshmsys:
shminfo_shmmax=4294967295
setshmsys:
shminfo_shmmin=1
setshmsys:
shminfo_shmmni=100
setshmsys:
shminfo_shmseg=10
#sync;sync;reboot
==================================
db2:
做以上同样的操作。
五、配置oracle环境
db1:
1、创建dba组,oracle用户
#groupadd–g100dba
#useradd–u1000–gdba–d/oracle–moracle
#passwdoracle
#su-oracle
$id-a
uid=1000(oracle)gid=100(dba)groups=100(dba)
说明:
因为做rac,两台机器需指定同样的uid和gid
2、配置环境参数
$cat.profile
umask022
ORACLE_BASE=/oracle
exportORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/app/oracle/product/10.2.0
exportORACLE_HOME
ORACLE_SID=cddb1
exportORACLE_SID
PATH=$ORACLE_HOME/bin:
/usr/sbin:
/usr/bin:
/usr/ccs/bin:
/usr/openwin/bin:
/usr/dt/bin:
/usr/platform/SUNW,Sun-Fire-V490/sbin:
/opt/sun/bin:
/opt/SUNWexplo/bin:
/opt/SUNWsneep/bin:
/opt/CTEact/bin
exportPATH
说明:
公用的ORACLE_SID为cddb,而rac的每一台的单独ORACLE_SID分别为cddb1和cddb2,后面的数字在dbca建库时程序自动加上,而配置文件里需手工添加。
$cat.rhosts
+
说明:
用于安装和运行中oraclerac通过rcprsh等进行同步,设置后需测试r操作是否正常。
=============================
db2:
做以上同样的操作。
六、共享磁盘分区
说明:
由于c4t50060E80004450A1d0,c4t50060E80004450A1d1是共享磁盘,所以只在一台上做就可,做完重启,同步磁盘初始化。
Db1:
1、分区
#format
Searchingfordisks...done
AVAILABLEDISKSELECTIONS:
0.c1t0d0
/pci@9,600000/SUNW,qlc@2/fp@0,0/ssd@w21000000878f8ed4,0
1.c1t1d0
/pci@9,600000/SUNW,qlc@2/fp@0,0/ssd@w21000000878fc6db,0
2.c4t50060E80004450A1d0
/pseudo/dlmndrv@1/dlmfdrv@w50060e80004450a1,0
3.c4t50060E80004450A1d1
/pseudo/dlmndrv@1/dlmfdrv@w50060e80004450a1,1
Specifydisk(enteritsnumber):
2
selectingc4t50060E80004450A1d0
[diskformatted]
FORMATMENU:
disk-selectadisk
type-select(define)adisktype
partition-select(define)apartitiontable
current-describethecurrentdisk
format-formatandanalyzethedisk
repair-repairadefectivesector
label-writelabeltothedisk
analyze-surfaceanalysis
defect-defectlistmanagement
backup-searchforbackuplabels
verify-readanddisplaylabels
save-savenewdisk/partitiondefinitions
inquiry-showvendor,productandrevision
volname-set8-charactervolumename
!
-execute,thenreturn
quit
format>p
PARTITIONMENU:
0-change`0'partition
1-change`1'partition
2-change`2'partition
3-change`3'partition
4-change`4'partition
5-change`5'partition
6-change`6'partition
7-change`7'partition
select-selectapredefinedtable
modify-modifyapredefinedpartitiontable
name-namethecurrenttable
print-displaythecurrenttable
label-writepartitionmapandlabeltothedisk
!
-execute,thenreturn
quit
partition>p
Currentpartitiontable(original):
Totaldiskcylindersavailable:
10920+2(reservedcylinders)
PartTagFlagCylindersSizeBlocks
0rootwm0-5112.50MB(6/0/0)230400
1swapwu6-11112.50MB(6/0/0)230400
2backupwu0-10919199.95GB(10920/0/0)419328000
3unassignedwm00(0/0/0)0
4unassignedwm00(0/0/0)0
5unassignedwm12-17112.50MB(6/0/0)230400
6usrwm18-23112.50MB(6/0/0)230400
7unassignedwm24-10892199.02GB(10869/0/0)417369600
db1#init6
db2#init6
注意:
1)起始柱面0不要使用;
2)slice5给ocr用
3)slice5给vote用
4)slice7分配给ASM用。
2、设置权限
db1:
#ls–lL/de/rdsk/dev/rdsk/c4t50060E80004450A1d0*
#chownoracle:
dba/dev/rdsk/c4t50060E80004450A1d0s5
#chownoracle:
dba/dev/rdsk/c4t50060E80004450A1d0s6
#chownoracle:
dba/dev/rdsk/c4t50060E80004450A1d0s7
#ls–lL/de/rdsk/dev/rdsk/c4t50060E80004450A1d0*
===================================
db2:
#ls–lL/de/rdsk/dev/rdsk/c4t50060E80004450A1d0*
#chownoracle:
dba/dev/rdsk/c4t50060E80004450A1d0s5
#chownoracle:
dba/dev/rdsk/c4t50060E80004450A1d0s6
#chownoracle:
dba/dev/rdsk/c4t50060E80004450A1d0s7
#ls–lL/de/rdsk/dev/rdsk/c4t50060E80004450A1d0*
七、安装oraclecluster
说明:
只在一台机器上做,系统会自动同步到另外一台机器上。
假设在db1上。
1、展开介质
#cpio–ivcd<10gr2_cluster_sol.cpio
2、安装cluster
通过xmanger和本地控制台,以oracle用户登陆,进入安装目录,运行
$./runInstaller
1)安装程序欢迎界面:
2)指定inventory目录和组:
3)指定HOME路径:
4)安装要求检查:
5)指定Cluster配置:
6)增加另一个节点:
7)再次检查Cluster配置:
8)指定网络接口的使用:
9)指定OCR配置:
10)指定VOTING配置:
11)设定好了所有的信息,准备开始安装:
14.安装进行中:
15)执行配置脚本:
db1:
#/oracle/oraInventory/orainstRoot.sh
Changingpermissionsof/oracle/oraInventoryto770.
Changinggroupnameof/oracle/oraInventorytodba.
Theexecutionofthescriptiscomplete
#/oracle/app/oracle/product/crs/root.sh
CheckingtoseeifOracleCRSstackisalreadyconfigured
SettingthepermissionsonOCRbackupdirectory
SettingupNSdirectories
OracleClusterRegistryconfigurationupgradedsuccessfully
SuccessfullyaccumulatednecessaryOCRkeys.
Usingports:
CSS=49895CRS=49896EVMC=49898andEVMR=49897.
node:
node1:
db1db1-privdb1
node2:
db1db2-privdb2
CreatingOCRkeysforuser'root',privgrp'other'..
Operationsuccessful.
Nowformattingvotingdevice:
/app/oracle/VOTE/c2t4d0s5
Formatof1votingdevicescomplete.
Startupwillbequeuedtoinitwithin30seconds.
Addingdaemonstoinittab
ExpectingtheCRSdaemonstobeupwithin600seconds.
CSSisactiveonthesenodes.
db1
CSSisinactiveonthesenodes.
db2
Localnodecheckingcomplete.
Runroot.shonremainingnodestostartCRSdaemons.
==============================
db2:
#/oracle/oraInventory/orainstRoot.sh
Changingpermissionsof/oracle/oraInventoryto770.
Changinggroupnameof/oracle/oraInventorytodba.
Theexecutionofthescriptiscomplete
#/oracle/app/oracle/product/crs/root.sh
CheckingtoseeifOracleCRSstackisalreadyconfigured
SettingthepermissionsonOCRbackupdirectory
SettingupNSdirectories
OracleClusterRegistryconfigurationupgradedsuccessfully
clscfg:
EXISTINGconfigurationversion3detected.
clscfg:
version3is10GRelease2.
SuccessfullyaccumulatednecessaryOCRkeys.
Usingports:
CSS=49895CRS=49896EVMC=49898andEVMR=49897.
node:
node1:
db1db1-privdb1
node2:
db2db2-privdb2
clscfg:
Argumentscheckoutsuccessfully.
NOKEYSWEREWRITTEN.Supply-forceparametertooverride.
-forceisdestructiveandwilldestroyanypreviouscluster
configuration.
OracleClusterRegistryforclusterhasalreadybeeninitialized
Startupwillbequeuedtoinitwithin30seconds.
Addingdaemonstoinittab
ExpectingtheCRSdaemonstobeupwithin600seconds.
CSSisactiveonthesenodes.
Db1
Db2
CSSisactiveonallnodes.
WaitingfortheOracleCRSDandEVMDtostart
WaitingfortheOracleCRSDandEVMDtostart
WaitingfortheOracleCRSDandEVMDtostart
WaitingfortheOracleCRSDandEVMDtostart
OracleCRSstackinstalledandrunningunderinit(1M)
Runningvipca(silent)forconfiguringnodeapps
CreatingVIPapplicationresourceon
(2)nodes...
CreatingGSDapplicationresourceon
(2)nodes...
CreatingONSapplicationresourceon
(2)nodes...
StartingVIPapplicationresourceon
(2)nodes...
StartingGSDapplicationresourceon
(2)nodes...
StartingONSapplicationresourceon
(2)nodes...
注意:
如果不是第一次安装,将受到历史配置的影响。
解决办法:
#mv/etc/init.d/init.c*/
#mv/var/opt/oracle/var/opt/oracle.init
#ps–ef|grepcss
#ps–ef|grepcrs
#kill–9pid
#ps-ef|grepcrs
oracle1760127479015:
43:
38pts/10:
00grepcrs
oracle9469450Sep12?
1:
08/oracle/app/oracle/product/crs/b