1、RedhatEnterpriseLinux5.4rac12Geth0(Public)eth1(Prive)rac22. 用户组规划GroupNameGroupID说明HOSToinstall501Oracle清单和软件所有者rac1,rac2asmadmin504Oracle自动存储管理组asmdba506ASM数据库管理员组asmopen507ASM操作员组dba502数据库管理员3. 用户规划UserIDUserNameGroup口令gridasmoperOracleCluster用户grid123oracleOracle数据库管理员oracle1234. IP规划公用IP私有IP虚拟IP
2、ScanIP5. 存储规划存储组件BlockDeviceASMlibNameSizeOCR/dev/sdbOCR_VOL11G/dev/sdcOCR_VOL2/dev/sddOCR_VOL3数据文件/dev/sdeDATA_VOL110G文件备份/dev/sdfBACK_VOL15G三、 OracleRAC搭建1. 配置共享存储(ASM依赖) 方法一:vmwareworkstation9虚拟共享存储(1) 在VM安装目录VMwareWorkstation下执行命令:#vmware-vdiskmanager.exe-c-s1GB-alsilogic-t2D:racDiskdb01.vmdkrac
3、Diskdb02.vmdkracDiskdb03.vmdk#vmware-vdiskmanager.exe-c-s10GB-alsilogic-t2D:racDiskdb04.vmdk#vmware-vdiskmanager.exe-c-s5GB-alsilogic-t2D:racDiskdb05.vmdk(2) 修改rac1和rac2下的.vmx文件,在最后一行添加如下内容:diskLib.dataCacheMaxSize=0diskLib.dataCacheMaxReadAheadSize=0diskLib.dataCacheMinReadAheadSize=0diskLib.dataCa
4、chePageSize=4096diskLib.maxUnsyncedWrites=0disk.locking=FALSEscsi1.sharedBus=virtualscsi1.present=TRUEscsi1.virtualDev=lsilogicscsi1:0.mode=independent-persistent0.deviceType=disk0.present=0.fileName=D:racDiskdb01.vmdk1.mode=1.deviceType=1.present=1.fileName=racDiskdb02.vmdk2.mode=2.deviceType=2.pre
5、sent=2.fileName=racDiskdb03.vmdk3.mode=3.deviceType=3.present=3.fileName=racDiskdb04.vmdk4.mode=4.deviceType=4.present=4.fileName=racDiskdb05.vmdk(3) 重新打开虚拟机,并启动。(4) 磁盘分区,在rac1执行#fdisk/dev/sdbDevicecontainsneitheravalidDOSpartitiontable,norSun,SGIorOSFdisklabelBuildinganewDOSdisklabel.Changeswillrem
6、aininmemoryonly,untilyoudecidetowritethem.Afterthat,ofcourse,thepreviouscontentwontberecoverable.Warning:invalidflag0x0000ofpartitiontable4willbecorrectedbyw(rite)Command(mforhelp):p64heads,32sectors/track,1000cylindersUnits=cylindersof2048*512=1048576bytesDeviceBootStartEndBlocksIdSystemnCommandact
7、ioneextendedpprimarypartition(1-4)Partitionnumber(1-4):1Firstcylinder(1-1000,default1):Usingdefaultvalue1Lastcylinderor+sizeor+sizeMor+sizeK(1-1000,default1000):Usingdefaultvalue1000wThepartitiontablehasbeenaltered!Callingioctl()tore-readpartitiontable.Syncingdisks.#fdisk/dev/sdc重复上面操作#fdisk/dev/sdd
8、重复上面操作#fdisk/dev/sde重复上面操作#fdisk/dev/sdf重复上面操作 方法二:Linuxmount挂载(待解决)2. 安装依赖包#yuminstall-yexpect*iscsi*binutils*compat-libstdc+*expat*elfutils-libelf*gcc*glibc*ksh*libgcc*#yuminstall-ypdksh*libgomp*compat-db*libXp*libaio*cpp*setarch*sysstat*libstdc+*make-3*#yuminstall-yunixODBC#yuminstall-yunixODBC-d
9、evel3. 查看依赖包安装状况#rpm-q-qf%NAME-%VERSION-%RELEASE(%ARCH)nbinutilselfutils-libelfexpatgccgcc-c+glibcglibc-commonglibc-develglibc-headerskshlibaiolibaio-devellibgcclibstdc+libstdc+-develmakepdkshsysstatunixODBCunixODBC-devel执行结果elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.137-3.el5(i386)glibc-2
10、.5-118.el5_10.2(i686)glibc-2.5-118.el5_10.2(x86_64)glibc-common-2.5-118.el5_10.2(x86_64)glibc-devel-2.5-118.el5_10.2(x86_64)glibc-devel-2.5-118.el5_10.2(i386)glibc-headers-2.5-118.el5_10.2(x86_64)make-3.81-3.el5(x86_64)4. 网络配置(1) 修改rac1和rac2的network#vi/etc/sysconfig/networkNETWORKING=yesNETWORKING_I
11、PV6=noHOSTNAME=rac1#此处为主机名HOSTNAME=rac2(2) 修改rac1和rac2的hosts#vi/etc/hosts#eth0-PublicIP#eth1PRIVATEIP#VIP#SCAN#(3) 重启rac1和rac2网络服务#servicenetworkrestart(4) 配置虚拟IP#*注:虚拟IP在重启网络服务会被卸载,需要重新设置。5. 配置NTPD服务NTPD服务为Grid的检查项,提供时间同步服务。(1) 修改NTPD参数文件(rac1,rac2)#vi/etc/sysconfig/ntpdSYNC_HWCLOCK=yesOPTIONS=-x-u
12、ntp:ntp-p/var/run/ntpd.pid(2) 修改rac1的ntpd.conf文件,删除原有内容录入以下内容#vi/etc/ntp.confserverfudgedriftfile/var/lib/ntp/driftbroadcastdelay0.008authenticatenokeys/etc/ntp/keys(3) 清空rac1的ntpservers原有内容#cp/etc/ntp/ntpservers/etc/ntp/ntpservers.bak#vi/etc/ntp/ntpservers(4) 编辑rac1的step-tickers,添加一行#cp/etc/ntp/ste
13、p-tickers/etc/ntp/step-tickers.bak#vi/etc/ntp/step-tickers(5) 修改rac2的ntpd.conf文件,删除原有内容录入以下内容(6) 清空rac2的ntpservers原有内容(7) 编辑rac2的step-tickers,添加一行 #rac1的ip地址(8) rac1节点重启NTPD服务#servicentpdrestart(9) rac2节点停止NTPD服务,rac1重启NTPD服务后5、6分钟再执行#servicentpdstop#ntpdaterac1#servicentpdstart(10) NTPD启用自动加载(rac1,
14、rac2)#chkconfigntpdon6. 关闭服务关闭rac1和rac2无用的sendmail和cups服务,加快开机速度。#chkconfigsendmailoff#chkconfigcupsoff7. 用户、用户组(1) 创建用户和用户组#groupadd-g501oinstall#groupadd-g502dba#groupadd-g504asmadmin#groupadd-g506asmdba#groupadd-g507asmoper#useradd-u501-goinstall-Gdba,asmadmin,asmdba,asmopergrid#useradd-u502-goin
15、stall-Gdba,asmdbaoracle#idoracle#idgrid(2) 修改用户密码#passwdoracle#passwdgrid8. 文件夹及权限#mkdir-p/u01/app/grid/#mkdir-p/u01/app/oraInventory#chown-Rgrid:oinstall/u01/app#chown-Roracle:oinstall/u01/app/oracle#chmod-R775/u019. 修改系统参数(1) 修改rac1和rac2的limits.conf#vi/etc/security/limits.conf#ORACLESETTINGgridsof
16、tnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536(2) 修改rac1和rac2的/etc/pam.d/login#vi/etc/pam.d/loginsessionrequiredpam_limits.so(3) 修改rac1和rac2的/etc/sysctl.conf#vi/etc/sysctl.conffs.aio-max-nr=1048576fs.f
17、ile-max=6815744kernel.shmall=2097152kernel.shmmni=4096(4) 执行命令(rac1、rac2)#sysctl-p(5) 修改rac1和rac2的profile,在末尾添加#vi/etc/profileif$USER=oracle|$USER=grid;then if$SHELL=/bin/ksh ulimit-p16384 ulimit-n65536 else ulimit-u16384-n65536 fi umask022fi(6) 执行命令(rac1、rac2)#source/etc/profile(7) 修改rac1和rac2的/etc
18、/csh.login#vi/etc/csh.loginif($USER=|$USER=)then limitmaxproc16384 limitdescriptors65536endifEOFCSH(8) 修改grid用户的环境变量#su-grid$cd/home/grid/$vi.bash_profileTMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_SID=+ASM1;exportORACLE_SIDORACLE_BASE=/u01/app/grid;exportORACLE_BASENLS_DATE_FORMAT=yyyy-mm-ddHH
19、24:MI:SS;exportNLS_DATE_FORMATTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHumask022ORACLE_SID=+ASM2;(9) 执行命令(rac1、rac2)$source.bash_profile(10) 修改oracle用户的环境变量#su-oracle$cd/home/oracle/#OracleSettingsoracleORACLE_BASE=/u01/app/oracle;ORACLE_SID=orcl1;ORACLE_TERM=xterm;exportORACLE_TERMPATH=/usr/sbin:LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HO
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1