HIS系統(tǒng)項(xiàng)目ORACLE12CRAC實(shí)施報(bào)告

41/41 ORACLE12CRACHIS工程O(píng)RACLERAC實(shí)施報(bào)告系統(tǒng)環(huán)境硬件：P824SanSwitch各兩臺(tái)，3PAR存儲(chǔ)；軟件：Oracle12C安裝規(guī)劃：1.1系統(tǒng)集成前規(guī)劃?rùn)C(jī)號(hào)機(jī)型主機(jī)名實(shí)例名網(wǎng)卡IP系統(tǒng)1HISDB1Hisdb_1Eth01AIX7.1OracleClusterOracleSoftVIP6Eth1（心跳）2HISDB2Hisdb_1Eth02AIX7.1OracleClusterOracleSoftVIP7Eth1（心跳）SCANIP8~20它其設(shè)置網(wǎng)關(guān)gateway01子網(wǎng)掩碼netmaskDNS1.2.存儲(chǔ)的劃分ORACLE空間存儲(chǔ)柜劃分存儲(chǔ)柜整列RAIDLUN容量文件格式用途1Array110110GASMOCR/VotingDisk210GASMOCR/VotingDisk310GASMOCR/VotingDisk41TBASMASMDisk51TBASMASMDisk61TBASMASMDisk71TBASMASMDisk8300GBASMORACLEArchielog9300gbASMORACLEArchielog安裝前的準(zhǔn)備系統(tǒng)補(bǔ)丁補(bǔ)丁列表如下：pat.clients.rte檢查補(bǔ)丁文件。lslpp-lbos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatctoolsrsct.basic.rtepat.clients.rte修改系統(tǒng)參數(shù)VMOvmo-p-ominperm%=3vmo-p-omaxperm%=90vmo-p-omaxclient%=90vmo-p-olru_vmo-p-ostrict_maxclient=1vmo-p-ostrict_maxperm=0ConfigureNetworkTuningParametersno-p-oudp_sendspace=65536no-p-oudp_recvspace=262144no-p-otcp_sendspace=262144no-p-otcp_recvspace=262144no-p-orfc1323=1no-p-osb_max=2*655360no-r-oipqmaxlen=512修改磁盤(pán)屬性chowngrid:asmadmin/dev/rhdisk1chowngrid:asmadmin/dev/rhdisk2chowngrid:asmadmin/dev/rhdisk3chowngrid:asmadmin/dev/rhdisk4chowngrid:asmadmin/dev/rhdisk5chowngrid:asmadmin/dev/rhdisk6chowngrid:asmadmin/dev/rhdisk7chowngrid:asmadmin/dev/rhdisk8chowngrid:asmadmin/dev/rhdisk9chmod660/dev/rhdisk1chmod660/dev/rhdisk2chmod660/dev/rhdisk3chmod660/dev/rhdisk4chmod660/dev/rhdisk5chmod660/dev/rhdisk6chmod660/dev/rhdisk7chmod660/dev/rhdisk8chmod660/dev/rhdisk9chdev-lhdisk1-areserve_policy=no_reservechdev-lhdisk2-areserve_policy=no_reservechdev-lhdisk3-areserve_policy=no_reservechdev-lhdisk4-areserve_policy=no_reservechdev-lhdisk5-areserve_policy=no_reservechdev-lhdisk6-areserve_policy=no_reservechdev-lhdisk7-areserve_policy=no_reservechdev-lhdisk8-areserve_policy=no_reservechdev-lhdisk9-areserve_policy=no_reserve/usr/sbin/chdev-lhdisk1-apv=clear/usr/sbin/chdev-lhdisk2-apv=clear/usr/sbin/chdev-lhdisk3-apv=clear/usr/sbin/chdev-lhdisk4-apv=clear/usr/sbin/chdev-lhdisk5-apv=clear/usr/sbin/chdev-lhdisk6-apv=clear/usr/sbin/chdev-lhdisk7-apv=clear/usr/sbin/chdev-lhdisk8-apv=clear/usr/sbin/chdev-lhdisk9-apv=clear系統(tǒng)連接數(shù)smittychgsysMaximumnumberofPROCESSESallowedperuser[16384]換頁(yè)空間Smittychps增加換頁(yè)空間修改/etc/hosts修改/etc/hosts1hisdb16hisdb1vip2hisdb2hisdb2priv7hisdb2vip890hisdb1priv配置NTP#vi/etc/ntp.conf#broadcastclient

server5

drift

trace啟動(dòng)xntpd守護(hù)進(jìn)程#startsrc-sxntpdxntpd狀態(tài)查詢,使用#lssrc-lsxntpd剛啟動(dòng)xntpd時(shí),syspeer為'insane',說(shuō)明xntpd還沒(méi)有完成同步啟動(dòng)xntpd守護(hù)進(jìn)程#startsrc-sxntpdxntpd狀態(tài)查詢,使用#lssrc-lsxntpd創(chuàng)立用戶和組創(chuàng)立用戶及相應(yīng)的目錄創(chuàng)立組mkgroup-'A'id='1000'adms='root'oinstallmkgroup-'A'id='1100'adms='root'asmadminmkgroup-'A'id='1200'adms='root'dbamkgroup-'A'id='1201'adms='root'opermkgroup-'A'id='1300'adms='root'asmdbamkgroup-'A'id='1301'adms='root'asmoper創(chuàng)立用戶mkuserid='1100'pgrp='oinstall'groups='asmadmin,asmdba,asmoper'home='/home/grid'gridmkuserid='1101'pgrp='oinstall'groups='dba,asmdba'home='/home/oracle'oraclechusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEgridchusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEoracle修改兩用戶權(quán)限default:fsize=-1core=2097151cpu=-1data=-1rss=-1stack=-1nofiles=-12）配置GRID用戶環(huán)境變量#su–gridexportORACLE_BASE=/oracle/app/oracleexportORACLE_HOME=/oracle/app/grid/product/12.1.0exportORACLE_SID=+ASM1exportNLS_LANG=AMERICAN_AMERICA.AL32UTF8exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:mi:ss"exportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportPATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$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'"$"3）配置Oracle用戶環(huán)境變量；#su–oracle#more.profile（oracle環(huán)境變量）exportORACLE_BASE=/oracle/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/12.1.0exportORACLE_SID=020db1exportORACLE_UNQNAME=testdbexportNLS_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/binexportPATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/admin#exportORA_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'"$"安裝前的檢查額外的檢查#bdf/home/gridEnsureyouhaveatleast4.5GBofspaceforthegridinfrastructureforaclusterhome(Gridhome)ThisincludesOracleClusterwareandAutomaticStorageManagement(OracleASM)filesandlogfiles.Grid存放空間大于10GB，oracle存放空間大于8GB#/bdf/tmp（大于1G的TEMP空間）Ensurethatyouhaveatleast1GBofspacein/tmp#adddefaultgateway確保系統(tǒng)有默認(rèn)網(wǎng)關(guān)兩個(gè)用戶配置SSHGridingrastrue會(huì)自動(dòng)配置兩節(jié)點(diǎn)的SSH，不過(guò)在實(shí)際安裝中，可能會(huì)碰到不能自動(dòng)安裝的情況，我們可以通過(guò)手工安裝解決這一問(wèn)題配置SSH的對(duì)等性

在所有節(jié)點(diǎn)配置SSH的對(duì)等性

在安裝OracleRealApplicationclusters之前,必須先配置所有節(jié)點(diǎn)的SSH對(duì)等性。因?yàn)樵诎惭b過(guò)程種OracleUniversalInstaller使用ssh和scp命令執(zhí)行遠(yuǎn)程命令執(zhí)行及copy的工作。

下面是具體的步驟：

以下步驟在所有節(jié)點(diǎn)上執(zhí)行：

1.以oracle用戶登陸

#su–oracle

2.在兩個(gè)節(jié)點(diǎn)的oracle主目錄分別創(chuàng)立.ssh目錄，并賦予權(quán)限。

#mkdir~/.ssh

#chmod755~/.ssh

3.在兩個(gè)節(jié)點(diǎn)分別生成RSAkey

#/usr/bin/ssh-keygen-trsa

會(huì)出現(xiàn)如下提示:

■Acceptthedefaultlocationforthekeyfile.

■Enterandconfirmapassphrasethatisdifferentfromtheoracleuser’spassword.phrase

密碼處直接回車(chē)即可

4.生成DSAkey

#/usr/bin/ssh-keygen-tdsa

出現(xiàn)如下提示:

■Acceptthedefaultlocationforthekeyfile.

■Enterandconfirmapassphrasethatisdifferentfromtheoracleuser’spassword.phrase

密碼處直接回車(chē)即可

5.以oracle用戶身份，在所有節(jié)點(diǎn)創(chuàng)立authorized_keys文件，并賦予權(quán)限

#touch~/.ssh/authorized_keys

#cd~/.ssh

#ls

你應(yīng)該可以看到你所創(chuàng)立的id_dsa.pub和id_rsa.pub和authorized_keys

6.在兩個(gè)節(jié)點(diǎn)分別將id_dsa.pub和id_rsa.pub參加到authorized_keys

#su–grid$mkdir-p~/.ssh$chmod700~/.ssh$/usr/bin/ssh-keygen-trsa提示輸入輸入密碼時(shí)，保持為空回車(chē)即可，使用空密碼操作簡(jiǎn)單一些。以下只在hisdb1上執(zhí)行$touch~/.ssh/authorized_keys$sshhisdb2cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys$sshhisdb1cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys$scp~/.ssh/authorized_keyshisdb1:.ssh/authorized_keys以下只在2個(gè)節(jié)點(diǎn)上執(zhí)行：$chmod600~/.ssh/authorized_keys當(dāng)用戶等效性建立完畢后，在兩個(gè)RAC節(jié)點(diǎn)都執(zhí)行下面的命令，來(lái)驗(yàn)證等效性是否正確6.以oracle用戶身份，運(yùn)行OracleUniversalInstaller的節(jié)點(diǎn)上執(zhí)行如下命令，然后測(cè)試ssh的對(duì)等性。

#exec/usr/bin/ssh-agent$SHELL

節(jié)點(diǎn)1

#sshhisdb1date

#sshhisdb2date

節(jié)點(diǎn)2

#sshhisdb2date

#sshhisdb1date

如果都不需要密碼，得到時(shí)間后。就說(shuō)明ssh對(duì)等性配置成功。安裝OracelGridInfrastrue#su–gridBourneorKornshell:$DISPLAY=local_host:0.0;exportDISPLAYCshell:%setenvDISPLAYlocal_host:0.0安裝選項(xiàng)：安裝類(lèi)型選擇：選擇語(yǔ)言：配置SCAN：配置Cluster節(jié)點(diǎn)信息：配置SSH選擇特定的網(wǎng)絡(luò)接口：存儲(chǔ)選擇：創(chuàng)立ASM磁盤(pán)組：特定的管理組：密碼：選擇安裝位置：選擇特定的OraInventory：執(zhí)行預(yù)安裝檢查：安裝匯總：按提示執(zhí)行腳步：兩臺(tái)效勞器分別運(yùn)行root.sh/oracle/app/oraInventory/orainstRoot.shChangingpermissionsof/oracle/app/oraInventory.Addingread,writepermissionsforgroup.Removingread,write,executepermissionsforworld.Changinggroupnameof/oracle/app/oraInventorytooinstall.Theexecutionofthescriptiscomplete.#hostnamehisdb1#/oracle/app/grid/product/12.1.0/root.shPerformingrootuseroperation.Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=gridORACLE_HOME=/oracle/app/grid/product/12.1.0Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thecontentsof"dbhome"havenotchanged.Noneedtooverwrite.Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Creating/etc/oratabfile...Entrieswillbeaddedtothe/etc/oratabneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Usingconfigurationparameterfile:/oracle/app/grid/product/12.1.0/crs/install/crsconfig_params2015/11/0918:04:35CLSRSC-4001:InstallingOracleTrace(TFA)Collector.2015/11/0918:05:43CLSRSC-4002:SuccessfullyinstalledOracleTraceer(TFA)Collector.2015/11/0918:05:45CLSRSC-363:UserignoredprerequisitesduringinstallationUsergridhastherequiredcapabilitiestorunCSSDinrealtimemodeOLRinitialization-successfulrootwalletrootwalletcertrootcertexportpeerwalletprowalletpawalletpeerwalletkeyspawalletkeyspeercertrequestpacertrequestpeercertpacertpeerrootcertTPprorootcertTPparootcertTPpeerpacertTPpapeercertTPpropacertTPpropeercertTPpeerusercertpausercert2015/11/0918:08:18CLSRSC-330:AddingClusterwareentriestofile'/etc/inittab'CRS-4133:OracleHighAvailabilityServiceshasbeenstopped.CRS-4123:OracleHighAvailabilityServiceshasbeenstarted.CRS-4133:OracleHighAvailabilityServiceshasbeenstopped.CRS-4123:OracleHighAvailabilityServiceshasbeenstarted.CRS-2672:Attemptingtostart'ora.evmd'on'hisdb1'CRS-2672:Attemptingtostart'ora.mdnsd'on'hisdb1'CRS-2676:Startof'ora.evmd'on'hisdb1'succeededCRS-2676:Startof'ora.mdnsd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'hisdb1'CRS-2676:Startof'ora.gpnpd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'hisdb1'CRS-2672:Attemptingtostart'ora.gipcd'on'hisdb1'CRS-2676:Startof'ora.cssdmonitor'on'hisdb1'succeededCRS-2676:Startof'ora.gipcd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.cssd'on'hisdb1'CRS-2672:Attemptingtostart'ora.diskmon'on'hisdb1'CRS-2676:Startof'ora.diskmon'on'hisdb1'succeededCRS-2676:Startof'ora.cssd'on'hisdb1'succeededASMcreatedandstartedsuccessfully.DiskGroupcrscreatedsuccessfully.CRS-2672:Attemptingtostart'ora.crf'on'hisdb1'CRS-2672:Attemptingtostart'ora.storage'on'hisdb1'CRS-2676:Startof'ora.storage'on'hisdb1'succeededCRS-2676:Startof'ora.crf'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.crsd'on'hisdb1'CRS-2676:Startof'ora.crsd'on'hisdb1'succeededCRS-4256:UpdatingtheprofileSuccessfuladditionofvotingdisk0561c51d65264f4dbf9229d3a6245172.Successfuladditionofvotingdiskb5d1f1c029154f96bf32985bf0b6e231.Successfuladditionofvotingdisk5021e253d6654f6ebf4c39f4f462a31f.Successfullyreplacedvotingdiskgroupwith+crs.CRS-4256:UpdatingtheprofileCRS-4266:Votingfile(s)successfullyreplaced##STATEIdDiskgroup--1.ONLINE0561c51d65264f4dbf9229d3a6245172(/dev/rhdisk1)[CRS]2.ONLINEb5d1f1c029154f96bf32985bf0b6e231(/dev/rhdisk2)[CRS]3.ONLINE5021e253d6654f6ebf4c39f4f462a31f(/dev/rhdisk3)[CRS]Located3votingdisk(s).CRS-2791:StartingshutdownofOracleHighAvailabilityServices-managedresourceson'hisdb1'CRS-2673:Attemptingtostop'ora.crsd'on'hisdb1'CRS-2677:Stopof'ora.crsd'on'hisdb1'succeededCRS-2673:Attemptingtostop'ora.storage'on'hisdb1'CRS-2673:Attemptingtostop'ora.mdnsd'on'hisdb1'CRS-2673:Attemptingtostop'ora.gpnpd'on'hisdb1'CRS-2673:Attemptingtostop'ora.drivers.acfs'on'hisdb1'CRS-2677:Stopof'ora.storage'on'hisdb1'succeededCRS-2673:Attemptingtostop'ora.crf'on'hisdb1'CRS-2673:Attemptingtostop'ora.ctssd'on'hisdb1'CRS-2673:Attemptingtostop'ora.evmd'on'hisdb1'CRS-2673:Attemptingtostop'ora.asm'on'hisdb1'CRS-2677:Stopof'ora.drivers.acfs'on'hisdb1'succeededCRS-2677:Stopof'ora.mdnsd'on'hisdb1'succeededCRS-2677:Stopof'ora.gpnpd'on'hisdb1'succeededCRS-2677:Stopof'ora.crf'on'hisdb1'succeededCRS-2677:Stopof'ora.ctssd'on'hisdb1'succeededCRS-2677:Stopof'ora.evmd'on'hisdb1'succeededCRS-2677:Stopof'ora.asm'on'hisdb1'succeededCRS-2673:Attemptingtostop'ora.cluster_interconnect.haip'on'hisdb1'CRS-2677:Stopof'ora.cluster_interconnect.haip'on'hisdb1'succeededCRS-2673:Attemptingtostop'ora.cssd'on'hisdb1'CRS-2677:Stopof'ora.cssd'on'hisdb1'succeededCRS-2673:Attemptingtostop'ora.gipcd'on'hisdb1'CRS-2677:Stopof'ora.gipcd'on'hisdb1'succeededCRS-2793:ShutdownofOracleHighAvailabilityServices-managedresourceson'hisdb1'hascompletedCRS-4133:OracleHighAvailabilityServiceshasbeenstopped.CRS-4123:StartingOracleHighAvailabilityServices-managedresourcesCRS-2672:Attemptingtostart'ora.mdnsd'on'hisdb1'CRS-2672:Attemptingtostart'ora.evmd'on'hisdb1'CRS-2676:Startof'ora.mdnsd'on'hisdb1'succeededCRS-2676:Startof'ora.evmd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'hisdb1'CRS-2676:Startof'ora.gpnpd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.gipcd'on'hisdb1'CRS-2676:Startof'ora.gipcd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'hisdb1'CRS-2676:Startof'ora.cssdmonitor'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.cssd'on'hisdb1'CRS-2672:Attemptingtostart'ora.diskmon'on'hisdb1'CRS-2676:Startof'ora.diskmon'on'hisdb1'succeededCRS-2676:Startof'ora.cssd'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.cluster_interconnect.haip'on'hisdb1'CRS-2672:Attemptingtostart'ora.ctssd'on'hisdb1'CRS-2676:Startof'ora.ctssd'on'hisdb1'succeededCRS-2676:Startof'ora.cluster_interconnect.haip'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.asm'on'hisdb1'CRS-2676:Startof'ora.asm'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.storage'on'hisdb1'CRS-2676:Startof'ora.storage'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.crf'on'hisdb1'CRS-2676:Startof'ora.crf'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.crsd'on'hisdb1'CRS-2676:Startof'ora.crsd'on'hisdb1'succeededCRS-6023:StartingOracleClusterReadyServices-managedresourcesCRS-6017:Processingresourceauto-startforservers:hisdb1CRS-6016:Resourceauto-starthascompletedforserverhisdb1CRS-6024:CompletedstartofOracleClusterReadyServices-managedresourcesCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.2015/11/0918:17:52CLSRSC-343:SuccessfullystartedOracleClusterwarestackCRS-2672:Attemptingtostart'ora.asm'on'hisdb1'CRS-2676:Startof'ora.asm'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.CRS.dg'on'hisdb1'CRS-2676:Startof'ora.CRS.dg'on'hisdb1'succeeded2015/11/0918:20:07CLSRSC-325:ConfigureOracleGridInfrastructureforaCluster...succeededed#/oracle/app/grid/product/12.1.0/root.shPerformingrootuseroperation.Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=gridORACLE_HOME=/oracle/app/grid/product/12.1.0Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thecontentsof"dbhome"havenotchanged.Noneedtooverwrite.Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Creating/etc/oratabfile...Entrieswillbeaddedtothe/etc/oratabneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Usingconfigurationparameterfile:/oracle/app/grid/product/12.1.0/crs/install/crsconfig_params2015/11/0918:23:15CLSRSC-4001:InstallingOracleTrace(TFA)Collector.2015/11/0918:24:22CLSRSC-4002:SuccessfullyinstalledOracleTrace(TFA)Collector.2015/11/0918:24:24CLSRSC-363:UserignoredprerequisitesduringinstallationUsergridhastherequiredcapabilitiestorunCSSDinrealtimemodeOLRinitialization-successful2015/11/0918:26:03CLSRSC-330:AddingClusterwareentriestofile'/etc/inittab'CRS-4133:OracleHighAvailabilityServiceshasbeenstopped.CRS-4123:OracleHighAvailabilityServiceshasbeenstarted.CRS-4133:OracleHighAvailabilityServiceshasbeenstopped.CRS-4123:OracleHighAvailabilityServiceshasbeenstarted.CRS-2791:StartingshutdownofOracleHighAvailabilityServices-managedresourceson'hisdb2'CRS-2673:Attemptingtostop'ora.drivers.acfs'on'hisdb2'CRS-2677:Stopof'ora.drivers.acfs'on'hisdb2'succeededCRS-2793:ShutdownofOracleHighAvailabilityServices-managedresourceson'hisdb2'hascompletedCRS-4133:OracleHighAvailabilityServiceshasbeenstopped.CRS-4123:StartingOracleHighAvailabilityServices-managedresourcesCRS-2672:Attemptingtostart'ora.mdnsd'on'hisdb2'CRS-2672:Attemptingtostart'ora.evmd'on'hisdb2'CRS-2676:Startof'ora.mdnsd'on'hisdb2'succeededCRS-2676:Startof'ora.evmd'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'hisdb2'CRS-2676:Startof'ora.gpnpd'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.gipcd'on'hisdb2'CRS-2676:Startof'ora.gipcd'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'hisdb2'CRS-2676:Startof'ora.cssdmonitor'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.cssd'on'hisdb2'CRS-2672:Attemptingtostart'ora.diskmon'on'hisdb2'CRS-2676:Startof'ora.diskmon'on'hisdb2'succeededCRS-2676:Startof'ora.cssd'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.cluster_interconnect.haip'on'hisdb2'CRS-2672:Attemptingtostart'ora.ctssd'on'hisdb2'CRS-2676:Startof'ora.ctssd'on'hisdb2'succeededCRS-2676:Startof'ora.cluster_interconnect.haip'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.asm'on'hisdb2'CRS-2676:Startof'ora.asm'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.storage'on'hisdb2'CRS-2676:Startof'ora.storage'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.crf'on'hisdb2'CRS-2676:Startof'ora.crf'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.crsd'on'hisdb2'CRS-2676:Startof'ora.crsd'on'hisdb2'succeededCRS-6017:Processingresourceauto-startforservers:hisdb2CRS-2672:Attemptingtostart'work'on'hisdb2'CRS-2676:Startof'work'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.ons'on'hisdb2'CRS-2676:Startof'ora.ons'on'hisdb2'succeededCRS-2673:Attemptingtostop'ora.LISTENER_SCAN1.lsnr'on'hisdb1'CRS-2677:Stopof'ora.LISTENER_SCAN1.lsnr'on'hisdb1'succeededCRS-2673:Attemptingtostop'ora.scan1.vip'on'hisdb1'CRS-2677:Stopof'ora.scan1.vip'on'hisdb1'succeededCRS-2672:Attemptingtostart'ora.scan1.vip'on'hisdb2'CRS-2676:Startof'ora.scan1.vip'on'hisdb2'succeededCRS-2672:Attemptingtostart'ora.LISTENER_SCAN1.lsnr'on'hisdb2'CRS-2676:Startof'ora.LISTENER_SCAN1.lsnr'on'hisdb2'succeededCRS-6016:Resourceauto-starthascompletedforserverhisdb2CRS-6024:CompletedstartofOracleClusterReadyServices-managedresourcesCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.2015/11/0918:32:29CLSRSC-343:SuccessfullystartedOracleClusterwarestack2015/11/0918:33:01CLSRSC-325:ConfigureOracleGridInfrastructureforaCluster...succeededYouhavemailin/usr/spool/mail/root安裝OracleDatabase#su-oracle./runInstaller配置平安更新：安裝選項(xiàng)：ORACLE安裝選項(xiàng)：選擇安裝的機(jī)器選擇語(yǔ)言：選擇數(shù)據(jù)庫(kù)版本：選擇安裝位置：選擇特定管理組：預(yù)安裝檢查：安裝匯總：按提示執(zhí)行腳本：創(chuàng)立ASM卷組#創(chuàng)立數(shù)據(jù)庫(kù)#dbca&RAC的簡(jiǎn)單管理1．狀態(tài)檢查：Hisdb1->su-grid-c"crs_stat-t"#su-grid-c"crs_stat-t"NameTypeTargetStateHostora.ARCH.dgoraup.typeONLINEONLINEhisdb1ora.CRS.dgoraup.typeONLINEONLINEhisdb1ora.DATA.dgoraup.typeONLINEONLINEhisdb1oraER.lsnroraer.typeONLINEONLINEhisdb1oraN1.lsnroraer.typeONLINEONLINEhisdb2ora.asmora.asm.typeONLINEONLINEhisdb1ora.cvuora.cvu.typeONLINEONLINEhisdb2ora.gsdora.gsd.typeOFFLINEOFFLINEworkorark.typeONLINEONLINEhisdb1ora.hisdb.dborase.typeONLINEONLINEhisdb2oraSM1.asmapplicationONLINEONLINEhisdb1ora01.lsnrapplicationONLINEONLINEhisdb1orab01.gsdapplicationOFFLINEOFFLINEorab01.onsapplicationONLINEONLINEhisdb1orab01.viporat1.typeONLINEONLINEhisdb1oraSM2.asmapplicationONLINEONLINEhisdb2ora02.lsnrapplicationONLINEONLINEhisdb2orab02.gsdapplicationOFFLINEOFFLINEorab02.onsapplicationONLINEONLINEhisdb2orab02.viporat1.typeONLINEONLINEhisdb2ora.oc4jora.oc4j.typeONLINEONLINEhisdb2ora.onsora.ons.typeONLINEONLINEhisdb1orary.acfsorafs.typeONLINEONLINEhisdb1ora.scan1.viporaip.typeONLINEONLINEhisdb22．驗(yàn)證集群化數(shù)據(jù)庫(kù)已開(kāi)啟$su-grid-c"crsctlstatusresource-w\"TYPEco'ora'\"-t"NAMETARGETSTATESERVERSTATE_DETAILSLocalResourcesora.ARCH.dgONLINEONLINEhisdb1ONLINEONLINEhisdb2ora.CRS.dgONLINEONLINEhisdb1ONLINEONLINEhisdb2ora.DATA.dgONLINEONLINEhisdb1ONLINEONLINEhisdb2ora.LISTENER.lsnrONLINEONLINEhisdb1ONLINEONLINEhisdb2ora.asmONLINEONLINEhisdb1StartedONLINEONLINEhisdb2Startedora.gsdOFFLINEOFFLINEhisdb1OFFLINEOFFLINEworkONLINEONLINEhisdb1ONLINEONLINEhisdb2ora.onsONLINEONLINEhisdb1ONLINEONLINEhisdb2ora.registry.acfsONLINEONLINEhisdb1ONLINEONLINEhisdb2ClusterResourcesora.LISTENER_SCAN1.lsnr1ONLINEONLINEhisdb2ora.cvu1ONLINEONLINEhisdb2ora.hisdb.db1ONLINEONLINEhisdb2Open2ONLINEONLINEhisdb1Openora.hisdb1.vip1ONLINEONLINEhisdb1ora.hisdb2.vip1ONLINEONLINEhisdb2ora.oc4j1ONLINEONLINEhisdb2ora.scan1.vip1ONLINEONLINEhisdb23．檢查cluster狀態(tài)：p570a->crsctlcheckclusterCRS-4537:ClusterReadyServicesisonlineCRS-4529:ClusterSynchronizationServicesisonlineCRS-4533:EventManagerisonline4．驗(yàn)證數(shù)據(jù)庫(kù)狀態(tài)$srvctlstatusdatabase-dhisdbInstancehisdb1isrunningonnodehisdb1Instancehisdb2isrunningonnodehisdb2p570a->srvctlstatusinstance-ddbrac-iorcl1Instanceorcl1isrunningonnodep570ap570a->srvctlstatusinstance-ddbrac-iorcl2Instanceorcl2isrunningonnodep570b5．驗(yàn)證應(yīng)用狀態(tài)srvctlstatusnodeappsInstancehisdb1isrunningonnodehisdb1Instancehisdb2isrunningonnodehisdb2$srvctlstatusnodeappsVIPhisdb1-vipisenabledVIPhisdb1-vipisrunningonnode:hisdb1VIPhisdb2-vipisenabledVIPhisdb2-vipisrunningonnode:hisdb2NetworkisenabledNetworkisrunningonnode:hisdb1Networkisrunningonnode:hisdb2GSDisdisabledGSDisnotrunningonnode:hisdb1GSDisnotrunningonnode:hisdb2ONSisenabledONSdaemonisrunningonnode:hisdb1ONSdaemonisrunningonnode:hisdb26．節(jié)點(diǎn)應(yīng)用程序—（配置）srvctlconfignodeappsNetworkexists:1///en0,typestaticVIPexists:/hisdb1-vip/0///en0,hostingnodehisdb1VIPexists:/hisdb2-vip/2///en0,hostingnodehisdb2GSDexistsONSexists:Localport6100,remoteport6200,EMport20167．?dāng)?shù)據(jù)庫(kù)—（配置）srvctlconfigdatabase-dhisdb-aDatabaseuniquename:hisdbDatabasename:hisdbOraclehome:/oracle/app/oracle/product/11.2Oracleuser:oracleSpfile:+DATA/hisdb/spDomain:Startoptions:openStopoptions:immediateDatabaserole:PRIMARYManagementpolicy:AUTOMATICServerpools:hisdbDatabaseinstances:hisdb1,hisdb2DiskGroups:DATAMountpointpaths:Services:Type:RACDatabaseisenabledDatabaseisadministratormanaged8．ASM—（狀態(tài)和配置）srvctlstatusasmASMisrunningonhisdb2,hisdb1srvctlconfigasm-aASMhome:/oracle/app/grid/product/12.1.0ASMlistener:LISTENERASMisenabled.9．TNS監(jiān)聽(tīng)器—（狀態(tài)和配置）srvctls