Oracle -甲骨文-相关文档 ORACLE-EXADATA升级

1务 (三)升级LSIDiskArray 12四)升级存储节点 20 (六)升级计算节点 46(七)升级BundlePatch23 55 57(九)升级后的检查 66 2务客户的Exadata一体机版本目前是.0，为了提高安全性和racleExadata。本期升级的操作流程如下：ILOM3．升级LSIDISKArrayControllerFirmware(存储节点)；4．升级存储节点的IMAGE到.0；5．释放计算节点Solaris操作系统；6．升级计算节点的IMAGE到.0；本次升级所需要的安装介质如下：Exadata.0StorageServerPatchandInfiniBandswitche—->p16278923_112330_Linux-x86-64.zipDBNODEUPDATE–ONESTEPUPDATEUTL.FORLINUXDBSERVERS—->p16486998_121111_Linux-x86-64.zipEXADATACOMPUTENODE.0BASEREPOSITORYISO—->p17809253_112330_Linux-x86-64.zipBASEPATCHFOREXADATAJUL—->p18835772_112030_L3务EXADATA.0PATCHMGRPLUG-INSDOWNLOAD—->p17938410_112330_Linux-x86-64.zipBug16397592diskcontrollerfwcheckisincorrect12.9.0049>=12.12.00140—->FW12120140.zipPatch6880880OPatchpatchofversion.6forOraclesoftwarereleases11.2.0.x(DEC2013)—->p6880880_112000_Linux-x86-64.zip本次升级可能存在的风险点：对于存储节点的损坏我们可以采用CELLBOOTUSBFlashDrive来进行恢复，可以参考Oracle®ExadataDatabaseMachineOwner’sGuide11gRelease2(11.2)的7.32UsingtheOracleExadataStorageServerSoftwareRescueProcedure。算节点损坏；器上，方便做恢复。3．集群软件、数据库软件损坏；对于集群软件、数据库软件的损坏，我们会对集群软件和数据库软件做备份，并拷贝到NFS服务器上，方便做恢复。．数据库损坏；到NFS服务器上。4务为了能够保证升级出错以后，可以回退到升级前的状态。我们需S方式。我们找到了一台能够ping通的局域网内网的Linux服务器，把NFS并且这台服务器上事先已经挂载了1T的空间。在服务端修改/etc/exports,加上下列内容/media/_data/(rw)/media/_data/(rw)注意:这个IP地址是Exadata映射出来的IP，不是计算节点的物理IP，必须从服务器端/var/log/messages里面可以看到Exadata客户端发起的请求IP，把请求IP配置到/etc/exports才能配置成功。因为客户在不同网段之间访问设置了防火墙，所以还需要通过配置固定端口进行连通。在服务端修改/etc/sysconfig/nfs,增加如下端口。MOUNTD_PORT="4002"STATD_PORT="4003"LOCKD_TCPPORT="4004"LOCKD_UDPPORT="4004"操作系统上的防火墙全部都要关闭。serviceiptablesoffNFSrpcinfo–p在服务器端执行，查看端口是否正确.showmount–e在服务器端执行能查看到nfs文件系统的信息.showmount-e服务端ip地址在客户端执行能从客户端查看到nfs文件系统的信息.在exadata的两个计算节点上mountNFS文件系统。5务mount-tnfs-orw,intr,soft,proto=tcp,nolock1:/media/_data/root/tar2.备份现有环境NFS行备份Exadata计算节点的操作系统，集群软件、数据库软件及数据库的备份，而我们的存储节点因为可以使用CELLBOOTUSBFlashDrive来进行恢复，所以无2.1备份计算节点操作系统[root@gxx2db01~]#df-hFilesystemSizeUsedAvailUse%Mountedon/dev/mapper/VGExaDb-LVDbSys130G14G15G49%//dev/sda1502M36M441M8%/boot/dev/mapper/VGExaDb-LVDbOra199G55G39G59%/u01tmpfs81G26M81G1%/dev/shm/dev/mapper/datavg-lv_data549G355G166G69%/backupdbfs-dbfs@dbfs:/800G4.9G796G1%/data1:/media/_data985G199M935G1%/root/tarTNFS容量，我们的操作系统存在着两个LV，一个是/dev/mapper/VGExaDb-LVDbSys1和6务/dev/mapper/VGExaDb-LVDbOra1，而datavg-lv-data是我们自己划的用/dev/mapper/VGExaDb-LVDbSys1和/dev/mapper/VGExaDb-LVDbOra1个LV，我们使用下面的备份方式。[root@gxx2db01~]#lvcreate-L1G-s-nroot_snap/dev/VGExaDb/LVDbSys1Logicalvolume"root_snap"created[root@gxx2db01DBSYS_SNAP~]#e2label/dev/VGExaDb/root_snap[root@gxx2db01~]#mkdir/root/mnt[root@gxx2db01~]#mount/root/mnt-text3[root@gxx2db01~]#lvcreate/dev/VGExaDb/LVDbOra1/dev/VGExaDb/root_snap-L5G-s-nu01_snapLogicalvolume"u01_snap"created[root@gxx2db01DBORA_SNAP~]#e2label/dev/VGExaDb/u01_snap[root@gxx2db01~]#mkdir-p/root/mnt/u01[root@gxx2db01~]#mount/dev/VGExaDb/u01_snap/root/mnt/u01-text3[root@gxx2db01~]#df-hFilesystemSizeUsedAvailUse%Mounted7务/dev/mapper/VGExaDb-LVDbSys130G14G15G49%//dev/sda1502M36M441M8%/boot/dev/mapper/VGExaDb-LVDbOra199G55G39G59%/u01tmpfs81G26M81G1%/dev/shm/dev/mapper/datavg-lv_data549G355G166G69%/backupdbfs-dbfs@dbfs:/800G4.9G796G1%/data1:/media/_data985G199M935G1%/root/tar/dev/mapper/VGExaDb-root_snap30G14G15G49%/root/mnt/dev/mapper/VGExaDb-u01_snap99G55G39G59%/root/mnt/u01完上述步骤之后，可以看到多了两个lv，对VGExaDb-LVDbSys1和VGExaDb-LVDbOra1做了一个备份并挂载成了文件系统。接下来我们就可以把我们备份的文件系统tar到NFS上面。[root@gxx2db01~]#cd/root/mnt[root@gxx2db01~]#tar-pjcvf/root/tar/mybackup.tar.bz2*/boot--exclude\tar/mybackup.tar.bz2--exclude/root/tar>\8务/tmp/backup_tar.stdout2>/tmp/backup_tar.stderr做完tar之后可以查看/tmp/backup_tar.stderr文件检查是否有错误。如果无误，我们就可以把刚刚建的文件系统挂载点进行卸载，创[root@gxx2db01~]#cd/[root@gxx2db01~]#umount/root/mnt/u01[root@gxx2db01~]#umount/root/mnt[root@gxx2db01~]#/bin/rm-rf/root/mnt[root@gxx2db01~]#lvremove/dev/VGExaDb/u01_snap[root@gxx2db01~]#lvremove/dev/VGExaDb/root_snap以上操作分别在两个节点进行。2.2备份计算节点数据库是放在计算节点的dbfs文件系统里面的。对于使用RMAN备份的数据库，我们采用下列脚本，把数据备份到了/backup/orcl和/backup/gxypdb下面。我们只需要把备份出的文件夹拷贝到NFS目录下即可完成对数据库的备份，而对于exp的备份，我们也只需要把exportORACLE_SID=orcl2source/home/oracle/.bash_profile$ORACLE_HOME/bin/rmanlog=/backup/log/full_`9务+%Y%m%d%H%M`.log<<EOFconnecttarget/{#BackupDatabasefullBACKUPSKIPINACCESSIBLETAGhot_db_bk_levelFORMAT'/backup/orcl/bk_s%s_p%p_t%T'INCLUDECURRENTCONTROLFILE;}{#BackupArchivedLogssql'altersystemarchivelogcurrent';changearchivelogallcrosscheck;BACKUPFORMAT'/backup/orcl/ar_s%s_p%p_t%T'ARCHIVELOGALL;#ControlfilebackupBACKUP务FORMAT'/backup/orcl/cf_s%s_p%p_t%T'CURRENTCONTROLFILE;}deletenopromptarchiveloguntiltime"sysdate-5";crosscheckbackup;deleteforcenopromptexpiredbackup;allocatechannelformaintenancetypedisk;deleteforcenopromptobsoletedevicetypedisk;listbackupsummary;exit;[root@gxx2db01~]#cp-rp/backup/orcl//root/tar[root@gxx2db01~]#cp-rp/backup/gxypdb//root/tar[root@gxx2db01~]#cp–rp/data/*.dmp/root/tar2.3备份计算节点集群软件和数据库软件备份计算节点集群软件和数据库软件，主要是为了防止安装的Patch出现不可预知的错误，方便我们能够进行回退。此操作最好是要先停止掉数据库软件和GI软件。[oracle@gxx2db01~]$srvctlstopinstance–iorcl1–dorcl[oracle@gxx2db01~]$srvctlstopinstance–iorcl2–dorcl[oracle@gxx2db01~]$srvctlstopinstance–igxypdb1–务gxypdb[oracle@gxx2db01~]$srvctlstopinstance–igxypdb2–dgxypdb[oracle@gxx2db01~]$srvctlstopinstance–ijjscpd1–djjscpd[oracle@gxx2db01~]$srvctlstopinstance–ijjscpd2–djjscpd[root@gxx2db01~]#/u01/app//grid/bin/crsctlstopcrs-f[root@gxx2db01~]#cd/root/tar[root@gxx2db01~]#tar-cvforaInventory.tar/u01/app/oraInventory[root@gxx2db01~]#tar-cvfgrid.tar/u01/app//grid[root@gxx2db01~]#tar-cvforacle.tar/u01/app/oracle/product//dbhome_12.4备份交换机配置文件OMgxx2db01-ilom18，通过点击Maintenance标签，再选择Backup/Restore的标签，选择Operation为Backup，而Method为Browser,选择完成之后在Passphrase输入密码，点击Run，即可以在浏览器中生成一个XML的备份文件。务1.ResetILOM和重启Exadata的进行升级，升级前最好把整个Exadata重启一次，重启的顺序就是先进入到ILOM管理界面ResetSP，然后停止CELLS节点的服务，重启所有CELLS，重启成功之后，在重启计算节点。客户的Exadata总共有5个ILOM的管理界面，分别是两台计算节点和要找网络管理员开放端口才可以访问。进入到管理界面选择Maintenance，然后选择ResetSP即可。然后要等一会，就可以重新连接上了。ILOM5台的管理地址如下：gxx2db01-ilom18gxx2db02-ilom19gxx2cel01-ilom26gxx2cel02-ilom27gxx2cel03-ilom28对于存储节点，我们需要先停止掉cells的服务，到每一台cells服务器上运行下列命令：cellcli-ealtercellshutdownservicesall停止成功后检查一下cells的服务是否全部停止成功。cellcli-elistcellattributesmsstatus,cellsrvstatus,rsstatus重启存储节点的主机务等到存储节点重启完成之后，检查cells服务是否成功启动，成功启动则没有问题。此时可以重启计算节点，在前面做软件备份的时候停止了数据库和集群软件，如果没有停止，需要先考虑停止数据库，然后再停止集群软件，再进行计算节点的重启。syncreboot2.检查信任关系为了保证顺畅的升级，需要确保在计算节点能够和存储节点建立安全的信任关系，这里主要是通过SSH来实现的。首先在/tmp下建立一个all_group，配置上两个计算节点和三个存储节点的主机名。然后在建立一个cell_group，配置上三个存储节点的主机名，然后执行下列命令，如果不需要输入密码能够直接显示，则信任关系正常。[root@gxx2db01tmp]#dcli-gall_group-lrootdategxx2db01:SatSepgxx2db02:SatSepgxx2cel01:SatSepgxx2cel02:SatSepgxx2cel03:SatSep612:14:41CST2014612:14:40CST2014612:14:41CST2014612:14:41CST2014612:14:41CST2014[root@gxx2db01tmp]#dcli-gcell_group-lroot'hostname-i'gxx2cel01:gxx2cel02:gxx2cel03:040506如果信任关系有问题，需要使用下列命令，重建信任关系。务ssh-keygen-trsadcli-gcell_group-lroot–k3.升级LSIDiskArrayControllerFirmware安装LSIDISKDiskArrayControllerFirmware可以使用滚动模式和滚动模式。1)把安装介质FW12120140.zip上传到每个cells节点的/tmp目录下.2)解压FW12120140.zip文件.[root@gxx2db01tmp]#unzipFW12120140.zip-d/tmp[root@gxx2db01tmp]#mkdir-p/tmp/firmware[root@gxx2db01tmp]#tar-pjxfFW12120140.tbz-C/tmp/firmware在/tmp/fireware下面应该存在一个这样的文件140_AF2108_FW_Image.rom5ff5650dd92acd4e62530bf72aa9ea833)验证FW12120140.sh脚本#!/bin/kshechodate>/tmp/manual_fw_update.loglogfile=/tmp/manual_fw_update.logHWModel=`dmidecode--stringsystem-product-name|tail-1|sed-e's/[\t]\+$//g;s//_/g'`silicon_ver_lsi_card="`lspci2>/dev/null|grep'RAID'|grepLSI务|awk'{print$NF}'|sed-e's/03)/B2/g;s/05)/B4/g;'`"silicon_ver_lsi_card=`echo$silicon_ver_lsi_card|sed-e's/B2/B4/g'`lsi_card_firmware_file="SUNDiskControllerFirmware_${silicon_ver_lsi_card}"echo$lsi_card_firmware_fileecho"`date'+%F%T'`:Nowupdatingthediskcontrollerfirmware..."|tee-a$logfileecho"`date'+%F%T'`:Nowdisablingcacheofthediskcontroller..."|tee-a$logfilesync/opt/MegaRAID/MegaCli/MegaCli64-AdpCacheFlush-aALL-NoLog|tee-a$logfile/opt/MegaRAID/MegaCli/MegaCli64-LDSetPropWT-Lall-a0-NoLog|tee-a$logfile/opt/MegaRAID/MegaCli/MegaCli64-AdpCacheFlush-aALL-NoLog|tee-a$logfile/opt/MegaRAID/MegaCli/MegaCli64-v|tee-a$logfile/opt/MegaRAID/MegaCli/MegaCli64-AdpFwFlash-f/tmp/firmware/140_AF2108_FW_Image.rom-NoVerChk-a0-Silent-AppLogFile/tmp/manual_fw_update.logif[$?-ne0];务echo"`date'+%F%T'`:[ERROR]FailedtoupdatetheDiskControllerfirmware.Willcontinueanyway..."|tee-a$logfileelseecho"`date'+%F%T'`:[INFO]Diskcontrollerfirmwareupdatecommandcompletedsuccessfully."|tee-a$logfilei700的权限。chmod700/tmp/FW12120140.sh4)停止数据库和CRS[oracle@gxx2db01~]$srvctlstopinstance–iorcl1–dorcl[oracle@gxx2db01~]$srvctlstopinstance–iorcl2–dorcl[oracle@gxx2db01~]$srvctlstopinstance–igxypdb1–dgxypdb[oracle@gxx2db01~]$srvctlstopinstance–igxypdb2–dgxypdb[oracle@gxx2db01~]$srvctlstopinstance–ijjscpd1–djjscpd[oracle@gxx2db01~]$srvctlstopinstance–ijjscpd2–djjscpd[root@gxx2db01~]#/u01/app//grid/bin/crsctlstopcrs–f[root@gxx2db01~]#/u01/app//grid/bin/crsctl务crs5)停止所有存储节点的服务[root@gxx2db01~]#dcli-lroot-gcell_group"cellcli-ealtercellshutdownservicesall"6)创建文件DISABLE_HARDWARE_FIRMWARE_CHECKS[root@gxx2db01~]##dcli-lroot-gcell_group"touch/opt/oracle.cellos/DISABLE_HARDWARE_FIRMWARE_CHECKS"7)禁用exachkcfg服务[root@gxx2db01~]##dcli-lroot-gcell_group"chkconfigexachkcfgoff"8)在cells节点上执行FW12120140.sh脚本[root@gxx2cel01tmp]#/tmp/FW12120140.shSUNDiskControllerFirmware_B42014-09-0611:15:31:Nowupdatingthediskcontrollerfirmware...2014-09-0611:15:31:Nowdisablingcacheofthediskcontroller...CacheFlushissuccessfullydoneonadapter0.ExitCode:0x00SetWritePolicytoWriteThroughonAdapter0,VD0(targetid:0)successSetWritePolicytoWriteThroughonAdapter0,VD1(targetid:务1)successSetWritePolicytoWriteThroughonAdapter0,VD2(targetid:2)successSetWritePolicytoWriteThroughonAdapter0,VD3(targetid:3)successSetWritePolicytoWriteThroughonAdapter0,VD4(targetid:4)successSetWritePolicytoWriteThroughonAdapter0,VD5(targetid:5)successSetWritePolicytoWriteThroughonAdapter0,VD6(targetid:6)successSetWritePolicytoWriteThroughonAdapter0,VD7(targetid:7)successSetWritePolicytoWriteThroughonAdapter0,VD8(targetid:8)successSetWritePolicytoWriteThroughonAdapter0,VD9(targetid:9)successSetWritePolicytoWriteThroughonAdapter0,VD10(targetid:10)successSetWritePolicytoWriteThroughonAdapter0,VD11(targetid:11)successExitCode:0务CacheFlushissuccessfullydoneonadapter0.ExitCode:0x00MegaCLISASRAIDManagementToolVer8.02.21Oct21,2011(c)Copyright2011,LSICorporation,AllRightsReserved.ExitCode:0x0095%Completed2014-09-0611:16:09:[INFO]Diskcontrollerfirmwareupdatecommandcompletedsuccessfully.9)脚本执行成功之后，需要重启，这里需要注意的一点是，需要重启两次。[root@gxx2cel01tmp]#sync[root@gxx2cel01tmp]#shutdown-frnow10)重启完成之后，可以检查LSIMegaRaidDiskControllerFirmware的版本。[root@gxx2cel01~]#/opt/MegaRAID/MegaCli/MegaCli64-AdpAllInfo-a0-NoLog|grep'FWPackageBuild'FWPackageBuild:12.12.0-0079FWVersion:2.120.203-1440CurrentSizeofFWCache:399MB11)升级成功之后，移除文件务DISABLE_HARDWARE_FIRMWARE_CHECKS[root@gxx2cel01~]#dcli-lroot-gcell_group"rm-fr/opt/oracle.cellos/DISABLE_HARDWARE_FIRMWARE_CHECKS"12)开启exachkcfg服务[root@gxx2cel01~]#dcli-lroot-gcell_group"chkconfigexachkcfgon"13)查看cells服务状态[root@gxx2cel01~]#dcli-lroot-gcell_group"cellcli-elistcellattributesmsstatus,cellsrvstatus,rsstatus"runningrunningrunning从第5步，开始重复上面的步骤在其他存储节点上运行。等所有节点都完成之后，并且验证是有效的LSIMegaRaidDiskControllerFirmware，重启整个存储节点的服务。点升级存储节点的IMAGE之前，需要对环境做check。这里选择使用计算节点作为主要操作对象。1.检查各个cells节点之间root用户的安全信任关系[root@gxx2db01tmp]#dcli-gall_group-lrootdategxx2db01:SatSep612:14:41CST2014gxx2db02:SatSep612:14:40CST2014务gxx2cel01:SatSepgxxgxx2cel01:SatSepgxx2cel02:SatSepgxx2cel03:SatSep612:14:41CST2014612:14:41CST2014[root@gxx2db01tmp]#dcli-gcell_group-lroot'hostname-i'gxx2cel01:gxx2cel02:gxx2cel03:0405062.检测磁盘组属性disk_repair_time配置[grid@gxx2db02~]$sqlplus/assysasmSQL*Plus:Release.0ProductiononSatSep612:20:142014Copyright(c)1982,2011,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease.0-64bitProductionWiththeRealApplicationClustersandAutomaticStorageManagementoptionsSQL>select,a.valuefromv$asm_diskgroupdg,v$asm_attributeawheredg.group_number=a.group_numberand='disk_repair_time';NAMEVALUE------------务DATA_GXX2DBFS_DGRECO_GXX23.6h3.6h3.6h这里的时间是3.6个小时，修改这个主要是为了避免升级过程中达到缺省的3.6小时后在cell节点执行删除griddisk的操作。如果发生删除了griddisk的情况，那么，需要升级完成后手工添加这些磁盘组。这里先把它修改成24个小时吧。SQL>alterdiskgroupDATA_GXX2setattribute'disk_repair_time'='24h';Diskgroupaltered.SQL>alterdiskgroupDBFS_DGsetattribute'disk_repair_time'='24h';Diskgroupaltered.SQL>alterdiskgroupRECO_GXX2setattribute'disk_repair_time'='24h';Diskgroupaltered.SQL>select,a.valuefromv$asm_diskgroupdg,v$asm_attributeawheredg.group_number=a.group_numberand='disk_repair_time';NAMEVALUE------------务DATA_GXX2DBFS_DGRECO_GXX224h24h24h3.检查操作系统的内核版本root@gxx2db01tmp]#dcli-gall_group-lroot'uname-a'gxx2db01:Linux2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64x86_64x86_64GNU/Linuxgxx2db02:Linux2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64x86_64x86_64GNU/Linuxgxx2cel01:Linux2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64x86_64x86_64GNU/Linuxgxx2cel02:Linux2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64x86_64x86_64GNU/Linuxgxx2cel03:Linux2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64x86_64x86_64GNU/L务4.检查操作系统版本[root@gxx2db01tmp]#dcli-gall_group-lroot'cat/etc/oracle-release'gxx2db01:OracleLinuxServerrelease5.7gxx2db02:OracleLinuxServerrelease5.7gxx2cel01:OracleLinuxServerrelease5.7gxx2cel02:OracleLinuxServerrelease5.7gxx2cel03:OracleLinuxServerrelease5.75.检查IMAGE版本[root@gxx2db01tmp]#dcli-gall_group-lroot'imageinfo'gxx2db01:gxx2db01:Kernelversion:2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64gxx2db01:Imageversion:.0.120304gxx2db01:Imageactivated:2002-05-0322:47:44+0800gxx2db01:Imagestatus:successgxx2db01:Systempartitionondevice:/dev/mapper/VGExaDb-LVDbSys1gxx2db01:gxx2db02:gxx2db02:Kernelversion:2.6.18-2.1.el5#1SMPT务Feb919:07:16EST2012x86_64gxx2db02:Imageversion:.0.120304gxx2db02:Imageactivated:2012-05-0311:29:41+0800gxx2db02:Imagestatus:successgxx2db02:Systempartitionondevice:/dev/mapper/VGExaDb-LVDbSys1gxx2db02:gxx2cel01:gxx2cel01:Kernelversion:2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64gxx2cel01:Cellversion:OSS_.0_LINUX.X64_120304gxx2cel01:Cellrpmversion:cell-.0_LINUX.X64_120304-1gxx2cel01:gxx2cel01:Activeimageversion:.0.120304gxx2cel01:Activeimageactivated:2012-05-0303:00:13-0700gxx2cel01:Activeimagestatus:successgxx2cel01:Activesystempartitionondevice:/dev/md6gxx2cel01:Activesoftwarepartitionondevice:/dev/md8gxx2cel01:gxx2cel01:Inpartitionrollback:Impossiblegxx2cel01:务gxx2cel01:Cellbootusbpartition:/dev/sdm1gxx2cel01:Cellbootusbversion:.0.120304gxx2cel01:gxx2cel01:Inactiveimageversion:.5.110815gxx2cel01:Inactiveimageactivated:2011-10-1916:15:42-0700gxx2cel01:Inactiveimagestatus:successgxx2cel01:Inactivesystempartitionondevice:/dev/md5gxx2cel01:Inactivesoftwarepartitionondevice:/dev/md7gxx2cel01:gxx2cel01:Bootareahasrollbackarchivefortheversion:.5.110815gxx2cel01:Rollbacktotheinactivepartitions:Possiblegxx2cel02:gxx2cel02:Kernelversion:2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64gxx2cel02:Cellversion:OSS_.0_LINUX.X64_120304gxx2cel02:Cellrpmversion:cell-.0_LINUX.X64_120304-1gxx2cel02:gxx2cel02:Activeimageversion:.0.120304gxx2cel02:Activeimageactivated:2012-05-0302:59:52-0700务gxx2cel02:Activeimagestatus:successgxx2cel02:Activesystempartitionondevice:/dev/md6gxx2cel02:Activesoftwarepartitionondevice:/dev/md8gxx2cel02:gxx2cel02:Inpartitionrollback:Impossiblegxx2cel02:gxx2cel02:Cellbootusbpartition:/dev/sdm1gxx2cel02:Cellbootusbversion:.0.120304gxx2cel02:gxx2cel02:Inactiveimageversion:.5.110815gxx2cel02:Inactiveimageactivated:2011-10-1916:26:30-0700gxx2cel02:Inactiveimagestatus:successgxx2cel02:Inactivesystempartitionondevice:/dev/md5gxx2cel02:Inactivesoftwarepartitionondevice:/dev/md7gxx2cel02:gxx2cel02:Bootareahasrollbackarchivefortheversion:.5.110815gxx2cel02:Rollbacktotheinactivepartitions:Possiblegxx2cel03:gxx2cel03:Kernelversion:2.6.18-2.1.el5#1SMPThuFeb919:07:16EST2012x86_64务gxx2cel03:Cellversion:OSS_.0_LINUX.X64_120304gxx2cel03:Cellrpmversion:cell-.0_LINUX.X64_120304-1gxx2cel03:gxx2cel03:Activeimageversion:.0.120304gxx2cel03:Activeimageactivated:2012-05-0302:58:38-0700gxx2cel03:Activeimagestatus:successgxx2cel03:Activesystempartitionondevice:/dev/md6gxx2cel03:Activesoftwarepartitionondevice:/dev/md8gxx2cel03:gxx2cel03:Inpartitionrollback:Impossiblegxx2cel03:gxx2cel03:Cellbootusbpartition:/dev/sdm1gxx2cel03:Cellbootusbversion:.0.120304gxx2cel03:gxx2cel03:Inactiveimageversion:.5.110815gxx2cel03:Inactiveimageactivated:2011-10-1916:26:59-0700gxx2cel03:Inactiveimagestatus:successgxx2cel03:Inactivesystempartitionondevice:/dev/md5gxx2cel03:Inactivesoftwarepartitionondevice:/dev/md7gxx2cel03:务gxx2cel03:Bootareahasrollbackarchivefortheversion:.5.110815gxx2cel03:Rollbacktotheinactivepartitions:Possible[root@gxx2db01tmp]#dcli-gall_group-lroot'imagehistory'gxx2db01:Versiongxx2db01:Imageactivation22:47:44+0800gxx2db01:Imagingmodegxx2db01:Imagingstatusgxx2db01:gxx2db02:Versiongxx2db02:Imageactivation11:29:41+0800gxx2db02:Imagingmodegxx2db02:Imagingstatusgxx2db02:gxx2cel01:Versiongxx2cel01:Imageactivation16:15:42-0700gxx2cel01:Imagingmodegxx2cel01:Imagingstatusgxx2cel01:datedatedate:.0.120304:2002-05-03:fresh:success:.0.120304:2012-05-03:fresh:success:.5.110815:2011-10-19:fresh:务:.0.120304date:.0.120304date:2012-05-03gxx2cel01:Imageactivation03:00:13-0700:outofpartitiongxx2:outofpartitionupgrade:successgxx2cel01:Imaging:successgxx2cel01::.5.110815date:.5.110815date:2011-10-19gxx2cel02:Imageactivation16:26:30-0700:fresh:successgxx2cel:fresh:successgxx2cel02:Imagingstatusgxx2cel02::.0.120304date:.0.120304date:2012-05-03gxx2cel02:Imageactivation02:59:52-0700:outofpartitiongxx2:outofpartitionupgrade:successgxx2cel02:Imaging:successgxx2cel02::.5.110815date:.5.110815date:2011-10-19gxx2cel03:Image务16:26:59-0700gxx2cel03:Imagingmode:freshgxx2cel03:Imagingstatus:successgxx2cel03:gxx2cel03:Version:.0.120304gxx2cel03:Imageactivationdate:2012-05-0302:58:38-0700gxx2cel03:Imagingmode:outofpartitionupgradegxx2cel03:Imagingstatus:successgxx2cel03:[root@gxx2db01tmp]#dcli-gall_group-lroot'rpm-qa|grepofa'gxx2db01:ofa-2.6.18-2.1.el5-1.5.1-4.0.58gxx2db02:ofa-2.6.18-2.1.el5-1.5.1-4.0.58gxx2cel01:ofa-2.6.18-2.1.el5-1.5.1-4.0.58gxx2cel02:ofa-2.6.18-2.1.el5-1.5.1-4.0.58gxx2cel03:ofa-2.6.18-2.1.el5-1.5.1-4.0.587.检查硬件设备务[root@gxx2db01tmp]#dcli-gall_group-lroot'dmidecode-ssystem-product-name'gxx2db01:SUNFIREX4170M2SERVERgxx2db02:SUNFIREX4170M2SERVERgxx2cel01:SUNFIREX4270M2SERVERgxx2cel02:SUNFIREX4270M2SERVERgxx2cel03:SUNFIREX4270M2SERVER8.检查cells节点的日志gxx2cel01:362014-08-29T08:54:27+08:00testtrap"gxx2cel02:40_12014-08-28T20:01:24+08:00fowarning"Thisisa"OracleExadataStorageServerfailedtoauto-createcelldiskandgriddisksonthenewlyinsertedphysicaldisk.PhysicalDisk:20:4Status:normalManufacturer:SEAGATEModelNumber:ST360057SSUN600GSize:600GSerialNumber:E4CK7VFirmware:0B25SlotNumber:4"gxx2cel02:412014-08-29T08:54:04+08:00info"Thisisatesttrap"gxx2cel03:务27_32014-08-13T18:28:11+08:00clear"Harddiskreplaced.Status:NORMALManufacturer:HITACHIModelNumber:HUS1560SCSUN600GSize:600GSerialNumber:K7UL6NFirmware:A700SlotNumber:11CellDisk:CD_11_gxx2cel03GridDisk:DATA_GXX2_CD_11_gxx2cel03,RECO_GXX2_CD_11_gxx2cel03,DBFS_DG_CD_11_gxx2cel03"gxx2cel03:282014-08-29T08:54:43+08:00info"Thisisatesttrap"9.检查是否存在offline的grid盘[root@gxx2db01tmp]#dcli-gcell_group-lroot"cellcli-e"LISTGRIDDISKATTRIBUTESnameWHEREasmdeactivationoutcome!='Yes'""10.验证cell节点网络配置信息与cell.conf保持一致[root@gxx2db01tmp]#dcli-gcell_group-lroot/opt/oracle.cellos/ipconf-verifygxx2cel01:VerifyingofExadataconfigurationfile/opt/oracle.cellos/cell.confgxx2cel01:Done.Configurationfile/opt/oracle.cellos/务passedallverificationchecksgxx2cel02:VerifyingofExadataconfigurationfile/opt/oracle.cellos/cell.confgxx2cel02:Done.Configurationfile/opt/oracle.cellos/cell.confpassedallverificationchecksgxx2cel03:VerifyingofExadataconfigurationfile/opt/oracle.cellos/cell.confgxx2cel03:Done.Configurationfile/opt/oracle.cellos/cell.confpassedallverificationchecks11.停止CRS和存储节点的服务[root@gxx2db01tmp]dcli-gdbs_group-lroot"/u01/app//grid/bin/crsctlstopcrs-f"[root@gxx2db01tmp]dcli-gdbs_group-lroot"ps-ef|grepd.bin"[root@gxx2db01tmp]dcli-gcell_group-lroot"cellcli-ealtercellshutdownservicesall"12.解压安装介质和解压插件[root@gxx2db01ExaImage]#unzipp16278923_112330_Linux-x86-64.zip[root@gxx2db01ExaImage]#unzip-务patch_.0.131014.1/plugins/p17938410_112330_Linux-x86-64.zip-xReadme.txt[root@gxx2db01ExaImage]#chmod+xpatch_.0.131014.1/plugins/*13.清理之前patchmgr运行后的环境[root@gxx2db01patch_.0.131014.1]#./patchmgr-cells/tmp/cell_group-reset_force2014-09-0613:48:44+0800DONE:reset_force[root@gxx2db01patch_.0.131014.1]#./patchmgr-cells/tmp/cell_group-cleanup2014-09-0613:49:51+0800DONE:Cleanup14.预安装检查[root@gxx2db01patch_.0.131014.1]#./patchmgr-cells/tmp/cell_group-patch_check_prereq2014-09-0614:27:26+0800:Working:DO:Checkcellshavesshequivalenceforrootuser.Upto10secondspercell...2014-09-0614:27:27+0800:SUCCESS:DONE:Checkcellshavesshequivalenceforrootuser.2014-09-0614:27:27+0800:Working:DO:Initializefiles,checkspaceandstateofcellservices.Upto1minute...务2014-09-0614:27:49+0800:SUCCESS:DONE:Initializefiles,checkspaceandstateofcellservices.2014-09-0614:27:49+0800:Working:DO:Copy,extractprerequisitecheckarchivetocells.Ifrequiredstartmd11mismatchedpartnersizecorrection.Upto40minutes...2014-09-0614:28:17+0800Waitcorrectionofdegradedmd11duetomdpartnersizemismatch.Upto30minutes.2014-09-0614:28:18+0800:SUCCESS:D