oracle-11g rrac vmware workstation1.32虛擬機(jī)配置文件

Oracle11GR2RAConVMwareworkstation一 軟件準(zhǔn) 二 硬件環(huán) Windows硬件環(huán) VMwareWorkstation8.0上虛擬機(jī)配 配置共享創(chuàng)建共享磁 編輯虛擬機(jī)配置文 關(guān)閉VMwareWorkstation軟件重新打 三 網(wǎng)絡(luò)配 Windows下VMware虛擬網(wǎng)卡配 hosts文件配 DNS配置(過程略 四 檢查并安裝所需rpm 11gr2聯(lián)機(jī)文檔相關(guān)部 yum批量安 五 安裝工 修改主機(jī)名稱，在所有節(jié)點(diǎn)執(zhí) 配置用戶,組 和權(quán) 修改系統(tǒng)內(nèi)核參 配置 配置 六 配置用戶環(huán)境變 配置節(jié)點(diǎn) grid用 oracle用 配置節(jié)點(diǎn) grid用 oracle用 七 配置用戶等效性(可選項(xiàng) grid用戶等效 oracle用戶等效 節(jié)點(diǎn) 節(jié)點(diǎn) 啟動服務(wù)(雙節(jié)點(diǎn)執(zhí)行 系統(tǒng)啟動自動加載（雙節(jié)點(diǎn)執(zhí)行 九.安裝并配置ASM驅(qū) 檢查內(nèi) 安裝oracleasm包(雙節(jié)點(diǎn)執(zhí)行 初始化asmlib(在所有節(jié)點(diǎn)執(zhí)行 磁盤分區(qū)(節(jié)點(diǎn)1執(zhí)行 創(chuàng)建asm磁盤,在節(jié)點(diǎn)1執(zhí) 節(jié)點(diǎn)2掃描識別ASM磁 十.安裝cvuqdisk軟件 十一.安裝前檢 十二.安裝Grid 安裝 確認(rèn)集群軟件安裝成 十三.創(chuàng)建ASM磁盤 十四.安裝oracle11gr2database軟 十五.創(chuàng)建數(shù)據(jù) 十六.集群管 RAC的啟動與關(guān) RAC檢查運(yùn)行狀 Database檢查例狀 檢查節(jié)點(diǎn)應(yīng)用狀態(tài)及配 查看數(shù)據(jù)庫配 檢查ASM狀態(tài)及配 檢查TNS的狀態(tài)及配 檢查SCAN的狀態(tài)及配 檢查VIP的狀態(tài)及配 rhel-server-5.4-x86_64-Windows電腦型號N55SF筆記本電操作系統(tǒng)Windows764SP1DirectX11處理器英特爾Corei5-2430M@2.40GHz雙核主板華碩N55SF(英特爾HM65組)8GB(DDR31333MHz/DDR31600MHz主硬盤希捷 AS(500GB/7200轉(zhuǎn)/分顯卡NvidiaGeForceGT555M2GB/顯示器三星SEC314B15.3英寸光驅(qū)建興DVDADS8A5SHDVD聲卡瑞昱ALC663@英特6SeriesChipset高保真音頻網(wǎng)卡鈺碩AR8151V2.0GigabitEthernetController/華碩VMwareWorkstation8.0Rhela—Rhelb—注意:rac1rac2選擇相同配置,swapMemory21.31.3cmd中進(jìn)入WMwareWorkstation8.0關(guān)閉兩臺虛擬用記事本打開虛擬機(jī)名字.wmx例如添加以下內(nèi)容#shareddisksconfiguredisk.locking="FALSE"diskLib.dacheMaxSize=diskLib.dacheMinReadAheadSize="0"diskLib.maxUnsyncedWrites="0"scsi1.present="TRUE"scsi1.virtualDev="lsilogic"scsi1:0.present=scsi1:0.mode="independent-persistent"scsi1:0.deviceType="disk"scsi1:1.present=scsi1:1.mode="independent-persistent"scsi1:1.fileName="E:\share\data.vmdk"scsi1:1.deviceType="disk"scsi1:2.present=scsi1:2.fileName="E:\share\fra.vmdk"scsi1:2.deviceType="disk"此時看到共享磁盤正確加載則配置正WindowsVMwarehosts設(shè)IP地子備Public 設(shè)IP地子備Public [root@rac1~]#host- name[root@rac1~]#host- name.has[root@rac2[root@rac2named]#host- name.has[root@rac2named]#hostrac-出現(xiàn)has[root@rac2named]#hostrac-11gr2ThefollowingorlaterversionofpackagesforAsianux3,OracleLinux5,andRedHatEnterpriseLinux5mustbeinstalled:compat-libstdc++-33-3.2.3(32bit)viviglibc-2.5-24(32glibc-devel-2.5(32bit)libaio-0.3.106(32bit)libaio-devel-0.3.106(32bit)libgcc-4.1.2(32bit)libstdc++-4.1.2(32bit)sysstat-OnAsianuxServer3,OracleLinux5,andRedHatEnterpriseLinuxunixODBC-2.2.11(32-bit)orunixODBC-devel-2.2.11(64-bit)orunixODBC-2.2.11(64-bit)oryum一個一個地安裝太麻煩了,采用yum批量安裝,一鍵搞[root@rac1~]#mount/dev/cdromyumcat>>/etc/yum.repos.d/rhel-source.repo<<C.C.#startinstallrequiredyum-yinstall yum-yinstall yum-y compat-libstdc++-yum-y binutils-echo"startinstallingrequiredyumyum-y glibc-devel-yumyum-y elfutils-libelf-yum-y elfutils-libelf-devel-yumyum-y glibc-devel-mon-yum-yyum-yinstall yum-y yum-y yum-y yumyum-y glibc-headers-yumyum-y yumyum-y libaio-yumyum-y libaio-yumyum-yinstalllibaio-devel-yumyum-yinstalllibaio-devel-yumyum-yinstalllibgcc-yumyum-y libstdc++-yum-y libgcc-yumyum-y libstdc++-yumyum-y libstdc++-yumyum-y yumyum-y sysstat-yumyum-y unixODBC-運(yùn)行sh以下配置均在所有節(jié)點(diǎn)執(zhí)[root@rac1~]#vi useradduseradd-goinstall-Gdba,asmdba,asmadmin,asmoperuseradduseradd-goinstall-Gdba,oper,asmdbaechoecho-noracle|passwd--stdinecho-noracle|passwd--stdinmkdirmkdir-pmkdirmkdir-pmkdirmkdir-pchownchowngrid:oinstallchownchowngrid:oinstallchownchown-Roracle:oinstallod-R775/u01/chown-Rgrid:oinstall/u01#提#提交內(nèi)核參配置配置六.配置用戶環(huán)境變A.grid用戶;;;;;B.oracleexportexportexportexport;exportexportexportexportexportexportexportexportexportexportexportexportexportexportexportexportexportgrid;;;;;;;;oracle;;exportexport七.配置用戶等效性(可選項(xiàng)Oracle11gr2ssh也可以在安裝過程中配置grid以下均以grid用戶執(zhí)ssh-keygen-trsassh-keygen-tssh-keygen-trsassh-keygen-t$sshrac1$sshrac2oracle配置類似grid用戶不在贅述了八.NTPfsfs#servicentpd系統(tǒng)啟動自動加載（雙節(jié)點(diǎn)執(zhí)行#chkconfigntpd九.安裝并配置ASM[root@rac1[root@rac1~]# 2.6.18-2.6.18-OracleASMlib地址 /technetwork/server-以下rpm包(注意rpm包版本和Linux內(nèi)核版本一致[root@rac1~]#cd[root@rac1~]#cdIDID2:oracleasm-2.6.18-164.el###########################################[ ###########################################[1:oracleasm- [root@rac1oracleasm]#rpm-ivh-rw-r--r--1root -rw-r--r--1root totaloracleasm-support-2.1.7-asmlib(在所有節(jié)點(diǎn)執(zhí)行ConfiguringtheOracleASMlibraryThisThiswillconfiguretheon-bootpropertiesoftheOracleASManswerwillkeepthatcurrent Ctrl-CwillDefaultusertoownthedriverinterface[]:WritingOracleASMlibrarydriverconfiguration:[root@rac1~]#fdiskcontentwon'tbe11Callingioctl()tore-readpartitiontable.Syncingdisks./dev/sdc,/dev/sdd執(zhí)行相同操asm磁盤,1[root@rac1~]#oracleasmcreatediskOCR_VOTE/dev/sdb1Writingdiskheader:doneInstantiatingdisk:[root@rac1~]#oracleasmcreatediskDATA/dev/sdc1Writingdiskheader:doneInstantiatingdisk:[root@rac1~]#oracleasmcreatediskFRA/dev/sdd1Writingdiskheader:doneReloadingdiskpartitions:doneCleaninganystaleASMdisks...ScanningsystemforASMdisks...Reloadingdiskpartitions:doneCleaninganystaleASMdisks...ScanningsystemforASMdisks...Instantiatingdisk"OCR_VOTE"Instantiatingdisk"DATA"Instantiatingdisk"FRA"十.安裝cvuqdiskcvuqdisk軟件包用于發(fā)現(xiàn)共享，在grid安裝軟件的 中，在所有節(jié)點(diǎn)執(zhí)行[root@rac1grid]#cd[root@rac1grid]# [root@rac1rpm]#lltotal-rw-rw-r--1gridoinstall8173Jul15 [root@rac1rpm]#exportCVUQDISK_GRP=oinstall[root@rac1rpm]#rpm-ivhcvuqdisk-1.0.7- 十一.安裝[grid@rac1grid]$[grid@rac1grid]$./runcluvfy.shstage-posthwos-nrac1,rac2-verbosePerformingpost-checksforhardwareandoperatingsystemsetupCheck:Check:NodereachabilityfromnodeDestinationResult:NodereachabilitycheckpassedfromnodeCheck:Check:UserequivalenceforuserResult:UserequivalencecheckpassedforuserNodeNode InterfaceInterfaceinformationfornodeHWIPDef. InterfaceInterfaceinformationfornodeHWIPDef. Check:Check:Nodeconnectivityofsubnet Check:Nodeconnectivityofsubnet InterfacesInterfacesfoundon rac2rac2rac2rac2CouldCouldnotfindasuitablesetofinterfacesfortheprivateInterfacesfoundonResult:NodeInterfacesfoundonCheckingformultipleuserswithUIDvalueResult:CheckformultipleuserswithUIDvalue0十二.Grid安裝軟件要圖形支持,我用XmanagerEnterprise用 登陸節(jié)點(diǎn)1,以grid用戶安裝軟件選擇高級安添加簡體中創(chuàng)建磁盤配置ASMSystem口令(此處用oracle會報不符合推薦標(biāo)準(zhǔn)的錯誤不適用智能平臺管理接選finshed進(jìn)度到進(jìn)度到100%界root用戶按順序3.[root@rac1~]#/u01/app/11.2.0/grid/root.sh4.[root@rac2~]#/u01/app/11.2.0/grid/root.sh運(yùn)行完后,點(diǎn)擊ok完成安裝.如果不能rac-scan,那么會報點(diǎn)擊關(guān)閉完成安裝十三.創(chuàng)建ASM磁盤本次3asm磁盤組，分別為：DATA,FRA。其中DATA將存放數(shù)據(jù)庫文件；FRA存放閃回文件.grid用戶下，執(zhí)行asmcaasm磁盤組創(chuàng)建向create按鈕，在彈出的創(chuàng)建界面中填寫磁盤組名稱，選擇external(none)，并勾選成員，選擇完畢后點(diǎn)擊ok；創(chuàng)建FRA磁盤組和DATA操作相以oracle用戶登錄到節(jié)點(diǎn)一，切換到軟件安 ，執(zhí)行安[oracle@rac1database]$在彈出的安裝界面中，點(diǎn)擊選擇“installsoftwareonly”，點(diǎn)擊將簡體中文添加到安裝選使用默認(rèn) ，點(diǎn)擊進(jìn)入安裝過程自動進(jìn)行安檢查通過后，點(diǎn)擊root用戶，在兩個節(jié)點(diǎn)上執(zhí)行執(zhí)行完畢后，點(diǎn)擊ok，返回如oracle數(shù)據(jù)庫軟件成功安裝完成.點(diǎn)擊close關(guān)閉十五.創(chuàng)建1上用oracle用戶執(zhí)dbca命令,rac數(shù)據(jù)庫選擇一般用途或事務(wù)處理，點(diǎn)擊填寫數(shù)據(jù)庫名稱(使用環(huán)境變量中ORACLE_UNQNAME)，選擇兩個節(jié)點(diǎn)，點(diǎn)擊默認(rèn)，點(diǎn)為所有用戶設(shè)置統(tǒng) 方式，并選擇相應(yīng)的磁盤組，點(diǎn)擊彈出ASM用戶窗口，輸入在安裝grid時設(shè)置的選擇閃回磁盤組，取消勾選歸檔選擇SampleSchemas(用于學(xué)習(xí)選擇自動內(nèi)存管理,內(nèi)存段點(diǎn)擊字符集選項(xiàng)ZHS16GBK類顯示概覽，默認(rèn)不變，點(diǎn)擊出現(xiàn)安裝概點(diǎn)擊ok，開始安裝過等待漫長一段時間，安裝結(jié)束，彈出如下界數(shù)據(jù)庫創(chuàng)建完十六.RACoraclerac默認(rèn)會開機(jī)自啟動，如需時可使用以下命令：crsctlstopcluster crsctlstopcluster–all crsctlstartcluster crsctlstopcluster–all 注：以上命令需以root用戶執(zhí)行RACgrid用戶運(yùn)[grid@rac1~]$crsctlcheckCRS-4529:ClusterSynchronizationServicesisonlineCRS-4533:EventManagerisonlineDatabase[oracle@rac1~]$srvctlstatusdatabase-dprodInstancerac1isrunningonnoderac1Instancerac2isrunningonnode[oracle@rac1~]$srvctlstatusnodeappsVIPrac1-vipisenabledVIPrac1-vipisrunningonnode:rac1VIPrac2-vipisenabledVIPrac2-vipisrunningonnode:rac2NetworkisenabledNetworkisrunningonnode:rac1Networkisrunningonnode:rac2GSDisdisabledGSDisnotrunningonnode:rac1GSDisnotrunningonnode:rac2ONSisenabledONSdaemonisrunningonnode:rac1ONSdaemonisrunningonnode:rac2eONSisenabledeONSdaemonisrunningonnode:rac1eONSdaemonisrunningonnode:rac2[oracle@rac1 srvctlconfignodeapps-a-g-s--loptionhasbeendeprecatedandwillbeignored.VIPexists.:rac1VIPexists.:rac2GSDexists.ONSdaemonexists.Localport6100,remoteport6200Name:LISTENERHome:<CRShome>Endpoints:TCP:1521[oracle@rac1~]$srvctlconfigdatabase-dprod-aDatabaseuniquename:prodOracleuser:oracleSpfile::Stopoptions:immediateDataba