ORACLE12CR2RAC集群部署搭建

ORACLE12CR2RAC集群部署搭建ORACLE12CR2RAC集群部署搭建38/38ORACLE12CR2RAC集群部署搭建ORACLE12CR2RAC集群部署搭建目錄1、軟硬件要求3硬件最低配置要求31.2ORACLE12.2認證的OS軟件版本32、整體規(guī)劃部分32.1IP地點規(guī)劃4操作系統(tǒng)當?shù)卮疟P分區(qū)規(guī)劃4共享存儲與ASM磁盤組規(guī)劃43、操作系統(tǒng)配置部分5配置hosts文件5安裝RPM包53.3創(chuàng)立用戶組6創(chuàng)立文件目錄及權(quán)限配置7配置環(huán)境變量7安裝cvuqdisk84、改正操作系統(tǒng)配置9開啟nscd9封閉防火墻9禁用selinux9封閉TransparentHugePages9配置10配置10配置11配置DNS11改正時間同步方式11改正12配置NOZEROCONF12配置互信125、ASM磁盤配置部分135.1UDEV配置asm磁盤（兩個節(jié)點都履行）13考證asmdisk生成13改正磁盤屬性146、grid軟件安裝14檢測安裝環(huán)境14安裝GI（GridInfrastructure）167、asmca創(chuàng)立其余asmdiskgroup268、database軟件安裝279、創(chuàng)立CDB3210、創(chuàng)立PDB37以命令方式創(chuàng)立PDB37查察創(chuàng)立成功的PDB381、ORACLE12.2軟硬件要求硬件最低配置要求序號組件內(nèi)存需求1OracleGridInfrastructureinstallations4GB以上2OracleDatabaseinstallations最小1GB，建議2GB以上1.2ORACLE12.2認證的OS軟件版本序號組件OracleLinux7withtheUnbreakableEnterprisekernel:13.8.13-35.3.1.el7uek.x86_64orlater2OracleLinux7withtheRedHatCompatiblekernel:3.10.0-123.el7.x86_64orlater3OracleLinux6.4withtheUnbreakableEnterprisekernel2:2.6.39-200.24.1.el6uek.x86_64orlater4OracleLinux6withtheRedHatCompatiblekernel:2.6.32-358.el6.x86_64orlater5RedHatEnterpriseLinux7:3.10.0-123.el7.x86_64orlater6RedHatEnterpriseLinux6:2.6.32-358.el6.x86_64orlater7SUSELinuxEnterpriseServer12:3.12.28-4-defaultorlater8SUSELinuxEnterpriseServer11SP2:3.0.13-0.27orlater2、整體規(guī)劃部分2.1IP地點規(guī)劃序號所屬主機名稱用途IP地點1GNSGNS2Node1public3Node1viprac14Node1Private15Node1Private27Node2public8Node2viprac29Node2Private110Node2Private211scanscan112scanscan213scanscan3操作系統(tǒng)當?shù)卮疟P分區(qū)規(guī)劃序號分區(qū)名稱大小用途說明1/boot200MB指引分區(qū)2/12288MB（12G）根分區(qū)3swap6144MB最少4.7303GB以上4/dba44850MBoracle安裝目錄共享存儲與ASM磁盤組規(guī)劃序號磁盤名稱Asm磁盤名稱磁盤組名稱大小用途1sdb1asm-diskbOCR_VOT10GOCR+VOTINGDISK2sdc1asm_diskcDATA0130Gdata3、操作系統(tǒng)配置部分配置hosts文件Vi/etc/hostsGNSrac1rac1-viprac1-pri1rac1-pri2rac2rac2-viprac2-pri1rac2-pri2rac-scanrac-scanrac-scan安裝RPM包binutils-.2-5.11.el6(x86_64)compat-libcap1-1.10-1(x86_64)compat-libstdc++-33-3.2.3-69.el6(x86_64)compat-libstdc++-33-3.2.3-69.el6(i686)gcc-4.4.4-13.el6(x86_64)gcc-c++-4.4.4-13.el6(x86_64)glibc-2.12-1.7.el6(i686)glibc-2.12-1.7.el6(x86_64)glibc-devel-2.12-1.7.el6(x86_64)glibc-devel-2.12-1.7.el6(i686)kshlibgcc-4.4.4-13.el6(i686)libgcc-4.4.4-13.el6(x86_64)libstdc++-4.4.4-13.el6(x86_64)libstdc++-4.4.4-13.el6(i686)libstdc++-devel-4.4.4-13.el6(x86_64)libstdc++-devel-4.4.4-13.el6(i686)libaio-0.3.107-10.el6(x86_64)libaio-0.3.107-10.el6(i686)libaio-devel-0.3.107-10.el6(x86_64)libaio-devel-0.3.107-10.el6(i686)libXext-1.1(x86_64)libXext-1.1(i686)libXtst-(x86_64)libXtst-(i686)libX11-1.3(x86_64)libX11-1.3(i686)libXau-1.0.5(x86_64)libXau-1.0.5(i686)libxcb-1.5(x86_64)libxcb-1.5(i686)libXi-1.3(x86_64)libXi-1.3(i686)sysstat-9.0.4-11.el6(x86_64)nscd3.3創(chuàng)立用戶組#/usr/sbin/groupadd#/usr/sbin/groupadd

–g501oinstall–g502dba#/usr/sbin/groupadd

–g503oper#/usr/sbin/groupadd

–g504asmadmin#/usr/sbin/groupadd

–g505asmdba#/usr/sbin/groupadd

–g506asmoper#/usr/sbin/useradd#/usr/sbin/useradd

–u501–goinstall–u502–goinstall

–Gasmadmin,asmdba,asmopergrid–Gdba,asmdbaoraclepasswdoraclepasswdgrid創(chuàng)立文件目錄及權(quán)限配置#mkdir-p/dba/app/grid--thisistheGIORACLE_BASE--thisistheORACLE_HOMEFORGI#mkdir-p/dba/app/oracle--thisistheRDBMSORACLE_BASE--thisistheRDBMSORACLE_HOME#mkdir-p/dba/app/oraInventory--thisisoraInventorylocation#chown-Rgrid:oinstall/dba/app#chown-Roracle:oinstall/dba/app/oracle#chmod-R775/dba/app配置環(huán)境變量#su–grid$vi.bash_profileexportTMP=/tmpexportTMPDIR=$TMPexportORACLE_BASE=/dba/app/gridexportORACLE_SID=+ASM1exportPATH=/usr/sbin:$PATHexportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibaliassqlplus="rlwrapsqlplus"$source.bash_profile#su–oracle$vi.bash_profileexportPATHexportTMP=/tmpexportTMPDIR=$TMPexportORACLE_BASE=/dba/app/oracleexportORACLE_SID=naridbexportPATH=/usr/sbin:$PATHexportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibaliassqlplus="rlwrapsqlplus"aliasrman="rlwraprman"安裝cvuqdiskcvuqdisk存于oracleGI安裝介質(zhì)的cv/rpm目錄下exportCVUQDISK_GRP=asmadminrpm–4、改正操作系統(tǒng)配置開啟nscd#chkconfignscdonchkconfig--level35nscdonservicenscdstart封閉防火墻#chkconfigiptablesoff#chkconfigip6tablesoff#serviceiptablesstop#serviceip6tablesstop禁用selinux改正/etc/selinux/config編寫文本中的SELINUX=enforcing為SELINUX=disabled封閉TransparentHugePages1）查察考證transparent_hugepage的狀態(tài)cat/sys/kernel/mm/redhat_transparent_hugepage/enabledalwaysmadvise[never]結(jié)果為never表示封閉2）封閉transparent_hugepage的配置#說明：編寫文件，增添以下內(nèi)容iftest-f/sys/kernel/mm/redhat_transparent_hugepage/enabled;thenechonever>/sys/kernel/mm/redhat_transparent_hugepage/enabledfi配置gridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536gridsoftstack10240gridhardstack32768oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536oraclesoftstack10240oraclehardstack32768配置增添以下內(nèi)容fs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=67108864kernel.shmmax=274877906944kernel.shmmni=4096kernel.sem=25032000100128net.ipv4.ip_local_port_range=900065500net.ipv4.tcp_rmem=4096873804194304net.ipv4.tcp_wmem=4096163844194304net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048576net.ipv4.conf.eth2.rp_filter=2net.ipv4.conf.eth1.rp_filter=2net.ipv4.conf.eth0.rp_filter=1針對rp_filter部分，假如沒有多張私有網(wǎng)卡，則不需要配置，文檔有描繪。配置增添以下內(nèi)容：sessionrequired配置DNS#vi/etc/sysconfig/network-scripts/ifcfg-eth0配置了

還要在

/etc/sysconfig/network-scripts/ifcfg-eth0

中增添

的原由是，假如不配置后者，在

OS重啟后，

中配置的nameserver

信息會自動拋棄改正時間同步方式1）#增添下邊內(nèi)容（2）Vi/etc/sysconfig/ntpdOPTIONS="-untp:ntp-p/var/run/ntpd.pid-g"改正成OPTIONS="-x-untp:ntp-p/var/run/ntpd.pid-g"#chkconfigntpdon#servicentpdrestart改正保留的是域名檢索次序。在一些系統(tǒng)配置中，NIS（NetworkInformationSystem）可能會惹起SCAN域名剖析異樣。為了防范這類問題的發(fā)生，對做以下調(diào)整。#vi修轉(zhuǎn)行hosts:filesdns為hosts:filesdnsnis配置NOZEROCONFvi/etc/sysconfig/network增添以下內(nèi)容NOZEROCONF=yes配置互信方法：使用迅速創(chuàng)立互信sshUserSetup.sh在GI安裝介質(zhì)解壓縮后的oui/prov/resources/scripts目錄下。下邊兩條命令在一個節(jié)點上履行即可（能夠在root用戶下履行）：#./sshUserSetup.sh-usergrid-hosts"rac2rac1"-advanced-exverify–confirm#./sshUserSetup.sh-useroracle-hosts"rac2rac1"-advanced-exverify-confirm5、ASM磁盤配置部分5.1UDEV配置asm磁盤（兩個節(jié)點都履行）查出兩個磁盤的UUID[root@rac1~]#/sbin/scsi_id-g-u-d/dev/sdb36000c29a206f9c0ff78ea1f8b17f4c68[root@rac1~]#/sbin/scsi_id-g-u-d/dev/sdc36000c293dee9cf6e31fe7eeaf2f5bba72）KERNEL=="sdb",BUS=="scsi",PROGRAM=="/sbin/scsi_id--whitelisted--replace-whitespace--device=/RESULT=="36000c29a206f9c0ff78ea1f8b17f4c68",NAME="asm-diskb",OWNER="grid",GROUP="asmadmin",MOKERNEL=="sdc",BUS=="scsi",PROGRAM=="/sbin/scsi_id--whitelisted--replace-whitespace--device=/RESULT=="36000c293dee9cf6e31fe7eeaf2f5bba7",NAME="asm-diskc",OWNER="grid",GROUP="asmadmin",MO3）重啟UDEV/sbin/udevadmcontrol--reload-rules#/sbin/start_udev考證asmdisk生成查問asm磁盤能否生成#cd/dev#ls–lasm*[root@rac2dev]#ls-lasm*brw-rw1gridasmadmin8,17Feb2206:35asm-disk1brw-rw1gridasmadmin8,33Feb2206:35asm-disk2改正磁盤屬性（1）改正磁盤屬性#echodeadline>/sys/block/sdb/queue/scheduler#echodeadline>/sys/block/sdc/queue/scheduler（2）考證屬性改正結(jié)果：[root@rac1dev]#more/sys/block/sdb/queue/schedulernoopanticipatory[deadline]cfq[root@rac1dev]#more/sys/block/sdc/queue/schedulernoopanticipatory[deadline]cfq6、grid軟件安裝檢測安裝環(huán)境全面檢查：./runcluvfy.shstage-precrsinst-nrac1,rac2-verbose檢查網(wǎng)絡(luò)和等效性./runcluvfy.shcompnodecon-nrac1,rac2-verbose[grid@rac1grid]$./runcluvfy.shcompnodecon-nrac1,rac2-verboseVerifyingNodeConnectivity...VerifyingHostsFile...NodeName

Status

rac1rac2

passedpassedVerifyingHostsFile...PASSEDInterfaceinformationfornode"rac1"NameIPAddressSubnetGatewayDef.GatewayAddressMTUeth000:0eth11500eth21500Interfaceinformationfornode"rac2"NameIPAddressSubnetGatewayDef.GatewayAddressMTUeth000:0eth11500eth21500NodeNameIPAddressSubnetMTUrac1eth01500rac2eth01500NodeNameIPAddressSubnetMTUrac1eth11500rac1eth21500rac2eth11500rac2eth21500VerifyingCheckthatmaximum(MTU)sizepacketgoesthroughsubnet...PASSEDVerifyingNodeConnectivity...PASSEDVerifyingMulticastcheck...PASSEDVerificationofnodeconnectivitywassuccessful.CVUoperationperformed:

nodeconnectivityDate:

Feb22,20168:17:50PMCVUhome:

/dba/soft/grid/User:

grid6.2安裝GI（

）Scanname需要和/etc/hosts中的scan名稱一致，不然會報下邊錯誤：ins-40718singleclientaccessname(scan):XXclusternamecouldnotberesolved假如選擇flex，必然3塊磁盤，以及節(jié)余空間36352MB以上，以以以下列圖所示：[grid@rac1tmp]$crs_stat-tNameTypeTargetStateHostoraSM.lsnroraer.typeONLINEONLINErac1oraER.lsnroraer.typeONLINEONLINErac1oraAF.lsnroraer.typeOFFLINEOFFLINEoraN1.lsnroraer.typeONLINEONLINErac2oraN2.lsnroraer.typeONLINEONLINErac1oraN3.lsnroraer.typeONLINEONLINErac1oranr.typeONLINEONLINErac1ora.OCR_VOT.dgoraup.typeONLINEONLINErac1ONLINEONLINErac1ONLINEONLINErac1ONLINEONLINErac1oraip.typeONLINEONLINErac1oraer.typeOFFLINEOFFLINEoradb.typeONLINEONLINErac1oranetworkorark.typeONLINEONLINErac1ONLINEONLINExy_advmoravm.typeOFFLINEOFFLINEora.qosmserveroraer.typeONLINEONLINErac1oraC1.lsnrapplicationONLINEONLINErac1applica