oracle11g安装与配置for redhat linux资源由美河学习收集提供_第1页
oracle11g安装与配置for redhat linux资源由美河学习收集提供_第2页
oracle11g安装与配置for redhat linux资源由美河学习收集提供_第3页
oracle11g安装与配置for redhat linux资源由美河学习收集提供_第4页
oracle11g安装与配置for redhat linux资源由美河学习收集提供_第5页
已阅读5页,还剩83页未读 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

软件安装与配Oracle11gRAC安装与配forRedHatLinux日作版日作版修改记一.准备工操作系统:RedHatEnterpriseLinuxserverrelease6.2ArcSDE9.3fororacle11gonlinux64bitRACIPIPIPORACLERACSCANLinux6.5AsmAsm大小10.710.71099.51099.52199.02199.02199.02199.0修改机器名(所有节点 vi viip检查网络静态IP地址SCAN 有DNS提供随机在安装前配置DNS大4个私有网络实现bonding,trunking,teaming等类似的技术对于公用网络必须支持ip[root@syspgisdb1~]#ifconfigeth0netmask[root@syspgisdb2~]#ifconfigeth0netmaskvi/etc/sysconfig/network-scripts/ifcfg-eth0su-vi加ip[root@syspgisdb1~]#vi tarzxvfrdac-LINUX-09.03.0C05.0439-source.tar.gzcdlinuxrdac-09.03.0C05.0439/makevititleRedHatEnterpriseLinuxServer(2.6.18-194.el5)root(hd0,0)kernel/vmlinuz-2.6.18-194.el5roroot=/dev/VolGroup00/LogVol00rhgbinitrd/mpp-2.6.18-禁用 SELNUX(所有节点关闭ServiceiptablesstatusServiceiptablesstopchkconfigiptablesoffchkconfigiptables–listserviceiptableschkconfig--level12345iptablesoffchkconfigiptables--list[root@rac1~]#vi/etc/selinux/config#ThisfilecontrolsthestateofSELinuxonthesystem.#SELINUX=cantakeoneofthesethreevalues:#enforcing-SELinuxis#permissive-SELinuxprintswarningsinsteadof#disabled-No#disabled-Nois#SELINUXTYPE=cantakeoneofthesetwo#targeted-Targetedprocessesareprotected,#mls-MultiLevelSecurityprotection.ftp服务(可选[root@localhost~]#rpm-qa|grepvsftpvi修改user_listchkconfig--level345vsftpdon检查服务器硬件和内存配lsb_release-auname–auname-交换查看:grepSwapTotal/proc/meminfomkdir-pddif=/dev/zeroof=/home/swap/swapfilebs=1Gcount=32mkswap/home/swap/swapfileswapon/home/swap/swapfileswapswapdefaults0磁盘至少2G的共享磁盘空间群集共享文件,至少6.5GB的磁盘空间dfdf-h/tmp检查软件需catuname-rpm-qrpm-qelfutilsrpm-qgccrpm-qglibcrpm-qkshrpm-qlibaiorpm-qrpm-qlibstdc++rpm-qmakerpm-qsysstatrpm-qunixODBCpackagecompat-libstdc++isnotrpmivh二、修改操作系统内存修改vi/etc/security/limits.conf#ORACLESETTINGgridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile修改OracleRAC/etc/pam.d/login[root@rac1~]#vi#forsessionrequired Vi/etc/profile[root@rac1~]#viif[/$USER="oracle"]||[/$USER="grid"];thenif[/$S="/bin/ksh"];thenulimit-pulimit-n

ulimit-u16384-nDave在OracleLinux6Oracle,可以使用PreinstalOracleLinux6下OracleRDBMSServer11gR2PreinstallRPMsysctlkernel.shamallkernel.shmmax= kernel.sem=25032000100kernel.shmmni=4096net.core.rmem_default=net.core.rmem_max=net.core.wmem_default=262144net.core.wmem_max=fs.file-maxfs.aio-max-nr= #net.core.rmem_default=262144#net.core.wmem_max=-NTP#/sbin/servicentpdstop#chkconfigntpdoff#mv crsctlcheck2.6.linux硬件时间设间,在系统开机时会自动从BIOS里面获取。硬件时间使用clock和hwclock设置:hwclock–show hwclock–set–date=“月/日/年时:分:秒”hwclock–systohchwclock-whwclock–hctosyshwclock–s因为时间差异过大时NTP不会同步ntpdate三、raw fdisk-fdisksdb150Gsdc150Gsdd1100sde1sdg1sdg1sdh1sdh2分[root@db1~]#fdiskpatiblemodeisdeprecated.It'sswitchoffthemode(command'c')andchangedissectors(command'u').mendedtoyunitstoCommand(mforhelp):Disk/dev/sde:536.9GB,536870912000255heads,63sectors/track,65270cylindersUnits=cylindersof16065*512 Sectorsize(logical/physical):512bytes/512bytesI/Osize(minimum/optimal):512bytes/512bytesDiskidentifier:0x000d60dcDevice Command(mforhelp):nCommandaction pPartitionnumber(1-4):Firstcylinder(1-65270,defaultUsingdefaultvalueLastcylinder,+cylindersor+size{K,M,G}(1-65270,default65270):Usingdefaultvalue65270Command(mforhelp):ThepartitiontablehasbeenCallingioctl()tore-readpartitiontable.Syncingdisks.UDEV绑 设vi/etc/udev/rules.d/60-raw.rulesvi/etc/udev/rules.d/60-raw.rules#Enterrawdevicebindingshere.#Anexamplewould#ACTION=="add",KERNEL=="sda",RUN+="/bin/raw/dev/raw/raw1%N"#tobind/dev/raw/raw1to/dev/sda,or #tobind/dev/raw/raw2tothedevicewithmajor8,minor1.#forocr_votingACTION=="add",KERNEL=="sdb1",RUN+="/bin/raw/dev/raw/raw1%N"ACTION=="add",KERNEL=="sdb2",RUN+="/bin/raw/dev/raw/raw2%N"ACTION=="add",KERNEL=="sdb3",RUN+="/bin/raw/dev/raw/raw3%N"#forFlash_RecoveryACTION=="add",KERNEL=="sdb5",RUN+="/bin/raw/dev/raw/raw4%N"ACTION=="add",KERNEL=="sdb6",RUN+="/bin/raw/dev/raw/raw5%N"ACTION=="add",KERNEL=="sdb7",RUN+="/bin/raw/dev/raw/raw6%N"#fordataACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw/dev/raw/raw7%N"ACTION=="add",KERNEL=="sdd1",RUN+="/bin/raw/dev/raw/raw8%N"ACTION=="add",KERNEL=="sde1",RUN+="/bin/raw/dev/raw/raw9%N"ACTION=="add",KERNEL=="sdf1",RUN+="/bin/raw/dev/raw/raw10%N"ACTION=="add",KERNEL=="sdg1",RUN+="/bin/raw/dev/raw/raw11%N"ACTION=="add",KERNEL=="sdh1",RUN+="/bin/raw/dev/raw/raw12%N"ACTION=="add",KERNEL=="sdi1",RUN+="/bin/raw/dev/raw/raw13%N"ACTION=="add",KERNEL=="sdj1",RUN+="/bin/raw/dev/raw/raw14%N"KERNEL=="raw[1-9]*",OWNER="grid",GROUP="asmadmin",MODE="660"重启UDEV:[root@db1rules.d]#ll/dev/rawtotal0crw-rw----1gridasmadmin 1Jul1115:19 1gridasmadmin162,10Jul1115:19 1gridasmadmin162,11Jul1115:19 1gridasmadmin162,12Jul1115:19 1gridasmadmin162,13Jul1115:19 1gridasmadmin162,14Jul1115:19 1gridasmadmin 1gridasmadmin 1gridasmadmin 1gridasmadmin 1gridasmadmin 1gridasmadmin 1gridasmadmin 1gridasmadmincrw-rw----1root

2Jul1115:193Jul1115:194Jul1115:195Jul1115:196Jul1115:197Jul1115:198Jul1115:199Jul1115:190Jul1115:192.4[root@rac1dev]# [root@rac1rules.d]#cd/dev[root@rac1dev]#ls-alasm-disk*brw-rw----1oracledba 17Sep brw-rw----1oracledba 33Sep brw-rw----1oracledba 49Sep brw-rw----1oracledba 65Sep brw-rw----1oracledba 81Sep brw-rw----1oracledba 97Sep brw-rw----1oracledba8,113Sep 四、创建用户及配置环境添加组和用/usr/sbin/groupadd-g501/usr/sbin/groupadd-g502/usr/sbin/groupadd-g503/usr/sbin/groupadd-g504/usr/sbin/groupadd-g505/usr/sbin/groupadd-g506/usr/sbin/useradd-goinstall-Gdba,asmdba,oper/usr/sbin/useradd-goinstall-Gasmadmin,asmdba,asmoper,oper,dba备注:usermod-d/home/test-Gtest2passwdgrid创mkdir-pchown-Rgrid:oinstall/oracle/oraInventoryod-R775/oracle/oraInventorymkdir-pchown-Rgrid:oinstall/oracle/gridod-R775/oracle/gridmkdir-p/oracle/app/cfgtoollogs--neededtoensurethatdbcaisabletorunaftertherdbmsinstallation.mkdir-p/oracle/app/product/11.2.0/db_1chown-Roracle:oinstall/oracle/appchownoracle:oinstall/oracleod-R775GridexportexportORACLE_BASE=/oracle/oracleexportTEMP=/tmpexportTMP=/tmpumask022#exportOracleexportexportORACLE_UNQNAME=slgapgisdb;exportORACLE_TERM=xterm;exportNLS_DATE_FORMAT="YYYY:MM:DDexportNLS_LANG=american_america.ZHS16GBK;exportORA_NLS11=$ORACLE_HOME/nls/data;exportPATHexportLD_LIBRARY_PATHexportexportTEMP=/tmpexport五、 划[root@cmsnmdb1~]#fdiskfdisk–l5.1及安装 rpm-Uvhoracleasm-support-2.1.3-1.el5.x86_64.rpmrpm-ivhkmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm--nodepsoracleasmlib-2.0.4-1.el5.x86_64.rpm\[root@cmsnmdb1oracle]#rpm-Uvhoracleasm-support-2.1.3-1.el5.x86_64.rpmwarning:oracleasm-support-2.1.3-1.el5.x86_64.rpm:HeaderV3DSAsignature:NOKEY,keyID1e5e0159Preparing...###########################################[100%]1:oracleasm-support###########################################[33%][root@cmsnmdb1warning:oracleasm-support-2.1.8-1.el6.x86_64.rpm:HeaderV3RSA/SHA256[root@PGIS67~]#rpm-ivhoracleasmlib-2.0.4-1.el6.x86warning:oracleasmlib-2.0.4-1.el6.x86_64.rpm:HeaderV3RSA/SHA256Signature,keyIDec551f03:NOKEYerror:Failedoracleasm>=1.0.4isneededbyoracleasmlib-2.0.4-1.el6.x86_64[root@PGIS67~]#rpm-ivhoracleasm>=1.0.4isneededbyoracleasmlib-2.0.4-1.el6.x86_64[root@PGIS67~]#rpm-ivhoracleasmlib-2.0.4-1.el6.x86_64.rpm--nodeps [root@PGIS67~]#rpm-ivhkmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpmerror:Faileddependencies: kernel<2.6.32-359.el6isneededbykmod-oracleasm-2.0.6.rh1-2.el6.x86_64[root@PGIS67~]#rpm-ivhkmod-oracleasm-2.0.6.rh1-2.el6.x8664.rpm--nodeps [root@PGIS67~]#rpm-qa|grepasm[root@PGIS67~]#5.2/etc/init.d/oracleasm[root@cmsnmdb1oracle]#/etc/init.d/oracleasmconfigureConfiguringtheOracleASMlibrarydriver.Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrarydriver.Thefollowingquestionswilldeterminewhetherthedriverisloadedonbootandwhatpermissionsitwillhave.Thecurrentvalueswillbeshowninbrackets('[]').Hitting<ENTER>withouttyananswerwillkeepthatcurrentvalue.Ctrl-Cwillabort.Defaultusertoownthedriverinterface[]:gridDefaultgrouptoownthedriverinterface[]:asmadminStartOracleASMlibrarydriveronboot(y/n)[n]:yScanforOracleASMdisksonboot(y/n)[y]:yWritingOracleASMlibrarydriverconfiguration:doneInitializingtheOracleASMLibdriver:[OK]ScanningthesystemforOracleASMLibdisks:[OK5.3fdiskfdisk最后查看结果fdisk–l#ls/dev/sd*/etc/init.d/oracleasmcreatediskOCR_VOTE01/etc/init.d/oracleasmcreatediskOCR_VOTE02/etc/init.d/oracleasmcreatediskFLASHBACK01/etc/init.d/oracleasmcreatediskARCVG01/etc/init.d/oracleasmcreatediskDATAVG01/etc/init.d/oracleasmcreatediskDATAVG02/etc/init.d/oracleasmcreatediskDATAVG03/etc/init.d/oracleasmcreatediskDATAVG04[root@cmsnmdb1oracle]#/etc/init.d/oracleasmcreatediskOCR_VOTE01/dev/sda1Markingdisk"OCR_VOTE01"asanASMdisk:[OK][root@cmsnmdb1oracle]#/etc/init.d/oracleasmscandisksScanningthesystemforOracleASMLibdisks:[OK]/etc/init.d/oracleasm[root@cmsnmdb1oracle]#/etc/init.d/oracleasm[root@cmsnmdb1出错查看日志:tail六为用户等效性配置grid用户同oraclesu-oraclemkdir~/.sshod755~/.sshssh-keygentrsassh-keygentdsa在一个节点1上cat~/.ssh/id_rsa.pubssh/authorized_keyscat~/.ssh/id_dsa.pub~/.ssh/authorized_keyssshslgapgisdb2cat~/.ssh/id_rsa.pub~/.ssh/authorized_keyssshslgapgisdb2cat~/.ssh/id_dsa.pub~/.ssh/authorized_keysscp~/.ssh/authorized_keysslgapgisdb2:~/.ssh/authorized_keys在一个节点2上cat~/.ssh/id_rsa.pubssh/authorized_keyscat~/.ssh/id_dsa.pub~/.ssh/authorized_keyssshslgapgisdb1cat~/.ssh/id_rsa.pub~/.ssh/authorized_keyssshslgapgisdb1cat~/.ssh/id_dsa.pub~/.ssh/authorized_keysscp~/.ssh/authorized_keysslgapgisdb1:~/.ssh/authorized_keysexec/usr/bin/ssh-agentsshslgapgisdb1datesshslgapgisdb2sshslgapgisdb1-privdatesshslgapgisdb2-privdate[root@cmsnmdb1~]#su-oracle[oracle@cmsnmdb1~]$mkdir~/.ssh[oracle@cmsnmdb1~]$od755~/.ssh[oracle@cmsnmdb1~]$ssh-keygen-tGeneratingpublic/privatersakeyEnterfileinwhichtosavethekey(/home/oracle/.ssh/id_rsa):Enterpassphrase(emptyfornopassphrase):EntersamepassphraseYouridentificationhasbeensavedinYourpublickeyhasbeensavedin/home/oracle/.ssh/id_rsa.pub.Thekeyfingerprintis:[oracle@cmsnmdb1~]$ssh-keygen-tdsaGeneratingpublic/privatedsakeyEnterfileinwhichtosavethekey(/home/oracle/.ssh/id_dsa):Enterpassphrase(emptyfornopassphrase):EntersamepassphraseYouridentificationhasbeensavedin/home/oracle/.ssh/id_dsa.Yourpublickeyhasbeensavedin/home/oracle/.ssh/id_dsa.pub.Thekeyfingerprintis:[oracle@cmsnmdb1~]$cat~/.ssh/id_rsa.pub>>./.ssh/authorized_keys[oracle@cmsnmdb1~]$cat~/.ssh/id_dsa.pub>>./.ssh/authorized_keys[oracle@cmsnmdb1~]$sshcmsnmdb2cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keysTheauthenticityofhost'cmsnmdb2()'can'tbeestablished.RSAkeyfingerprintis78:b1:fc:a7:a2:58:0f:ef:14:75:b2:f9:3f:ad:4f:e5.Areyousureyouwanttocontinueconnecting(yes/no)?yesWarning:Permanentlyadded'cmsnmdb2,'(RSA)tothelistofknownhosts.oracle@cmsnmdb2'spassword:[oracle@cmsnmdb1~]$sshcmsnmdb2cat~/.ssh/id_dsa.pub>>~/.ssh/authorized_keysoracle@cmsnmdb2'spassword:[oracle@cmsnmdb1~]$scp~/.ssh/authorized_keyscmsnmdb2:~/.ssh/authorized_keysoracle@cmsnmdb2'spassword:100%20042.0KB/s[oracle@cmsnmdb1~]$sshcmsnmdb2dateThuDec3017:18:20CST2010[oracle@cmsnmdb1~]$sshcmsnmdb1Theauthenticityofhost'cmsnmdb1()'can'tbeestablished.RSAkeyfingerprintis16:83:72:3b:f0:fe:ca:73:26:f0:3b:6c:a5:47:43:ce.Areyousureyouwanttocontinueconnecting(yes/no)?yesWarning:Permanentlyadded'cmsnmdb1'(RSA)tothelistofknownThuDec3017:18:45CST[oracle@cmsnmdb1~]$sshcmsnmdb1dateThuDec3017:18:49CST2010[oracle@cmsnmdb1~]$sshcmsnmdb1-privdateThuDec3017:19:36CST2010[oracle@cmsnmdb1~]$sshcmsnmdb2-privTheauthenticityofhost'cmsnmdb2-priv()'can'tbeestablished.RSAkeyfingerprintis78:b1:fc:a7:a2:58:0f:ef:14:75:b2:f9:3f:ad:4f:e5.Areyousureyouwanttocontinueconnecting(yes/no)?Warning:Permanentlyadded'cmsnmdb2-priv,'(RSA)tothelistofknownThuDec3017:19:28CST[oracle@cmsnmdb1~]$sshcmsnmdb2-privdateThuDec3017:19:31CST2010[oracle@cmsnmdb13/7为grid软件;安装前自安装Grid软件前先检查配置信息:[grid@rac1grid]$./runcluvfy.shstage-precrsinst-slgapgisdb1,slgapgisdb2-fixup安装GRID的包,在安装程式grid/rpm[root@rac01rpm]#rpm-Uvhcvuqdisk-1.0.9-Preparing...###########################################Usingdefaultgroupoinstalltoinstall1:cvuqdisk###########################################grid使用Xmanager连接到节点1上,设置DISY。这里强调顺序是节点1,因为在节点2ExportDIS[grid@PGIS65grid]$exportLANG=en_US注意:这里 名称必须和hosts文件中定义的一致同时取消配置GNS选项点击SSH连接按钮,输入 注意:在11gr2external>=normalhigh指定$ORACLE_BASE和在第一个节点执行在第二个节点执行在第一个节点执行在第二个节点执行版有个Oracle11gRACohasdfailedtostart/u01/app/11.2.0/grid/crs/install/rootcrs.plline443OracleRACroot.shTimedoutwaitingfortheCRSstackto[grid@rac1u01]$crs_stat.shNameTargetStateHostora.LISTENER.lsnrONLINEONLINErac1ora.LISTENER_SCAN1.lsnrONLINEONLINErac1ora.OCRVOTING.dgONLINEONLINErac1ora.asmONLINEONLINErac1ora.eonsONLINEONLINErac1ora.gsdOFFLINEOFFLINEworkONLINEONLINErac1ora.oc4jOFFLINEOFFLINEora.onsONLINEONLINErac1ora.rac1.ASM1.asmONLINEONLINErac1ora.rac1.LISTENER_RAC1.lsnrONLINEONLINErac1ora.rac1.gsdOFFLINEOFFLINEora.rac1.onsONLINEONLINErac1ora.rac1.vipONLINEONLINErac1ora.rac2.ASM2.asmONLINEONLINErac2ora.rac2.LISTENER_RAC2.lsnrONLINEONLINErac2ora.rac2.gsdOFFLINEOFFLINEora.rac2.onsONLINEONLINErac2ora.rac2.vipONLINEONLINErac2ora.scan1.vipONLINEONLINE因为我们使用CTSS来同步的,验证[grid@rac1u01]$crsctlcheckCRS-4701:TheClusterTimeSynchronizationServiceisinActivemode.CRS-4702:Offset(inmsec):0原因为在hosts里指定了scanip,请在两个节点分别对scanip进行 至此,GIASM用gird用户登录注意:在11gr2external>=normalhigh9.1oracle用oracle用户,连上节点1,进入Oracle的安装 ,安装Oracle软件,oracle[oracle@PGIS65database]$export[oracle@PGIS65database]$SelectallRACEnterpriseEdition企业版安装,下一步:选择Oracle安装cluvfycompclocksync-nall执行PerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesareset Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thecontentsof"dbhome"havenotchanged.Noneedtooverwrite.Thecontentsof"oraenv"havenotchanged.Noneedtooverwrite.Thecontentsof"coraenv"havenotchanged.Noneedtooverwrite.Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Finishedproduct-specificrootactions.[root@pgis65~]#PerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracle Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thecontentsof"dbhome"havenotchanged.Noneedtooverwrite.Thecontentsof"oraenv"havenotchanged.Noneedtooverwrite.Thecontentsof"coraenv"havenotchanged.Noneedtooverwrite.Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Finishedproduct-specificrootactions.[root@pgis67~]#在节点1Oracledbca,RACCreateaEnterpriseManagerAutomaticMaintenance设置数据文件存放位置:: SQL*Plus:Release.0ProductiononFriJun1714:03:522011Copyright(c)1982,2010,Oracle. Allrights.ConnectedOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththeRealApplicationClustersandAutomaticStorageManagementoptionsSQL>alter asmsnmporacle11G;Useraltered.设置FRA保持默认设置和勾选AutomaticArchiving[root@pgis67~]#export[root@pgis67~]#/u01/app/oracle/product/11.2.0/db_1/bin/emctlstartdbconsoleOracleEnterpriseManager11gDatabaseControlRelease.0Copyright(c)1996,2013Oracle All Logsaregeneratedindirectory/u01/app/oracle/product/11.2.0/db_1/pgis67_zzpgisdb/sysman/log[root@pgis67~]#两台服务器上 试[oracle@pgis67~]$sqlplus"/asSQL*Plus:Release.0Productionon星期日11月915:23:332014Copyright(c)1982,2013,Oracle. Allrights.ConnectedOracleDatabase11gEnterpriseEditionRelease.0-64bitWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>exitDisconnectedfromOracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptions[oracle@pgis67~]$exportLANG=C[oracle@pgis67~]$srvctlstatusdatabase-dzzpgisdbInstancezzpgisdb1isnotrunningonnodepgis65Instancezzpgisdb2isnotrunningonnodepgis67[oracle@pgis67~]$crs[grid@pgis67~]$crs_stop-all[grid@pgis65~]$crs_stat-t[grid@pgis65~]$crs_start-all[grid@pgis65~]$crs_stat-t附录一、 问题一.问题在OracleLinux6.1上安装的RAC,在安装grid时执行root.sh,报错,如RunningOracle11groot.shscript...Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=/u01/app/11.2.0/gridEnterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Copyingdbhometo/usr/local/bin...Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofroot.shscript.Nowproduct-specificrootactionswillbeperformed.2012-06-2710:31:18:Parsingthehostname2012-06-2710:31:18:UserhassuperUsingconfigurationparameterfile:/u01/app/11.2.0/grid/crs/install/crsconfig_paramsCreatingtracedirectoryLOCALADDCreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.rootwalletrootwalletrootcertexportpeerwalletpeerwalletkeyspawalletkeyspeercertrequestpacertrequestpeercertpeerrootcertprofilereaderrootcertTPparootcertTPpeerpacertTPpapeercertprofilereaderpacertTPprofilereaderpeercertTPpeerusercertpauserAddingdaemontoCRS-4124:OracleHighAvailabilityServicesstartupfailed.CRS-4000:CommandStartfailed,orcompletedwitherrors.ohasdfailedtostart:Inappropriateioctlfordevice据说这个错误只在linux6.1Oracle的时候出现,在root立即执行命令:RAC卸载说明rm–rfrm-rf/etc/init.d/init.cssdrm-rf/etc/init.d/init.crsrm-rf/etc/init.d/init.crsdrm-rf/etc/rc2.d/K96init.crsrm-rf/etc/rc2.d/S96init.crsrm-rf/etc/rc3.d/K96init.crsrm-rf/etc/rc3.d/S96init.crsrm-rf/etc/rc5.d/K96init.crsrm-rf/etc/rc5.d/S96init.crsrm-rf/etc/oracle/scls_scrrm-rf/etc/inittab.crsrm-rf/var/tmp/.oracle/*rm-rf移除ocr.loc文件,通常在 [root@rac1~]#cdYouhavenewmailin/var/spool/mail/root[root@rac1oracle]#lslastgaspocr.lococr.loc.origolr.locolr.loc.origoprocd[root@rac1oracle]#rm-rfocr.*格式化ASM设备[root@rac1utl]#ll 1oracledba8,17Jun2709:38/dev/asm-brw-rw----1oracledba8,33Jun2709:38/dev/asm-brw-rw----1oracledba8,49Jun2709:38/dev/asm-brw-rw----1oracledba8,65Jun2709:38/dev/asm-ddif=/dev/zeroof=/dev/asm-disk1bs=1Mcount=256ddif=/dev/zeroof=/dev/asm-disk2bs=1Mcount=256ddif=/dev/zeroof=/dev/asm-disk3bs=1Mcount=256ddif=/dev/zeroof=/dev/asm-disk4bs=1Mcount=256移除 [root@rac1~]#rm-rf #rm-rf/data/oracle#rm-rf/var/opt/oracle #rm-rf/usr/local/bin/dbhome#rm-rf/usr/local/bin/oraenv#rm-rf/usr/local/bin/coraenv移除Grid安 [root@rac1oracle]#rm-rf[root@rac2u01]#mkdir-p[root@rac2u01]#mkdir-p/u01/app/oracle/product/11.2.0/db_1[root@rac2u01]#chown-Roracle:oinstall/u01 od-R775root.sh[root@rac1oracle]#/u01/app/11.2.0/grid/crs/install/rootcrs.pl-deconfig-verbose-2012-06-2714:30:17:Parsingthehostname2012-06-2714:30:17:Checkingfor2012-06-2714:30:17:Userhas/u01/app/11.2.0/grid/bin/crsctlcheckcluster-nrac1Usage:srvctl<command><object>[<options>]Fordetailedhelponeachcommandandobjectanditsoptionsuse:srvctl<command>-horPRKO-2012:nodeappsobjectisnotsupportedinOracleRestartsh:/u01/app/11.2.0/grid/bin/clsecho:NosuchfileordirectoryCan'texec"/u01/app/11.2.0/grid/bin/clsecho":Nosuchfileordirectoryat/u01/app/11.2.0/grid/lib/acfslib.pmline937.YoumustkillcrsprocessesorrebootthesystemtoproperlycleanuptheprocessesstartedbyOracleclusterware2560+0recordsin2560+0recordsbytes(10MB)copied,0. s,281MB/serror:packagecvuqdiskisnotinstalledSuccessfullydeconfiguredOracleclusterwarestackonthisnodeYouhavenewmailin/var/spool/mail/root在执行/u01/app/11.2.0/grid/root.sh的时候开2个root的s 行,一个用来/var/tmp/.oracle/npohasd文件,看到就用root立即执行命令:/bin/ddif=/var/tmp/.oracle/npohasdof=/dev/nullbs=1024count=1[root@rac1oracle]#/u01/app/11.2.0/grid/root.shRunningOracle11groot.shThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=/u01/app/11.2.0/gridEnterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thefile"dbhome"alreadyexistsin/usr/local/bin.Overwriteit?(y/n)Thefile"oraenv"alreadyexistsin/usr/local/bin.Overwriteit?(y/n)Thefile"coraenv"alreadyexistsin/usr/local/bin.Overwriteit?(y/n)Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofroot.shscript.Nowproduct-specificrootactionswillbeperformed.2012-06-2714:32:21:Parsingthehostname2012-06-2714:32:21:UserhassuperUsingconfigurationparameterfile:/u01/app/11.2.0/grid/crs/install/crsconfig_paramsLOCALADDMODECreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.rootwalletcertrootcertexportpeerwalletprofilereaderwalletpeerwalletkeyspawalletkeyspeercertrequestpacertrequestpeercertpeerrootcertprofilereaderrootcertTPparootcertTPpeerpacertTPpapeercertprofilereaderpacertTPprofilereaderpeercertTPpeerusercertpauser注root.sh执行到这里的时候,我们就可以在另一个窗口不断的刷我们的dd命令了,如/bin/dd:opening`/var/tmp/.oracle/npohasd':NosuchfileordirectoryYouhavenewmailin/var/spool/mail/rootAddingdaemontoCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.ohasdisstartingADVM/ACFSisnotsupportedonoraclelinux-release-6Server-1.0.2.x86_64CRS-2672:Attemptingtostart'ora.gipcd'on'rac1'CRS-2672:Attemptingtostart'ora.mdnsd'on'rac1'CRS-2676:Startof'ora.gipcd'on'rac1'succeededCRS-2676:Startof'ora.mdnsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'rac1'CRS-2676:Startof'ora.gpnpd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'rac1'CRS-2676:Startof'ora.cssdmonitor'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssd'on'rac1'CRS-2676:Startof'ora.diskmon'on'rac1'succeededCRS-2676:Startof'ora.cssd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.ctssd'on'rac1'CRS-2676:Startof'ora.ctssd'on'rac1'succeededASMcreatedandstartedsuccessfully.DiskGroupDATAcreatedsuccessfully.clscfg:-installmodespecifiedSuccessfullyaccumulatednecessaryOCRkeys.CreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.CRS-2672:Attemptingtostart'ora.crsd'on'rac1'CRS-2676:Startof'ora.crsd'on'rac1'succeededCRS-4256:UpdatingtheprofileSuccessfuladditionofvotingdisk372c42f3b2bc4f66bf8b52d Successfullyrecedvotingdiskgroupwith+DATA.## FileUniversal FileNameDisk e3(/dev/asm-disk1)[DATA]Located1votingdisk(s).CRS-2673:Attemptingtostop'ora.crsd'on'rac1'CRS-2677:Stopof'ora.crsd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.asm'on'rac1'CRS-2677:Stopof'ora.asm'on'rac1'succeededCRS-2673:Attemptingtostop'ora.ctssd'on'rac1'CRS-2677:Stopof'ora.ctssd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.cssdmonitor'on'rac1'CRS-2677:Stopof'ora.cssdmonitor'on'rac1'succeededCRS-2673:Attemptingtostop'ora.cssd'on'rac1'CRS-2677:Stopof'ora.cssd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.gpnpd'on'rac1'CRS-2677:Stopof'ora.gpnpd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.gipcd'on'rac1'CRS-2677:Stopof'ora.gipcd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.mdnsd'on'rac1'CRS-2677:Stopof'ora.mdnsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.mdnsd'on'rac1'CRS-2676:Startof'ora.mdnsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.gipcd'on'rac1'CRS-2676:Startof'ora.gipcd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'rac1'CRS-2676:Startof'ora.gpnpd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'rac1'CRS-2676:Startof'ora.cssdmonitor'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssd'on'rac1'CRS-2672:Attemptingtostart'ora.diskmon'on'rac1'CRS-2676:Startof'ora.diskmon'on'rac1'succeededCRS-2676:Startof'ora.cssd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.ctssd'on'rac1'CRS-2676:Startof'ora.ctssd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.asm'on'rac1'CRS-2676:Startof'ora.asm'on'rac1'succeededCRS-2672:Attemptingtostart'ora.crsd'on'rac1'CRS-2676:Startof'ora.crsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.evmd'on'rac1'CRS-2676:Startof'ora.evmd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.asm'on'rac1'CRS-2676:Startof'ora.asm'on'rac1'succeededCRS-2672:Attemptingtostart'ora.DATA.dg'on'rac1'CRS-2676:Startof'ora.DATA.dg'on Preparingpackagesforinstallation...ConfigureOracleGridInfrastructureforaCluster...succeededUpdatinginventorypropertiesforclusterwareCheckingswapspace:mustbegreaterthan500MB. Actual969MB Theinventorypointerislocatedat/etc/oraInst.locTheinventoryislocatedat/u01/app/oraInventory'UpdateNodeList'wassuccessful.附录二root.shVBoxRAC以后的版本line433.解决方法参考:2root.sTimedoutwaitingfortheCRSstacktostart的错误,其实这个错误在之前的安装过程中也遇到过,所以看了以前的记录,发现出OracleRACroot.shTimedoutwaitingfortheCRSstacktostart[root@rac2grid]#/u01/grid/root.shRunningOracle11groot.shscript...Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=gridORACLE_HOME=Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thefile"dbhome"alreadyexistsin/usr/local/bin.Overwriteit?(y/n)[n]:yThefile"oraenv"alreadyexistsin/usr/local/bin.Overwriteit?(y/n)[n]:yThefile"coraenv"alreadyexistsin/usr/local/bin.Overwriteit?(y/n)[n]:yEntrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofroot.shscript.Nowproduct-specificrootactionswillbeperformed.2012-10-1101:58:50:Parsingthehostname2012-10-1101:58:50:UserhassuperUsingconfigurationparameterfile:/u01/grid/crs/install/crsconfig_paramsCreatingtracedirectoryLOCALADDCreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.AddingdaemontoCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.ohasdisstartingCRS-4402:TheCSSdaemonwasstartedinexclusivemodebutfoundanactiveCSSdaemononnoderac1,number1,andisterminatingAnactiveclusterwasfoundduringexclusivestartup,restartingtojointheclusterCRS-2672:Attemptingtostart'ora.mdnsd'on'rac2'CRS-2676:Startof'ora.mdnsd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.gipcd'on'rac2'CRS-2676:Startof'ora.gipcd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'rac2'CRS-2676:Startof'ora.gpnpd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'rac2'CRS-267

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论