Oracle11R2安装ASM+RAC配置步骤_第1页
Oracle11R2安装ASM+RAC配置步骤_第2页
Oracle11R2安装ASM+RAC配置步骤_第3页
Oracle11R2安装ASM+RAC配置步骤_第4页
Oracle11R2安装ASM+RAC配置步骤_第5页
已阅读5页,还剩37页未读 继续免费阅读

下载本文档

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

文档简介

Suse11SPl_0raclellR2安装ASM+RAC配置步骤运行环境硬件环境IBM3755AMDProcessr83802.5GHz*168G双网卡IBMX366XeonCPU3.00GHz*88G双网卡IBMFAS600阵列146.8*13双HBA卡组网方式:软件环境操作系统:Suse11SP1x86_64核:2-0.7-default数据库版本:0racleDatabaseEnterpriseEditionforLinuxx86_64集群软件版本:OracleGridforLinuxx86_64注意:ORACLE11G只能安装在SLES10以上的版本中。ORACLE集群软件的版本不能低于ORACLE数据库的版本,不推荐使用其它第三方集群软件,如VCS做ORACLE数据库的集群°11G的集群软件不能管理9i的数据库推荐安装64位数据库,这样可以使用大存(SGA),显著提高性能11g后可考虑使用ORACLEASM代替LINUXLVM管理存储,它是一个单独的数据库实例,一个操作系统只能有一个。环境检查检查硬件环境检查存:存>=1G,grepMemTotal/proc/meminfo检查swap:交换空间swap为8G(存为1~2G时,swap为起1.5倍,如果大于2G,swap等于存大小grepSwapTotal/proc/meminfo检查/tmp:/tmp>500M最好不少于1Gdf-k/tmp检查/home:/home〉500M最好不少于1Gdf-k/home检查系统空间:系统磁盘空间还有不少于6G空间,df-h安装中不使用防火墙和selinux私有网卡不可以用反线连接检查软件环境对于Suselinux要求核至少为1rpm-qpackage_name删除多余的软件包(如果不把它们删除,将严重干扰后续0RACLE的安装和配置rpm-qaora*orarunT.9-21.15rpm-qasap*sapinit-2.0.1-1.10rpm-eorarun-1.9-21.15rpm-esapinit-2.0.1-1.10rm-i/etc/oralnst.loc对于Suselinux要求至少具备以下安装包,版本不低于以下各包:binutils-.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3(32位)elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24(32位)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5(32位)glibc-headers-2.5libaio-0.3.106libaio-0.3.106(32位)libaio-devel-0.3.106libaio-devel-0.3.106(32位)libgcc-4.1.2libgcc-4.1.2(32位)libstdc++-4.1.2libstdc++-4.1.2(32位)libstdc++-devel4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-2.2.11(32位)unixODBC-devel-2.2.11unixODBC-devel-2.2.11(32位)以下三个包需要从官网下载,是必须安装的oracleasm-0-0.21-bigsmp-2.0.4-1.SLE10.i586.rpmoracleasm-support-2.1.3-1.SLE10.i386.rpmoracleasmlib-2.0.4-1.SLE10.i386.rpm安装前准备工作准备安装包:oracle官网上有下载linux.x64_11gR2_grid.ziplinux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip磁盘规划磁盘的划分后,两节点都能看到,能正确读写。在其中一节点上运行fdisk划分以下分区/dev/sdb1200G存放数据/dev/sdb2200G存放数据/dev/sddl1G存放CRS/dev/sdd21G存放CRS/dev/sdd31G存放CRS/dev/sdd550G存放recover/dev/sdd650G存放flash然后在另一节点上执行partprobe

检测分区是否创建成功:在两节点上都要检查ls/dev/sdh*/dev/sdh/dev/sdh1/dev/sdh2/dev/sdh3使用dd命令检测新分区是否能够读写ddif二/dev/zeroof二/dev/sdblbs=1Mcount=10配置网络本次分配如下:cat/etc/hosts435844两节点ethO和ethO(ethl和ethl)要一一对应在同一网段下,一个主机名对一个IP,私网IP与公网IP本次分配如下:cat/etc/hosts435844两节点)loopbacklocalhost#loopback(lo0)name/addresss-zh-ora01#ETH0掩码28网关54s-zh-ora01-vip#掩码28网关54s-zh-ora01-priv#ETH1掩码92网关26s-zh-ora02#ETH0s-zh-ora02-vip2s-zh-ora02-priv#ETH1,用于心跳rac-scan#用于clurswerescan分配静态IPvi/etc/sysconfig/network/ifcfg-ethXBOOTPROTO='static'BROADCAST=''ETHTOOL_OPTIONS=''IPADDR='43/25'MTU=''NAME='NetXtremeIIBCM5708GigabitEthernet'NETWORK=''REMOTE_IPADDR=''STARTMODE='auto'USERCONTROL='no'PREFIXLEN='24'注意重启网络后要在两边都验证一下,此时vip是ping不通的pings-zh-ora01pings-zh-ora01-privpings-zh-ora02pings-zh-ora02-priv配置时间同步服务安装0raclellR2的RAC,只要关闭ntp服务即可。chkconfigntpoffservicentpstopmv/etc/ntp.conf/etc/ntp.ora0raclellR2前的版本配置NTP服务参考如下:服务器端配置vi/etc/ntp.confserver6再重启NTP服务servicentprestartchkconfigntpdon客户端配置crontab-e*/15****/usr/sbin/ntpdate-s6&&/sbin/hwclock-w及chkconfigntpoffservicentpstop3.5配置SSH互信访问安装0racle11R2的RAC不需要配置SSH互信,但是要开启SSH服务,如果没有SSH,可选RSH/RLOGIN。servicesshdstartchkconfig-level345sshdonOracle11R2前的版本可参考如下:在两节点上都进行如下操作su-oraclessh-keygen-trsa在~/.ssh/目录生成了文件id_rsa.pubssh-keygen-tdsa在~/.ssh/生成了文件id_dsa.pubcatid_rsa.pub>>authorized_keys最后将两个节点该文件authorized_keys的容复制到对方的同文件里在两节点都要测试验证以下命令,要求不输入密码则通过:sshs-zh-ora01sshs-zh-ora01-privsshs-zh-ora02sshs-zh-ora02-priv修改核参数与限制3・6・1在/etc/sysctl・conf中添加,生效命令:sysc-pnet.ipv4.icmp_echo_ignore_broadcasts=1net・ipv4・conf・all・rp_filter=1fs・inotify・max_user_watches=65536net・ipv4・conf・default・promote_secondaries=1net・ipv4・conf・all・promote_secondaries=1vm・max_map_count=1000000kernel・shmall=5242880kernel・shmmax=kernel・shmmni=4096kernel・sem=12502560001008192fs・file-max=6815744net・ipv4・ip_local_port_range=900065500net・core・rmem_default=4194304net・core・rmem_max=4194304net・core・wmem_default=262144net・core・wmem_max=1048576fs・aio-max-nr=10485763.6.20RACLE用户的最大进程数和打开文件数的限制在/etc/security/limits.conf中添加:gridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile655363・6・3在/etc/pam.d/login中添加:sessionrequiredpam_limits・so3・6・4配置hangcheck-timer核模块>>echo"optionshangcheck-timerhangcheck_tick=30hangcheck_margin=180"/etc/modprobe.conf>>modprobehangcheck-timergrepHangcheck/var/log/messages|tail-2配置图形化界面方法有很多,常用有VNC,Xmanager,KVM等,在此不详叙。创建组和用户3・8・1创建用户与组groupadd-g1000oinstallgroupadd-g1001dbagroupadd-g505asmadmingroupadd-g506asmdbagroupadd-g507asmoperuseradd-m-u1100-goinstall-Gasmadmin,asmdba,asmoper-d/home/grid-s/bin/bash-c"GridInfrastructureOwner"grid最终两个结果创建的用户如下,两边的UID与GID保持一致idoracleuid=200(oracle)gid=1000(oinstall)groups=1001(dba),506(asmdba),1000(oinstall)idgriduid=300(grid)gid=1000(oinstall)groups=1001(dba),504(asmadmin),505(asmoper),506(asmdba),1000(oinstall)idnobodyuid=65534(nobody)gid=65533(nobody)groups=65534(nogroup),65533(nobody)别忘记设置grid的口令与oracle账户的口令passwdgridpasswdoracle3・8・2修改环境变量在两台服务器的的grid用户的.profile中,增加如下容:exportORACLE_BASE=/opt/oracleexportORACLE_HOME=/oracle/gridexportORACLE_SID=+ASM1#exportORACLE_SID二+ASM2另一节点exportORA_CRS_HOME=/oracle/crsexportNLS_LANG=AMERICAN_AMERICA.UTF8exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:mi:ss"exportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportORACLE_PATH=${PATH}:$ORACLE_HOME/rdbms/adminexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS10=$ORACLE_HOME/nls/dataexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexportTHREADS_FLAG=nativeexportTEMP=/tmpexportTMPDIR=/tmpexportPSI二'hostname':'$PWD'"$"umask022在两台服务器的的oracle用户的.profile中,增加如下容:exportORACLE_BASE=/oracleexportORACLE_HOME=/oracle/dbexportORACLE_SID=racdb1#exportORACLE_SID二racdb2另一节点exportORACLE_UNQNAME=racdbexportNLS_LANG=AMERICAN_AMERICA.UTF8exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:mi:ss"exportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/home/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_HOME/rdbms/adminexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS10=$ORACLE_HOME/nls/dataexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexportTHREADS_FLAG=nativeexportTEMP=/tmpexportTMPDIR=/tmpexportPS1='hostname':'$PWD'"$"umask0223.8•创建Oracle安装路径mkdir-p/oracle/gridchown-Rgrid:install/oraclemkdir/oracle/dbchownoracle:install/oracle/dbmkdir/oracle/crschownoracle:install/oracle/crschmod-R775/oracleRECOVERRECOVER3.9配置ASM磁盘以root用户身份在两个节点上配置ASMLib。一两个节点/etc/init.d/oracleasmconfigureConfiguringtheOracleASMlibrarydriver.Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrarydriver.Thefollowingquestionswilldeterminewhetherthedriverisloadedonbootandwhatpermissionsitwillhave.Thecurrentvalueswillbeshowninbrackets('[]').Hitting<ENTER>withouttypingananswerwillkeepthatcurrentvalue.Ctrl-Cwillabort.Defaultusertoownthedriverinterface[]:gridDefaultgrouptoownthedriverinterface[]:asmadminStartOracleASMlibrarydriveronboot(y/n)[n]:yScanforOracleASMdisksonboot(y/n)[y]:yWritingOracleASMlibrarydriverconfiguration:doneInitializingtheOracleASMLibdriver:doneScanningthesystemforOracleASMLibdisks:done/etc/init.d/oracleasmenable--两个节点WritingOracleASMlibrarydriverconfiguration:doneInitializingtheOracleASMLibdriver:doneScanningthesystemforOracleASMLibdisks:done创建ASM磁盘一任何一个节点上执行即可/etc/init.d/oracleasmcreatediskDATA1/dev/sdbl/etc/init.d/oracleasmcreatediskDATA2/dev/sdbl/etc/init.d/oracleasmcreatediskCRS1/dev/sdd1/etc/init.d/oracleasmcreatediskCRS2/dev/sdd2/etc/init.d/oracleasmcreatediskCRS3/dev/sdd3/etc/init.d/oracleasmcreatediskARCH/dev/sdd5/etc/init.d/oracleasmcreatediskRECOVER/dev/sdd6再检查下是否创建好一两节点/etc/init.d/oracleasmscandisks/etc/init.d/oracleasmlistdisksARCHCRS1CRS2CRS3DATA1DATA2安装OracleGridInfrastructure软件以grid用户身份解压缩OracleGridInfrastructure软件:unzip/oracle/software/linux.x64_llgR2_grid.zip验证有效性安装cvuqdiskRPM程序包,位于安装介质的rpm目录下:rpm-ivh/oracle/software/grid/rpm/cvuqdisk-1.0.7-l.rpm以grid用户执行以下命令cd/oracle/software/grid./runcluvfy.shstage-precrsinst-ns-zh-ora01,s-zh-ora02-fixup-verbose./runcluvfy.shstage-posthwos-ns-zh-ora01,s-zh-ora02-verbose将上述检查的结果全部为PASSED即可,若有FAILED状态的根据提示信息修改即可。4.2安装GRID软件./runInstaller4・2・1选择合适的安装选项选第一项刚#问WWkCrUBnfnqwedcrIUiRdrtnt跑>2MMdIGfeniyE丹i^n-iWA*洽屮齐f・严卩*时沖■■讨E"#3口円£円仲让屮FW!心ielrcl!Ifiit^llaftianQiitiriin誥篇ip、.<kUltlMMTim4.2.2选择合适的安装类型在这个界面下选择合适的安装类型,选择typical,将遇到更少的选择,并且在后续Oracle可以生成一个fixup脚本叫你执行,然后自动调整你没有按要求调整的系统参数,如果选择advanced,那么你将遇到更多的选择,并且所有环境变量要按要求事先准备,否则会报错,在这里我们选择advanced选项:

4・2・3选择产品语言在选择产品语言时加上中文simplifiedChinese,否则在使用EM时如果你的IE优先使用中文的话会出乱码的:4・2・4配置网络增强在配置网络增强界面时,规划好的集群名、SCAN名,SCAN端口,当然如果你采用的GNS则配置相的的GNS选项:4.2.5配置集群中的节点信息1、选择add,添加上第二个节点,配置集群中的节点信息,2、选择SSHconnectivity选项,输入grid用户的密码,然后点setup选项,oracle会自动配置ssh互信:yi-illUMFrCQrF4-rilteHFilfMSgdrPjih4・2・6指定网络接口用途b:*iwMl-lrtC*i=1,-^rU-hixjPktfWr*L-rWw-rW1mkMnr*lrU»v申砂冲IM■flrN«r豊谊i)w<iivl«rw«hhgK«iiw〕iw・n■「吋Dchwu刊科ePtwm£b甘恤teaVI-e自币ifTMir1!1(rlir-rMlsdfrp伽■hCMlHTfeilr^1:'mTtI■剂rfirfiWi即Ml£Hmc13■r*wihrvCtm|:如申1*rh—Et(讯啊孔ill护i;tiiu-^H-iM■匸;口】®^*gkFFMiVrin-rj-宀⑴宓中齐宕計w«h**P1刘"日’4・2・7选择ASM存储1TTT4・2・8创建ASM磁盘组用于放置OCR、VOTE文件:4・24・2・磔冊sys苕asmsnmp湖F罢ml巔4.2.10指定特权操作系统组4.2.11指定oraclebase和softwareinstall目录$ORACLE_BASE与$0RACLE_H0ME目录不要存在上下级关系,否则在安装时会报错。[INS-32026]ThesoftwareLocationspecifiedshouldnotbeunderOraclebaselocationEcffwvtMdkn:如M皆iFyIn4ijIEcffwvtMdkn:如M皆iFyIn4ijIiNn岀]■LetJriisiM如州・'kN灿詁卅P劇SAW-ti«w4J4伽EgWU*Z心曲*M=B陽IhiOh!kHur血用钟一Tme4uh兀d-rieIary1=UMOUIt^Whft'LflFLSi.mhn-iLirv町n护OfiIt!曲riuiiEUBbMfiirrun:^仁mriniKiwmWig厲EgSirifEnggnasri^tjr佃申;witJpd^ffr七辽血MEWhWaSfMkKAfl応申屮#&UHllhlIWBiM19■heOrklcBurSir-HW|r'>?-■■»B*rCvmli!费4!«I■也园K烏髯》曰*吨卉日召怦u:ir和本上上-initKir^4tvilicr>illP:mnzufhdtiyvirznnjrdduibiriam-fpirilFlwIhvOnrlcbt-sOF?AO_C卅卫p”"*|[I>4.2.12创建一个inventory4.2.13查看上述选择总结点击FINISH,开始安装Infr^MnKliirr-Siting4.2.12创建一个inventory4.2.13查看上述选择总结点击FINISH,开始安装Infr^MnKliirr-Sitingi|卩Grillirfr^TiKfLinf-14ofCRAO-M-jy&■iLlfelfiEIkuiiKi■■■tRiMSiaisRda硏■沁ifyjiiU?I-CrhhmioW|>-r^fealH1^4KJiSkjq^i+^rfVtaWH.KPI:■**?*■.W.WWtM.>»HJHfflEj:,4.2.14*执行脚本在两台器上分别按提示的顺序执行oralnstRoot.sh和root.sh,完成后点OK:

FTOrKtAridlinfrsErruchine=SetliingupCridInira^ructuire--^ep1l5of16-FTOrKtAridlinfrsErruchine=SetliingupCridInira^ructuire--^ep1l5of16-、H47?i^vr;>i:il<Mi通常在这里容易出现问题,本次安装出现的问题是:s-zh-ora01:/oracle/grid#•/ro0t.sh省略)/oracle/grid/bin/clscfg.bin:errorwhileloadingsharedlibraries:libcap.so.1:cannotopensharedobjectfile:NosuchfileordirectoryFailedtocreatekeysintheOLR,rc=127,32512解决方法:从系统光盘上安装libcap软件包即可。在很多RAC安装指导文档中都会说要将安装系统时要将所有的开发包都要装。再次运行root.sh时,会提示你已经配置过一次了,要删掉之前的配置执行$0RACLE_H0ME/install/roothas.pl-deconfig-forceINFO:PRVF-4657:Nameresolutionsetupcheckfor"rac-scan"(IPaddress:00)failedINFO:PRVF-4657:Nameresolutionsetupcheckfor"rac-scan"(IPaddress:00)failed4.2.15执行配置助手在执行这里时,OracleNetConfigurationAssistant与OracleClusterVerificationUtility这两个通不过,都选择了skip。测试下,以grid用户执行netea配置监听,如果没有问题可以跳过OracleNetConfigurationAssistant,或者后面手工来解决这个问题都可以的。执行netca配置默认监听listener时报错INO:oraclenetconfigurationassistantislaunchedfromdatabasehomerelaunchoraclenetconfigurationassistantfromgridinfrastructurehome原因:设置了ORA_CRS_HOME变量,该变量是由orarun软件自动设置的,所以建议前期要删除该软件包。解决方法:unsetORA_CRS_HOME[INS-20802]OracleClusterVerificationUtilityfailedINFO:PRVG-1101:SCANname"rac-scan"failedtoresolveINFO:ERROR:

Forcause1:OraclestronglyrecommendtouseDNSorGNSforSCANnameresolutionashostsfilesupportonlyoneIPforSCANname.IfyouintendedtousehostsfileforSCANnameresolution,andpingcommandreturnscorrectSCANVIP,youcanignoretheerrorandmoveforward.IfyouintendtouseDNSorGNSforSCANnameresolution,pleasecommentoutentriesinhostsfileforSCANname,andre-run“$GRID_HOME/bin/cluvfycompscan”toconfirm.测试:pings-zh-oraOl-vip通过pings-zh-ora02-vip通过5安装RAC软件以oracle用户身份解压缩OracleDatabase软件:unzip/oracle/software/linux.x64_llgR2_database_lof2.zipunzip/oracle/software/linux.x64_11gR2_database_2of2.zip解压的文件放在同一目录下5.1.1开始安装./runInstall去掉勾,点击NEXT会有提示信息,选择YES即可CWKc!屈CWKc!屈1収》1・匚wili^ure-Llpd工■■4DRACLjE'呷卫CBuri^j■LiemHhUpdui5.1.2选择安装项选择只安装数据库软件:CT^ACLe1q-j耳□*TAn*itrJOptinnk+tnmeOhcwkiwiiiiimjs如]•A鼻七如峠**1曲妙铝*ISW^tIjflWIFECWclI■网¥咖MM建I妙■«trtifH料灯■平fl选择realapplicationclusterdatabaseinstalllation,然后选中所有的节点selectall:5.1.5选择5.1.5选择oraclebase和软件安装目录:这里的ORACLE_BASE与ORACLE_HOME是上下级关系。否则会提示:[INS-32026]ThesoftwareLocationspecifiedshouldnotbeunderOraclebaselocation5.1.3添加中文语言:5・1・4选择企业版:x■込;4:號貰口:口運韦「眄[恋I雋上:ETT⑴血:二页于iElerli■戸L-ill-tian11SfXTZdII■■■MK£XiElerli■戸L-ill-tian11SfXTZdIII|nrtq>nie卩d^QKlMULivOUUUbElfiElV土!呻letlMIMig汁卅听山明衣0・i^blvIFivIMdlHciidil!-uv,pvrforii3krK.«_N4inilLbl^Y.・w]!「■ifurarriq-.ifsid旳ltutiIfw■on!OmiMnil.n1丽¥巧E別WWW?piBrrdvdE^HScnft-TJCf]-QrKMlip也kliN卩』刊事乂屈中R-■彳期求眄如叭4lai^«orH2edMiMrEeskwkj#rOixleft«unmi:|[LiH4!CmjeibhrorErricr;<w1c■冊MIki«1iMMf跑£cmil£W>K1・甘1*1fillcwh4A1H口nrariinl^ICMd^ihMwgiiHFrvCgigII:[SltPF」CitycEi耳由fbfo-rnprlrrj^ruIf』」■:UweIstfiir石natIIh4r*clfh-^a-rJ«nic«--»tyMaMhtiKM.dHnCvkU站駅斗匕l沁ifMri*DhllUd闿b£r>UISb怪L血母■却册-出屮T^Cl-MMUhrtSM1OviKkflweeiiMV£«Wvw>«LAcrI伽槽JS^jidnfilylE*l:dll^iadjiiLm占i•内删紆戸啊gimw■■5.1•选择特权操作系统组:5.1•开始安装clusterwaredb软件:这时可能报下面类似的错,原因没有把DB的两个包解到同一个目录下的原因,遇到这种情况,你就退出重新正确解包再安装好了:5.1•按提示运行root.sh,完成后点OK!:営心暮卜。be^iccuiid:»岂翅理HJR4dii>j|'--営心暮卜。be^iccuiid:»岂翅理HJR4dii>j|'--OracleD^iLri^r11r^Ri-|CdXc2lii^Lil^rF”如IMr七1』饶bz*s\cuto?ri>ImatiaJIKrriMiwECTSACLe'M卑Afi-ASt」fTWliIbvr-4dhF:>.«rtawEr#a<Y完成安装,点close安装ASM磁盘组在建库前需要先创建数据文件的ASM磁盘组,以grid用户登录,执行asmca命令:$asmca弹出如下界面,按规划要求创建好相应的磁盘组:«su>orWindcmv■心」tlrTncLhB«su>orWindcmv■心」tlrTncLhB■旷呵凸丰F皆塀■弹G^Flrr眄討庐力■即Itt甲叶艸・押F・■声PiH"叫g"11W殍生*5^s誓H讯怦*■rf'JH5|尸討TflT^MriVHwmfKMHOTiAWLhflVCilLn(^l■WritflKLC«1IK^WAEU归!卜=i;n^j7i:TjlD^nDirv«rQuuv'Mll阳l&nisMtiiJiGtcbjpNancXJiir*打理担*UljkGra-upCraiinflTtiiJiGtcbjpNancXJiir*打理担*UljkGra-upCraiinflTCramsKJDA1A/de^rtHttricL二■-!一J一上曰即詞cr^-j|nufrfriEdd^f+c3Xdhrdtfa.4-nd^Fsmrvl『■■Kr・-jr-Mif!!HdrnaJrEaSundwH^--tvi<^1-sl:kira^alKi:^tm^i話誣rrnifidin•阿i^up|.„■rr£N『iHdundB^KV和=nnlfa=ridifJufi-prWpEH»e*Hwwif住t-ttpuyDlLKCriXjpHhcDlLKCriXjpHhc&C_C<T*”电.you由,**6ihvd=h3«r_ii:h纽右昂.MifBWkEiiJMf.rM-zn.Erl>Eh:c«r|rfPv~hj>3PFJri^wr-i*pfmai;■:K-nco-nih-rdeleTV<hrhgkL«.rfg«i*歸L*cdg古乂**仟EHElXMMer血“fflw/eM-U■Ewk站Vv<4血MdBuW^nM-OMr^nIFic«^rs!^rp^Tflxrtidbi^nup-<£-&■■pWMr*-^icn.iWinct^B16beBCrATsKLE-Bi-r-J-B-nifu~ui七acT3=切畑些4&rven哼ru.dddah■:-arJU4MChidirtri**tI<whCreateD^kCro-iipQWUt«B-tJD4Ul!£叶fe*Q如*筍时DiskCroup:Crealin如昭Vs«d44<UJI-出IL宦&KjSwrQWUt«B-tJD4Ul!£叶fe*Q如*筍时DiskCroup:Crealin如昭Vs«d44<UJI-出IL宦&KjSwrdu4-Eeddl,iJVYpppllpPECmkFur&o昶t^hduld1加狗门册映心*:订/dr-i'^wk^lJH^Up«iHl^Fif■tfxiUicf4MILMI*E眄*1A轴R(d-uwiu>n"RcAirKfMKY■a■■cterriidK叮cmgH^jf>kcactusflflfwdriBavid-fT-mpsmrtFirkxE'gr«vi?i,HemtlrcChndiirKirrrmfa4ahImiirilr.L弓d/z"-Fnirri^lAri^trcufiF.ur>dind-Ln-dM^Y「remul«i=id^!fnnldiAurq■pn/AippChv?|E&dhhdhCKken^w£t>g~上如IMiEEH应cBQ41MniX1X41:1*0(1册敝UM也非口畑《Onp«H^HlUWrimx410Eknadfi-NIfrrif-iH-finIfiiwiqiffdjnhfB-nug-lGrMinnlYirmniEdCdiiitai;■■-«-AW£2討・rFitrf「itr■吕本次打算新增DATA组与LOG组,但是在图形界面配置时出错,建好了磁盘组,但是在ASM实例中并没有MOUNT,报错信息如下PRCR-1065:Failedtostopresourceora.asmCRS-2673:Attempingtostop‘ora.asm'on‘s-zh-ora02'ORA-15097:cannotSHUTDOWNASMinstancewithconnectedclientCRS-2675:Stopof‘ora.asm'on‘s-zh-ora02'failed这个问题,仍未解决,只好手工创建ASM组了su-gridexportORACLE_SID=+ASM1sqlplus/assysasmSQL>creatediskgroupDATAexternalredundancydisk'/dev/sdb1','/dev/sdb2';SQL>alterdiskgroupDATAmount;关于ASM管理在网上有许多文档,不再详述。在另一节点测试下,查看是否所有的ASM组都挂载上了SQL>selectname,statefromv$asm_diskgroup;

安装DB库以oracle用户执行dbca,弹出图形界面来安装DB库。$dbca弘叙IIMIhU曲Z聊Dal^bas^Co-nfi£iuralia-nAMiElarhLSlepJ^cfOperaljan-RkJtS*IMf护rifg弘叙IIMIhU曲Z聊Dal^bas^Co-nfi£iuralia-nAMiElarhLSlepJ^cfOperaljan-RkJtS*IMf护rifg&0軸#3目mjH比pfrFwmHFus-r^inEMK乍**!*PC^4urM>0niA$-p-EiiuvQtjuitQi^iti,/iBAHruciufthsfti・I>aeaIwmC^nfigliraiinnAssisranLSlep2of14:DalabaseTem竄*EhtfC4ni*«1甲IMv・>4・~g詢H氓护圭島n#w01910144MHWhJttt.1-EOj^MGiMMJJiH0uf早l|$.impi■鲜Mlhc^lor^h4wi^eci-E^aiv.suchpwhenrw«d[口cHmhmiffir>burH-laUocksut..wtwfhc«n»oibeaHercdafftrdvilxjec^cahoh『mpIMr■■urn凹!mDJdanfimkrM-TrtCVKTl_钟ra.itonvlFK?ra.itonvlFK?£■g盹昨丝扣啪T打血A3vMihoaM甫・皿丿时灼WIWHKwihm^imiTi*®*a2的>・1(叭。駅加的rH?efwrwfsfc«rrt^<Mjfi:A4nfiairwB■打呻也d^iiiDWct-iAJkt<1feKijnct-s•w^d耶3P«!fkiWWl.厂ZiHetd却Or軾¥3勒M4I!:QwIOoC4lOV£lU4N*nJ.WKlfrOiIherOm"flWMoi^rm*'O>3bJiJ£>Maba.-iftHum-[kihoq山§|I4J时烧悼r^trfrai^&W•>心电幔hnil^tV•馭H牧d■越比n^豊昶叫*grWitila&*u-iK11Qrunwlh»WfliHr$MKlrij|miw<l5»Frtfrifimac~治nt叶no<hwE«-***chyau«□•!«giE*WsbiGfTheR<・rw4eTrac3.Fwa加辭EMMw***flW0坤5intti«@Bittl利De士卜却C«KF!,H«R>这一步选择selectall后会检查默认监听LISTENER及LISTENER_SCAN是否启动,没有启动则无法继续。期间还出现一个问题,[INS-08109]UnexpectederroroccurredwhilevalidatinginputsatstatenodeSelectionPage'.解决办法:unsetORA_CRS_HOMEJAiKislanl.广iniDtfTenmMmwwfiflMPMcwurtH*Uuirwivrx配fm畑rwryswg仙mim<oum«--Jj.j.nrr^JAiKislanl.广iniDtfTenmMmwwfiflMPMcwurtH*Uuirwivrx配fm畑rwryswg仙mim<oum«--Jj.j.nrr^匸*flfimnF-juMrn>*4"坏**vri■切41曲姑巌讯阱£如*ST疊如IM机|n■瞇吨《0JEIWH4SttatciDuk.Crouph*miFr«n[MB0£n>jndVK^>宜l»M.DJkT^3C+W75&11FTilJHMMV«d1L_NWIff-UIN4UH-«^IMMIHIDtsktraipi!riatnlMsc-OnhgliralknA-^sis-tanI,Slep4of12:Mamn^crnienlOplionsOrjckiDh血》£.Ll$priowdflsihi-ibw^ioamc^whmaria(Mmkrc-tfiirKfcsucih-uwniFwwf-HBfiFlks>CEAeril4ftawdpraKimkMootrawfis-,TMsrruksarew(齐nE*阳rfitH*rMC徒wfeg-gIT电*UUM辄BOS耳*打和H熄屮+■iiwmTremMHftrih#n«iniwmMui>tr*Hk.Tn*aHuBfiJeiHttWKAut‘严CH>PM-2:QGAM4fiwet^jdlaM5.lid1MwuRffWk<KTM^iedifMJtfcanb>tcwr^#p«n”EnStronwhipcr*-vr^lamc詡rm^-ri^nv.re1枣*如C«K«iH««p输入创建ASM组时所设置的密码鸣刊阿$pipi|A■辟国1鼻门|.54岂卩£ofl/vDjifNhiKe站机rfv*1虹如gXI4£«IM-险孕”臣曲応Mil*TypKKE1^HFB-E1^HFB-UfwocKidIHF-B^n-Mrs.chu-Krtrf.CE5U--HiHibuqChru.r<r5tifHwd«WTr>f"wryKrwwEpriimirutflpaiMstm■科z5ihiim冲f的帕w呻SutramwtatiFWffU益孔F昭Lrmocm-chwctFfK能叶aai興轟yr胡)辄耐q血u律闸*网Iia口曲(HWG•Cbmafromitrt佃wTKhnnc^sfisDtfirfMJEONndcfSet^AtJ(IffB■=iLMiMkiITtfUMmlfifedneUirsitPQW«界匕WVWMUl."XEEHJMCHMVNhiwnICtiaFWIerSwDef-uATfrncwv:InjfiaH^aHDnP-3r^metersE«JnSliir*d5rrwFirifrcners-..-C4fKriIHH0:InjfiaH^aHDnP-3r^metersE«JnSliir*d5rrwFirifrcners-..-C4fKriIHH0Cfiinfigui'iil:ionA-ssistanr,ElopJofNtrawySrtmihtrraxit-inwtwhymjwirryawdamsMtiocptfK*耳IMieu«{1-EhMrUtdeFweachcAtfiiccmechonIbcdy-ibasFXiAmv^e•h-mjwt<k«k/edIoserMngZ4MMIH4Wi>n4H*占IMHI出H£占£*4*14』H孔卿44io&t-muofrTitncbtet-Gg叶rruijn^ptrbritn.UHgMiMYwq曲卫片俯mrh*niviatad*疔ShunHatwIIW仕呻•(mu*舸昭i呦叶电tdni-ui4ke-tM#^刚忒f轉w#U£ihft«^werf*fiIivotAu»B4r制卅骑WO忡t如Hl曙I曲畠・113軀*hftdH列冲EMM!MhimiIvssffiimre畑収hTh4OnbdBshiredwiwkwuttMZeh^blBd7hamlJifvt怡毎整耐Ihepm&w酣wrarpreenksihr剧wm初s・■Kuw*呵斗PM"vf>.SharedS-frf^br「1111of~i1:Croat^nOptt^nsCarteliHelpo喀pek|审土晡:(EtnahCreate-Database-SummaryEfta-txbajeC^rariQurailanSuinmjryMMA4*rh十hliHT\珅Daj-idMJRCwilroJi^crwHar-a^firwYipm)SXVWfWWZM鬧跡彌aaigLhaicC^nFI(jurai:lonDcl^llifCcnnipone-rTtsccnfigdrnrionA-ss-iNfliii,sttp1111■,<'.ntAFi^Ronii^iiKblinMgsrHi!^!SAcISbtdtplibiMKra-i^kn«pho»s-r.5M-削ccnfigdrnrionA-ss-iNfliii,sttp1111■,<'.ntAFi^Ronii^iiKblinMgsrHi!^!SAcISbtdtplibiMKra-i^kn«pho»s-r.5M-削idmou*TtirOXBE>蜩hHM«£re--iii«ih>prc^ruj-■Lpgir«i5forih»cirrarwDptfmmar«I«iMM■/uDijimfDncHc/HivMiDg^/ciM叭颂血hCvr-HUng4rid94«ri;lngCHHitl*bl:aM.fStW耳曲IMikt刚例屮0H4ME^WV*rf血kWK]OmJVM地dEflmeHuOne*SMLDB却"9EAtWOU*完全安装后验证检查8・1・1检查CRS运行状态s-zh-ora01->crs_stat-tNameTypeTargetStateHostora.racdb.dbapplicationONLINEONLINEs-zh-ora01orab1.instapplicationONLINEONLINEs-zh-ora01orab2.instapplicationONLINEONLINEs-zh-ora02oraSM1.asmapplicationONLINEONLINEs-zh-ora01oraC1.lsnrapplicationONLINEONLINEs-zh-ora01ora.gsdapplicationONLINEONLINEs-zh-ora01ora.onsapplicationONLINEONLINEs-zh-ora01ora.vipapplicationONLINEONLINEs-zh-ora01oraSM2.asmapplicationONLINEONLINE

温馨提示

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

评论

0/150

提交评论