HIS系统项目ORACLE12CRAC实施报告

41/41 ORACLE12CRACHIS工程ORACLERAC实施报告系统环境硬件：P824SanSwitch各两台，3PAR存储；软件：Oracle12C安装规划：1.1系统集成前规划机号机型主机名实例名网卡IP系统1HISDB1Hisdb_1Eth01AIX7.1OracleClusterOracleSoftVIP6Eth1（心跳）2HISDB2Hisdb_1Eth02AIX7.1OracleClusterOracleSoftVIP7Eth1（心跳）SCANIP8~20它其设置网关gateway01子网掩码netmaskDNS1.2.存储的划分ORACLE空间存储柜划分存储柜整列RAIDLUN容量文件格式用途1Array110110GASMOCR/VotingDisk210GASMOCR/VotingDisk310GASMOCR/VotingDisk41TBASMASMDisk51TBASMASMDisk61TBASMASMDisk71TBASMASMDisk8300GBASMORACLEArchielog9300gbASMORACLEArchielog安装前的准备系统补丁补丁列表如下：pat.clients.rte检查补丁文件。lslpp-lbos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatctoolsrsct.basic.rtepat.clients.rte修改系统参数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修改磁盘属性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系统连接数smittychgsysMaximumnumberofPROCESSESallowedperuser[16384]换页空间Smittychps增加换页空间修改/etc/hosts修改/etc/hosts1hisdb16hisdb1vip2hisdb2hisdb2priv7hisdb2vip890hisdb1priv配置NTP#vi/etc/ntp.conf#broadcastclient

server5

drift

trace启动xntpd守护进程#startsrc-sxntpdxntpd状态查询,使用#lssrc-lsxntpd刚启动xntpd时,syspeer为'insane',说明xntpd还没有完成同步启动xntpd守护进程#startsrc-sxntpdxntpd状态查询,使用#lssrc-lsxntpd创立用户和组创立用户及相应的目录创立组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创立用户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修改两用户权限default:fsize=-1core=2097151cpu=-1data=-1rss=-1stack=-1nofiles=-12）配置GRID用户环境变量#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用户环境变量；#su–oracle#more.profile（oracle环境变量）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确保系统有默认网关两个用户配置SSHGridingrastrue会自动配置两节点的SSH，不过在实际安装中，可能会碰到不能自动安装的情况，我们可以通过手工安装解决这一问题配置SSH的对等性

在所有节点配置SSH的对等性

在安装OracleRealApplicationclusters之前,必须先配置所有节点的SSH对等性。因为在安装过程种OracleUniversalInstaller使用ssh和scp命令执行远程命令执行及copy的工作。

下面是具体的步骤：

以下步骤在所有节点上执行：

1.以oracle用户登陆

#su–oracle

2.在两个节点的oracle主目录分别创立.ssh目录，并赋予权限。

#mkdir~/.ssh

#chmod755~/.ssh

3.在两个节点分别生成RSAkey

#/usr/bin/ssh-keygen-trsa

会出现如下提示:

■Acceptthedefaultlocationforthekeyfile.

■Enterandconfirmapassphrasethatisdifferentfromtheoracleuser’spassword.phrase

密码处直接回车即可

4.生成DSAkey

#/usr/bin/ssh-keygen-tdsa

出现如下提示:

■Acceptthedefaultlocationforthekeyfile.

■Enterandconfirmapassphrasethatisdifferentfromtheoracleuser’spassword.phrase

密码处直接回车即可

5.以oracle用户身份，在所有节点创立authorized_keys文件，并赋予权限

#touch~/.ssh/authorized_keys

#cd~/.ssh

#ls

你应该可以看到你所创立的id_dsa.pub和id_rsa.pub和authorized_keys

6.在两个节点分别将id_dsa.pub和id_rsa.pub参加到authorized_keys

#su–grid$mkdir-p~/.ssh$chmod700~/.ssh$/usr/bin/ssh-keygen-trsa提示输入输入密码时，保持为空回车即可，使用空密码操作简单一些。以下只在hisdb1上执行$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个节点上执行：$chmod600~/.ssh/authorized_keys当用户等效性建立完毕后，在两个RAC节点都执行下面的命令，来验证等效性是否正确6.以oracle用户身份，运行OracleUniversalInstaller的节点上执行如下命令，然后测试ssh的对等性。

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

节点1

#sshhisdb1date

#sshhisdb2date

节点2

#sshhisdb2date

#sshhisdb1date

如果都不需要密码，得到时间后。就说明ssh对等性配置成功。安装OracelGridInfrastrue#su–gridBourneorKornshell:$DISPLAY=local_host:0.0;exportDISPLAYCshell:%setenvDISPLAYlocal_host:0.0安装选项：安装类型选择：选择语言：配置SCAN：配置Cluster节点信息：配置SSH选择特定的网络接口：存储选择：创立ASM磁盘组：特定的管理组：密码：选择安装位置：选择特定的OraInventory：执行预安装检查：安装汇总：按提示执行脚步：两台效劳器分别运行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配置平安更新：安装选项：ORACLE安装选项：选择安装的机器选择语言：选择数据库版本：选择安装位置：选择特定管理组：预安装检查：安装汇总：按提示执行脚本：创立ASM卷组#创立数据库#dbca&RAC的简单管理1．状态检查：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．验证集群化数据库已开启$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状态：p570a->crsctlcheckclusterCRS-4537:ClusterReadyServicesisonlineCRS-4529:ClusterSynchronizationServicesisonlineCRS-4533:EventManagerisonline4．验证数据库状态$srvctlstatusdatabase-dhisdbInstancehisdb1isrunningonnodehisdb1Instancehisdb2isrunningonnodehisdb2p570a->srvctlstatusinstance-ddbrac-iorcl1Instanceorcl1isrunningonnodep570ap570a->srvctlstatusinstance-ddbrac-iorcl2Instanceorcl2isrunningonnodep570b5．验证应用状态srvctlstatusnodeappsInstancehisdb1isrunningonnodehisdb1Instancehisdb2isrunningonnodehisdb2$srvctlstatusnodeappsVIPhisdb1-vipisenabledVIPhisdb1-vipisrunningonnode:hisdb1VIPhisdb2-vipisenabledVIPhisdb2-vipisrunningonnode:hisdb2NetworkisenabledNetworkisrunningonnode:hisdb1Networkisrunningonnode:hisdb2GSDisdisabledGSDisnotrunningonnode:hisdb1GSDisnotrunningonnode:hisdb2ONSisenabledONSdaemonisrunningonnode:hisdb1ONSdaemonisrunningonnode:hisdb26．节点应用程序—（配置）srvctlconfignodeappsNetworkexists:1///en0,typestaticVIPexists:/hisdb1-vip/0///en0,hostingnodehisdb1VIPexists:/hisdb2-vip/2///en0,hostingnodehisdb2GSDexistsONSexists:Localport6100,remoteport6200,EMport20167．数据库—（配置）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—（状态和配置）srvctlstatusasmASMisrunningonhisdb2,hisdb1srvctlconfigasm-aASMhome:/oracle/app/grid/product/12.1.0ASMlistener:LISTENERASMisenabled.9．TNS监听器—（状态和配置）srvctls