参考分析案例redhat 5 6 xoracle 11g

1.2逻辑拓扑图RACNodes系统环境检查#cat/etc/redhat-#grep"modelname"/proc/cpuinfo#uname-r#grepSwapTotal/proc/meminfo#grepMemTotal/proc/meminfo#df-k安装的软件包所有需要安装的软件包，x32x64compat-libstdc++-33-3.2.3(32bit)glibc-2.5-24(32glibc-devel-2.5(32bit)libaio-libaio-0.3.106(32bit)libaio-devel-0.3.106(32bit)libgcc-4.1.2(32libstdc++-4.1.2(32bit)unixODBC-unixODBC-2.2.11(32bit)unixODBC-devel-2.2.11(32libstdc*numactl*sysstat*unixODBC*make*ksh*rpm–ivhunixODBC*compat*glibc*RACNodes/etc/hosts文件 查hosts文件报错）DNS（11grac1DNSServer用户配置相关操作thatOraclerequiresyoutodefinetheSCAN address( inthisexample)toresolveonyourDNStooneofthreepossibleIPaddressesinordertosuccessfullyinstallOraclegridinfrastructure!DefiningtheSCANaddressonlyinthehostsfilesforeachOracleRACnode,andnotinDNS,errorduringtheOraclegridinfrastructureinstall.hosts[root@11grac1named]#cd[root@11grac1etc]#cp-pnamed.caching-nameserver.conf [root@11grac1etc]#cp-pnamed.rfc1912.zones optionslisten-onport53{any;};listen-on-v6port53{::1;}; statistics-file"/var/named/data/named_stats.txt";

//Thoseoptionsshouldbeusedcarefullybecausethey////query- port//query-source-v6port {any;};allow-query-cache{any;};loggingchanneldefault_debugseveritydynamic;viewlocalhost_resolvermatch-s{any;};match-destinations{any;};recursionyes;include编辑named.zones文件，在末尾添加红色内容：（ .zerozone" "IN{file allow-update{none;};zone"60.168.192."{typefile"60.168.192.local";allow-update{none;};};[root@11grac1etc]#cd../[root@11grac1named]#cp-pnamed.local [root@11grac1named]#cp-pnamed.zero IN . ;serial;;;1D;.scanvipAscanvipA编辑60.168.192.local文件,红色为修改或者添加的内容（注意右下角的“点”记）@ .;;;; .1...内容： 内容： 2.4.5RACNodesbind[root@11grac1~]#servicenamedrestart[root@11grac1~]#chkconfignamedon[root@11grac2~]#servicenamedrestart[root@11grac2~]#chkconfignamedon2.4.6DNSgridoracle用户及其相关组（RAC[root@11grac1~]#groupadd-g1000oinstall[root@11grac1~]#groupadd-g1200asmadmin[root@11grac1~]#groupadd-g1201asmdba[root@11grac1~]#groupadd-g1202asmoper[root@11grac1~]#groupadd-g1300dba[root@11grac1~]#groupadd-g1301oper[root@11grac1~]#useradd-m-u1100-goinstall-Gasmadmin,asmdba,asmoper，dba-d/home/grid-s/bin/bashgrid[root@11grac1~]#useradd-m-u1101-goinstall-Gdba,oper,asmdba-d/home/oracle-s/bin/bashoracle[root@11grac1~]#passwdgrid[root@11grac1~]#passwdoracle[root@11grac1/]#mkdir-p/11grac/app/grid[root@11grac1/]#mkdir-p/11grac/app/11.2.0/grid[root@11grac1/]#chown-Rgrid:oinstall/11grac[root@11grac1/]#mkdir-p/11grac/app/oracle[root@11grac1/]#chownoracle:oinstall/11grac/app/oracle[root@11grac1/]#od-R755/11gracgridoracle用户的环境变量（RAC[grid@11grac1~]$vi.bash_profileexportORACLE_SID=+ASM1exportJAVA_HOME=/usr/local/javaexportORACLE_BASE=/ora11g/app/gridexportexportORACLE_PATH=/ora11g/app/orac exportTNS_ADMIN=$ORACLE_HOME/network/adminexportexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:$PATHexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jliblibumask[oracle@11grac1~]$vi.bash_profileexportORACLE_SID=racdb1exportexportJAVA_HOME=/usr/local/javaexportORACLE_BASE=/ora11g/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 dminexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS11=$ORACLE_HOME/nls/dataexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibumask022SHH用户等价（RAC[root@11grac1~]#su-grid[grid@11grac1~]$mkdir.ssh[grid@11grac1~]$od700.ssh/[grid@11grac1~]$cd.ssh/[grid@11grac1.ssh]$ssh-keygen-trsaGeneratingpublic/privatersakeypair.Enterfileinwhichtosavethekey(/home/grid/.ssh/id_rsa):回车Enterpassphrase(emptyfornopassphrase):回车Entersamepassphraseagain:回车Youridentificationhasbeensavedin/home/grid/.ssh/id_rsa.Yourpublickeyhasbeensavedin/home/grid/.ssh/id_rsa.pub.Thekeyfingerprintis:[grid@11grac1.ssh]$ssh-keygen-tdsaGeneratingpublic/privatedsakeyEnterfileinwhichtosavethekey(/home/grid/.ssh/id_dsa):回车Enterpassphrase(emptyfornopassphrase):回车Entersamepassphraseagain:回车Youridentificationhasbeensavedin/home/grid/.ssh/id_dsa.Yourpublickeyhasbeensavedin/home/grid/.ssh/id_dsa.pub.Thekeyfingerprintis:45:02:a1:6e:a3:c1:96:61:89:32:49:ec:20:29:a4:30grid@11grac2[root@11grac2~]#su-grid[grid@11grac2~]$mkdir.ssh[grid@11grac2~]$od700.ssh/[grid@11grac2~]$cd.ssh/[grid@11grac2.ssh]$ssh-keygen-trsaGeneratingpublic/privatersakeypair.Enterfileinwhichtosavethekey(/home/grid/.ssh/id_rsa):回车Enterpassphrase(emptyfornopassphrase):回车Entersamepassphraseagain:回车Youridentificationhasbeensavedin/home/grid/.ssh/id_rsa.Yourpublickeyhasbeensavedin/home/grid/.ssh/id_rsa.pub.Thekeyfingerprintis:e1:7d:a5:de:01:5e:b0:18:14:b3:45:59:94:62:64:d8grid@11grac2[grid@11grac2.ssh]$ssh-keygen-tdsaGeneratingpublic/privatedsakeyEnterfileinwhichtosavethekey(/home/grid/.ssh/id_dsa):回车Enterpassphrase(emptyfornopassphrase):回车Entersamepassphraseagain:回车Youridentificationhasbeensavedin/home/grid/.ssh/id_dsa.Yourpublickeyhasbeensavedin/home/grid/.ssh/id_dsa.pub.Thekeyfingerprintis:45:02:a1:6e:a3:c1:96:61:89:32:49:ec:20:29:a4:30grid@11grac2添加密钥到密钥文件（authorized_keys）中[grid@11grac1.ssh]$cat*.pub>authorized_keys[grid@11grac2.ssh]$cat交换并同步密钥，[grid@11grac1.ssh]$scpauthorized_keys（会提示输入11grac2的grid用户[grid@11grac2.ssh]$catkeys[grid@11grac2.ssh]$scpauthorized_keys11grac1:/home/grid/.ssh/(提示会输入11grac1的grid用户)[grid@11grac1.ssh]$ssh11grac1SunAug2101:49:29CST[grid@11grac2.ssh]$sshprvt1Theauthenticityofhost'priv1(1)'can'tbeestablished.Areyousureyouwanttocontinueconnecting(yes/no)?yesSunAug2101:49:37CST[grid@11grac1.ssh]$sshprivt2Theauthenticityofhost'priv2(2)'can'tbeestablished.Areyousureyouwanttocontinueconnecting(yes/no)?yesSunAug2101:49:45CST[grid@11grac1.ssh]$ssh11grac2Areyousureyouwanttocontinueconnecting(yes/no)?yesWarning:Permanentlyadded'11grac2,2'(RSA)tothelistofknownhosts.SunAug2101:49:50CSToracle用户SHH配置OSKernel和Oracle相关S 限制（在RACNodes上均以root用户操作）编辑“/etc/sysctl.conf”文件,fs.file-max=kernel.shmmax kernel.shmmni=kernel.sem=25032000100net.ipv4.ip_local_port_range=9000net.core.rmem_default=262144net.core.rmem_max=net.core.wmem_default=262144net.core.wmem_max=grid if[\$USER="oracle"]||[\$USER="grid"];thenif[\$S="/bin/ksh"];thenulimit-pulimit-n65536elseulimit-u16384-nfiumaskfi禁用Selinux（RACNodes上）[root@11grac1~]#catetc/selinux/config[root@11grac2~]#cat/etc/selinux/config每次都会通过oracleCTSSntp自动同步时间；另外也可以通过配置ntp自身而不依赖oracle来同步时间）[root@11grac1~]#servicentpd[root@11grac1~]#chkconfigntpd[root@11grac1~]#mv/etc/ntp.conf[root@11grac2~]#servicentpd[root@11grac2~]#chkconfigntpd[root@11grac2~]#mv/etc/ntp.confASM磁盘[root@11grac1~]#rpm-qa|greporacleasm（/dev/sdc1,dev/sdc2,/dev/sdc3[root@11grac1~]#fdisk-Disk/dev/sda:26.8GB,26843545600255heads,63sectors/track,3263Units=of*=*LinuxswapDisk/dev/sdb:16.1 255heads,63sectors/track,1958cylindersUnits=cylindersof16065*512= Device1+Disk/dev/sdc:41.8GB,4187593113664heads,32sectors/track,39936cylindersUnits=cylindersof2048*512= 1Youhavenewmailin配置 [root@11grac1~]#/usr/sbin/oracleasmconfigure-iConfiguringtheOracleASMlibrarydriver.Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrarydriver.Thefollowingquestionswilldeterminewhetherthedriverisloadedonbootandwhatpermissionsitwillhave.Thecurrentvalueswillbeshowninbrackets('[]').Hitting<ENTER>withoutty answerwillkeepthatcurrentvalue.Ctrl-CwillDefaultusertoownthedriverinterface[]:gridDefaultgrouptoownthedriverinterface[]:asmadminStartOracleASMlibrarydriveronboot(y/n)[n]:yScanforOracleASMdisksonboot(y/n)[y]:yWritingOracleASMlibrarydriverconfiguration:ASM磁盘[root@11grac1/]#oracleasmcreatediskCRSVOL1/dev/sdc1Writingdiskheader:doneInstantiatingdisk:[root@11grac1/]#oracleasmcreatediskDATAVOL1/dev/sdc2Writingdiskheader:doneInstantiatingdisk:[root@11grac1/]#oracleasmcreatediskFRAVOL1/dev/sdc3Writingdiskheader:doneInstantiatingdisk:done[root@11grac1/]#oracleasmscandisksReloadingdiskpartitions:doneCleaninganystaleASMdisks...ScanningsystemforASMdisks...[root@11grac1/]#oracleasmlistdisks11grac2上扫描磁盘[root@11grac2~]#oracleasmReloadingdiskpartitions:doneCleaninganystaleASMdisks...ScanningsystemforASMdisks...Instantiatingdisk"DATAVOL1"Instantiatingdisk"CRSVOL1"Instantiatingdisk"FRAVOL1"[root@11grac2~]#oracleasm安装 forreceivetheerrormessage"Packagecvuqdisknotinstalled"whentheClusterVerificationUtilityisrun(eithermanuallyorattheendoftheOraclegrid(forexample,x86_64ori386).ThecvuqdiskRPMcanbefoundontheOraclegridinfrastructureinstallationmediaintherpmdirectory.Forthepurposeofthisarticle,theOraclegridinfrastructuremediawasextractedtothe/home/grid/software/oracle/griddirectoryonode1asthegriduser.[root@11grac1rpm]#CVUQDISK_GRP=oinstall;exportCVUQDISK_GRP[root@11grac2rpm]#CVUQDISK_GRP=oinstall;export[root@11grac1~]#rpm-qa|grepcvuqdisk[root@11grac2~]#rpm-qa|grepcvuqdisk[root@11grac1~]#ls-l-rwsr-xr-x1rootoinstall12872May292009[root@11grac2~]#ls-l-rwsr-xr-x1rootoinstall12872May292009 [grid@11grac1grid]$./runcluvfy.shstage-precrsinst-fixup-n11grac1,11grac2-verbosePerformingpre-checksforclusterservicessetupCheckingnodereachability...Check:Nodereachabilityfromnode"11grac1"DestinationNode Result:Nodereachabilitycheckpassedfromnode"CheckinguserCheck:UserequivalenceforuserNode Result:Userequivalencecheckpassedforuser"grid"Checkingnodeconnectivity...CheckinghostsconfigNode VerificationofthehostsconfigfileInterfaceinformationfornode IPAddress Def.Gateway HWAddress 00:0C:29:5B:7D:76 00:0C:29:5B:7D:76 00:0C:29:5B:7D:76 00:0C:29:5B:7D:80virbr0 00:00:00:00:00:00Interfaceinformationfornode IPAddress Def.Gateway HWAddress 00:0C:29:74:33:D7 00:0C:29:74:33:D7 00:0C:29:74:33:D7 00:0C:29:74:33:E1virbr0 00:00:00:00:00:00Check:Nodeconnectivityofsubnet

11Check:TCPconnectivityofsubnet"

Result:TCPconnectivitycheckpassedforsubnet"Check:Nodeconnectivityofsubnet Result:Nodeconnectivitypassedforsubnet""withnode(s)Check:TCPconnectivityofsubnet Result:TCPconnectivitycheckpassedforsubnet""Check:NodeconnectivityofsubnetResult:Node "" Check:TCPconnectivityofsubnetResult:TCPconnectivitycheckfailedforsubnet（网卡virbr0，未使用不影响）Interfacesfoundonsubnet""thatarelikelycandidatesforVIPare:11grac2eth0:2eth0:5eth0:411grac1eth0:1eth0:6Interfacesfoundonsubnet""thatarelikelycandidatesforaprivateinterconnectare:11grac2eth1:211grac1Interfacesfoundonsubnet""thatarelikelycandidatesforaprivateinterconnectare:11grac1Result:NodeconnectivitycheckCheck:TotalNode

1.96GB 1.96GB

1.5GB 1.5GB

Result:TotalmemorycheckCheck:AvailableNode

721.99MB704.09MB

50MB50MB

Result:AvailablememorycheckCheck:SwapNode

4GB 4GB

2.95GB 2.95GB

Result:SwapspacecheckCheck:diskspacefor Node Mount Result:diskspacecheckpassedfor"11grac2:/tmp"Check:diskspacefor Node Mount /diskspaceCheck:UserexistenceforNode

Result:Userexistencecheckpassedfor"Check:GroupexistenceforNode

Result:Groupexistencecheckpassedfor"Check:GroupexistenceforNode

Result:Groupexistencecheckpassedfor"Check:Membershipofuser"grid"ingroup"oinstall"[asNode User GroupExistsUserinGroup Result:Membershipcheckforuser"grid"ingroup"oinstall"[asPrimary]Check:Membershipofuser"grid"ingroupNode User GroupExistsUserinGroup Result:Membershipcheckforuser"grid"ingroup"dba"Check:RunNode run Result:RunlevelcheckpassedCheck:Hardlimitsfor"umopenfileNode Result:Hardlimitscheckpassedfor"umopenfileCheck:forumopenNodeResult:Softlimitscheckpassedfor"umopenfileCheck:forumuserNodeResult:Hardlimitscheckpassedfor"umuserCheck:forumuserNodeResult:Softlimitscheckpassedfor"umuserCheck:SystemNode Result:Check:NodeResult:KernelversioncheckCheck:Nodeparameter Result:KernelparametercheckCheck:KernelparameterforNode Result:KernelparametercheckCheck:KernelparameterforNode Result:KernelparametercheckCheck:KernelparameterforNode Result:KernelparametercheckCheck:KernelparameterforNode Result:Kernelparametercheckpassedfor"Check:parameterNode Result:Kernelparametercheckpassedfor"shmmni"Check:parameterNode Result:Kernelparametercheckpassedfor"Check:parameterNode Result:Kernelparametercheckpassedfor"file-Nodebetween9000Nodebetween9000&between9000&between9000&between9000&NodeNodeResult:Kernelparametercheckpassedfor"rmem_default"Check:Kernelparameterfor"rmem_max"Node Result:Kernelparametercheckpassedfor"Check:KernelparameterforNode Result:Kernelparametercheckpassedfor"wmem_default"Check:KernelparameterforNode Result:Kernelparametercheckpassedfor"Check:Kernelparameterfor"aio-max-Node Result:Kernelparametercheckpassedfor"aio-max-Check:Packageexistencefor"make-Node

Result:Packageexistencecheckpassedfor"make-Check:Packageexistencefor"binutils-Node Result:Packageexistencecheckpassedfor"binutils-Check:Packageexistencefor"gcc-Node

Result:Packageexistencecheckpassedfor"gcc-4.1"Check:Packageexistencefor"libaio-0.3.106Node

libaio-0.3.106-5(i386)libaio-0.3.106-5(i386)

libaio-0.3.106(i386)libaio-0.3.106(i386)

Result:Packageexistencecheckpassedfor"libaio-0.3.106(Check:Packageexistencefor"libaio-0.3.106Node libaio-0.3.106-5(x86_64)libaio-0.3.106(x86_64) libaio-0.3.106-5 libaio-0.3.106 Result:Packageexistencecheckpassedfor"libaio-0.3.106(Check:Packageexistencefor"glibc-2.5-24Node

glibc-2.5-58(i686)glibc-2.5-58

glibc-2.5-24(i686)glibc-2.5-24(i686)

Result:Packageexistencecheckpassedfor"glibc-2.5-24(Check:Packageexistencefor"glibc-2.5-24Node

glibc-2.5-58(x86_64)glibc-2.5-58

glibc-2.5-24(x86_64)glibc-2.5-24(x86_64)

Result:Packageexistencecheckpassedfor"glibc-2.5-24(Check:Packageexistencefor"compat-libstdc++-33-3.2.3Node compat-libstdc++-33-3.2.3-61(i386)compat-libstdc++-33-3.2.3(i386) compat-libstdc++-33-3.2.3-61(i386)compat-libstdc++-33-3.2.3(i386)Result:Packageexistencecheckpassedfor"compat-libstdc++-33-3.2.3(Check:Packageexistencefor"compat-libstdc++-33-3.2.3Node compat-libstdc++-33-3.2.3-61(x86_64) (x86_64)passed compat-libstdc++-33-3.2.3-61(x86_64) (x86_64)passedResult:Packageexistencecheckpassedfor"compat-libstdc++-33-3.2.3(Check:Packageexistencefor"elfutils-libelf-0.125Node elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.125(x86_64) elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.125(x86_64)Result:Packageexistencecheckpassedfor"elfutils-libelf-0.125(Check:Packageexistencefor"elfutils-libelf-devel-Node Result:Packageexistencecheckpassedfor"elfutils-libelf-devel-Check:Packageexistencefor Node

Result:Packageexistencecheckpassedfor Check:Packageexistencefor"glibc-devel-2.5Node glibc-devel-2.5-58(i386)glibc-devel-2.5(i386) glibc-devel-2.5-58 glibc-devel-2.5 Result:Packageexistencecheckpassedfor"glibc-devel-2.5(Check:Packageexistencefor"glibc-devel-2.5Node glibc-devel-2.5-58(x86_64)glibc-devel-2.5(x86_64)passed glibc-devel-2.5-58(x86_64) glibc-devel-2.5(x86_64) Result:Packageexistencecheckpassedfor"glibc-devel-2.5(Check:Packageexistencefor"glibc-headers-NodeName glibc-headers-2.5 passed Result:Packageexistencecheckpassedfor"glibc-headers-2.5"Check:Packageexistencefor"gcc-c++-Node

Result:Packageexistencecheckpassedfor"gcc-c++-Check:Packageexistencefor"libaio-devel-0.3.106Node libaio-devel-0.3.106-5(i386) libaio-devel-0.3.106(i386)passed libaio-devel-0.3.106-5(i386) libaio-devel-0.3.106(i386) Result:Packageexistencecheckpassedfor"libaio-devel-0.3.106(Check:Packageexistencefor"libaio-devel-0.3.106Node libaio-devel-0.3.106-5(x86_64) libaio-devel-0.3.106(x86_64) libaio-devel-0.3.106-5(x86_64) libaio-devel-0.3.106(x86_64)Result:Packageexistencecheckpassedfor"libaio-devel-0.3.106(Check:Packageexistencefor"libgcc-4.1.2Node libgcc-4.1.2-50.el5(i386)libgcc-4.1.2(i386) libgcc-4.1.2-50.el5 libgcc-4.1.2 Result:Packageexistencecheckpassedfor"libgcc-4.1.2(Check:Packageexistencefor"libgcc-4.1.2Node libgcc-4.1.2-50.el5(x86_64)libgcc-4.1.2(x86_64) libgcc-4.1.2-50.el5 libgcc-4.1.2 Result:Packageexistencecheckpassedfor"libgcc-4.1.2(Check:Packageexistencefor"libstdc++-4.1.2NodeName libstdc++-4.1.2-50.el5(i386) libstdc++-4.1.2(i386) libstdc++-4.1.2-50.el5(i386)libstdc++-4.1.2(i386) Result:Packageexistencecheckpassedfor"libstdc++-4.1.2(i386)"Check:Packageexistencefor"libstdc++-4.1.2Node libstdc++-4.1.2-50.el5(x86_64) libstdc++-4.1.2(x86_64) libstdc++-4.1.2-50.el5(x86_64) libstdc++-4.1.2(x86_64) Result:Packageexistencecheckpassedfor"libstdc++-4.1.2(Check:Packageexistencefor"libstdc++-devel-4.1.2Node libstdc++-devel-4.1.2-50.el5(x86_64)libstdc++-devel-4.1.2(x86_64) libstdc++-devel-4.1.2-50.el5(x86_64)libstdc++-devel-4.1.2(x86_64)Result:Packageexistencecheckpassedfor"libstdc++-devel-4.1.2(Check:Packageexistencefor"sysstat-Node

Result:Packageexistencecheckpassedfor"sysstat-Check:Packageexistencefor"unixODBC-2.2.11Node unixODBC-2.2.11-7.1(i386)unixODBC-2.2.11(i386) unixODBC-2.2.11-7.1 unixODBC-2.2.11 Result:Packageexistencecheckpassedfor"unixODBC-2.2.11(Check:Packageexistencefor"unixODBC-2.2.11Node unixODBC-2.2.11-7.1(x86_64) unixODBC-2.2.11(x86_64) unixODBC-2.2.11-7.1(x86_64) unixODBC-2.2.11(x86_64) Result:Packageexistencecheckpassedfor"unixODBC-2.2.11(Check:Packageexistencefor"unixODBC-devel-2.2.11Node unixODBC-devel-2.2.11-7.1(i386) unixODBC-devel-2.2.11(i386)Result:Packageexistencecheckpassedfor"unixODBC-devel-2.2.11(Check:Packageexistencefor"unixODBC-devel-2.2.11Node unixODBC-devel-2.2.11-7.1(x86_64)unixODBC-devel-2.2.11(x86_64) unixODBC-devel-2.2.11-7.1(x86_64)unixODBC-devel-2.2.11(x86_64)Result:Packageexistencecheckpassedfor"unixODBC-devel-2.2.11(Check:existencefor"Node

Result:Packageexistencecheckpassedfor" CheckingformultipleuserswithUIDvalueResult:CheckformultipleuserswithUIDvalue0Check:CurrentgroupResult:CurrentgroupIDcheckpassedCheckingCorefilenamepatternconsistency...CorefilenamepatternconsistencycheckCheckingtomakesureuser"grid"isnotin"root"groupNodeName

doesnotexistdoesnot

Result:User"grid"isnotpartof"root"group.CheckCheckdefaultuserfilecreationNode Result:DefaultuserfilecreationmaskcheckpassedStartingClocksynchronizationchecksusingNetworkTimeNTPConfigurationfilecheckNetworkTimeProtocol(NTP)configurationfilenotfoundonanyofthenodes.OracleClusterTimeSynchronizationService(CTSS)canbeusedinsteadofNTPfortimesynchronizationontheclusternodesResult:ClocksynchronizationcheckusingNetworkTimeProtocol(NTP)Pre-checkforclusterservicessetupwas[grid@11grac1grid]$./runcluvfy.shstage-posthwos-nPerformingpost-checksforhardwareandoperatingsystemsetupCheckingnodereachability...Check:Nodereachabilityfromnode"11grac1"DestinationNode Result:Nodereachabilitycheckpassedfromnode"CheckinguserCheck:UserequivalenceforuserNode Result:Userequivalencecheckpassedforuser"grid"Checkingnodeconnectivity...CheckinghostsconfigNode VerificationofthehostsconfigfileInterfaceinformationfornode IPAddress Def.Gateway HWAddress 00:0C:29:5B:7D:76 00:0C:29:5B:7D:76 00:0C:29:5B:7D:76 00:0C:29:5B:7D:80virbr0 00:00:00:00:00:00Interfaceinformationfornode IPAddress Def.Gateway HWAddress 00:0C:29:74:33:D7 00:0C:29:74:33:D7 00:0C:29:74:33:D7 00:0C:29:74:33:E1virbr0 00:00:00:00:00:00Check:Nodeconnectivityofsubnet 11Check:TCPconnectivityofsubnet

Result:TCPconnectivitycheckpassedforsubnet"Check:Nodeconnectivityofsubnet Result:Nodeconnectivitypassedforsubnet""withnode(s)Check:TCPconnectivityofsubnet Result:TCPconnectivitycheckpassedforsubnet""Check:Nodeconnectivityofsubnet forsubnet 11grac2,11grac1Check:TCPconnectivityofsubnetResult:TCPconnectivitycheckfailedforsubnetInterfacesfoundonsubnet""thatarelikelycandidatesforVIPare:11grac2eth0:2eth0:5eth0:411grac1eth0:1eth0:6Interfacesfoundonsubnet""thatarelikelycandidatesforaprivateinterconnectare:11grac2eth1:211grac1Interfacesfoundonsubnet""thatarelikelycandidatesforaprivateinterconnectare:11grac2virbr0:11grac1Result:NodeconnectivitycheckCheckingformultipleuserswithUIDvalueResult:CheckformultipleuserswithUIDvalue0Post-checkforhardwareandoperatingsystemsetupwas（都无报错，接下来可以放心的安装了InstallOracleGridInfrastructureforaGridPlugandy，SCAN，SCAN默认，ConfigureGNS（取消ClusterNodeAutomaticStorageCreateASMDiskASM选择“Usagesamepasswordsfortheseaccounts（由于我的设置的比较简单，所以oracle不推荐，没关系，继续next）选择“DouseInligenttformManagementInterface（IPMI”.依次选择组“asmdba、asmoper、Create文件解析SCANVIP,报错也可以忽略；其他的错误一律重视并解决。 RACNodesrootVIPCA和最后执行CVU检查整个过程的安装状况）ASMDiskgrid用户在任意一节点运行asmca点击“CreateDATA选对应的“DiskPath”，最后点击OK。同理创建“FRADiskDiskGroup，确认所有的在两个节点同时Mounted五、InstallOracleDatabase11gR2Oracle用户在任意一节点运行 ConfigrueSecuritySelectInstallation选择“InstallDatabaseSoftwareNodes选择“RealApplicationClusterDatabaseInstallSelectProductSelectDatabase选择“EnterpriseSpecifyInstallationPrivilegeOperatingSystemPerformPrerequisiteSummaryInstall此时正在向将节点文root用户在两节点执行root.sh六、CreatetheClusteroracle用户在任意一节点运行“ 选择“OracleRealApplicationClusters选择“Createa选择“GeneraPurposeorTransactionDatabaseManaged，SIDatabaseDatabaseFile选择“DATA”Disk）Recovery选择“FRA”DiskSchemas（DatabaseSummaryDatabase已经创建完成VerifyingClusterDatabaseAll[grid@11grac1grid]$crsctlstatusSTATE=ONLINEonSTATE=ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEonSTATE=ONLINEonSTATE=ONLINEon ,STATE=ONLINEon11grac1,ONLINEon ,STATE=ONLINEon11grac1,ONLINEon ,STATE=ONLINEon11grac1,ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEonSTATE=ONLINEon11grac1 ,STATE=ONLINEon11grac1,ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEon ,ONLINESTATE=ONLINEon11grac1,ONLINEonSTATE=ONLINEon11grac2STATE=ONLINEon11grac1[grid@11grac1~]$cluvfycompscan-VerifyingCheckingSingleAccessNameSCANSCANVIPeckingnameresolutionsetupforSCANIPVerificationofSCANVIPandListenersetupVerificationofscanwasVerifyingClockSynchronizationacrosstheCluster[grid@11grac1grid]$cluvfycompclocksync-VerifyingClockSynchronizationacrosstheclusternodesCheckingifClusterwareisinstalledonallnodes...CheckofClusterwareinstallCheckingifCTSSResourceisrunningonallnodes...Check:CTSSResourcerunningonallnodesNode Result:CTSSresourcecheckQueryingCTSSfortimeoffsetonallnodes...Result:QueryofCTSSfortimeoffsetCheckCTSSstatestarted...Check:CTSSstateNode CTSSisinActivestate.ProceedingwithcheckofclocktimeoffsetsonallReferenceTimeOffsetLimit:1000.0msecsCheck:ReferenceTimeOffsetNode Time Timeoffsetiswithinthespecifiedlimitsonthefollowingsetofnodes:Result:CheckofclocktimeoffsetsOracleClusterTimeSynchronizationServicescheckwassuccessfulChecktheHealthofthe[grid@11grac1grid]$crsctlcheckclusterCRS-4537:ClusterReadyServicesisonlineCRS-4529:ClusterSynchronizationServicesisonlineCRS-4533:EventManagerisonlineCheckAllDatabase[oracle@11grac1~]$srvctlstatusdatabase-dracdbInstanceracdb1isrunningonnode11grac1Instanceracdb2isrunningonnode11grac2[oracle@11grac1~]$srvctlstatusinstance-dracdb-iracdb1Instanceracdb1isrunningonnode11grac1[oracle@11grac1~]$srvctlstatusinstance-dracdb-iracdb2Instanceracdb2isrunningonnode11grac2CheckNodeApplication[oracle@11grac1~]$srvctlstatusnodeappsVIPoravip1isenabledVIPoravip1isrunningonnode:11grac1VIPoravip2isenabledVIPoravip2isrunningonnode:11grac2NetworkisenabledNetworkisrunningonnode:11grac1Networkisrunni