AIX环境下RAC巡检文档

一、操作系统查看1>查看操作系统（AIX文献系统与否合理方式:"df-m,查看全部的文献系统大小与否>$df-MBMounted/55如果不是，需要修改正小的使用命令smittychfs->change/showcharacteristicofanenhancedJournaledFile二、操作系统查看2>查看操作系统与否打齐补丁(oslevel-sinstfix-i)方式：“oslevel–s或insfix–i|grep#oslevel-s#instfix-i|grepAllfilesetsfor_AIX_MLwerefound.Allfilesetsfor5300-01_AIX_MLwerefound.Allfilesetsfor5300-02_AIX_MLwerefound.Allfilesetsfor5300-03_AIX_MLwerefound.Allfilesetsfor5300-04_AIX_MLwerefound.Allfilesetsfor5300-05_AIX_MLwerefound.Allfilesetsfor5300-06_AIX_MLwereNotallfilesetsfor5300-07_AIX_MLwerefound.Notallfilesetsfor5300-08_AIX_MLwerefound.Notallfilesetsfor5300-09_AIX_MLwerefound.Notallfilesetsfor5300-10_AIX_MLwere#oslevel-5300-06-12-如果不是，则查看到现在版本需要哪些补丁包（oslevel–rl5300-10，并通过smittyinstallp来升oslevel-rl5300-三、操作系统查看3>查看操作系统的rootvg与否做了mirror("lsvg-lrootvg")，查看LPS和PPS是不是1对2的关系方式：“lsvg-lrootvg”#lsvg-lrootvgLV PVsLV MOUNT1111111881/11111881如果不是1对2的关系(例如上面的列子)，而主机的本地磁盘有2块以上，则需要做rootvg的mirror像#smitty rootvg，hdisk1中/usr/sbin/extendvg‘rootvg’按图中所示选择，将hdisk1加入到rootvg中，按回车#smittymirrorvg #bosboot–adhdisk1 将启动扇区写入hdisk1#bootlist–mnormalrmt0cd0hdisk0hdisk1 将hdisk1加入启动序列 到此镜像完毕两块硬盘将同时工作互为镜像四、操作系统查看4、查看bootlist方式:“#bootlist-mnormal–o”查看是不是包含了镜像的两块本地硬盘#bootlist-mnormal-ohdisk0blv=hd5hdisk1Diag->taskselection->displayorchange五、操作系统查看5、查看AIX参（查看文献系统内存占用的份额规定，如果oracle采用裸设备方式存储文献，则文献系统内存分派比nmon查看内存的属着重关注，Min/Maxperm部分,这一块代表文献系统内存能够占用的部分，建议内存为5(min)-10(max)留给文献系统。minperm%=22%给文献内存用1.4G归档，ftp#vmo-r -ominperm%=5#vmo-r -omaxclient%=10#vmo-r -omaxperm%=10六、操作系统查看6、查看pagespace与否符合规定,"lsattr-Elmem0""lsps-方式：(lsdev–Ccmemory,lssattr–Elmem0,lsps-a)#lsdev-CcL2cache0AvailableL2Cache AvailableMemory#lsattr-El (goodsize16384AmountofusablephysicalmemoryinMbytesFalse 16384TotalamountofphysicalmemoryinMbytes如果内存<2G,建议pagespace为内存的两#lsps–a（pagesize大小PageSpace PhysicalVolume VolumeGroup Size%UsedActiveAutoType 如果和预期不同，尝试修改pagesizePagingSpace#smitty选择Paging选择Change/ShowCharacteristicsofaPaging选择NUMBERofadditionallogicalpartitions：60PagingSpace8GB#lsps-Physical Size%Used 七、操作系统查看 方式:#SystemModel:IBM,8204-E8AMachineSerialNumber:06976B5ProcessorType:PowerPC_POWER6(powerpower6)ProcessorImplementationMode:POWER6ProcessorVersion:NumberOfProcessors:4（CPUcore4个，即2个双核的物理CPU）ProcessorClockSpeed:3503MHz（CPU主频3.5G）CPUType:64-KernelType:64-bit（64位）LPARInfo:1zzrac1MemorySize:16384MB（内存大小16G）GoodMemorySize:16384MBPlatformFirmwarelevel:EL350_049FirmwareVersion:IBM,EL350_049ConsoleLogin:enableAutoRestart:trueFullCore:falseNetworkHostName:IPAddress:SubNetmask:Gateway:NameDomainPagingSpaceTotalPagingSpace:8192MBPercentUsed:1%VolumeGroupsPVTOTALFREEFREE0516-010:Volumegroupmustbevariedon;usevaryonvg0516-010:Volumegroupmustbevariedon;usevaryonvgPVTOTALFREEFREE1INSTALLEDRESOURCEThefollowingresourcesareinstalledonthe+/-=AddedordeletedfromResource =Diagnosticsupportnot如何和产品不符，咨询厂家实际状况并修复问题（八、操作系统查看办法：”more/etc/environment”类似成果#more/etc/environment#@(#)181.25src/bos/etc/environment/environment,cmdsh,bos53A,a_35B68/23/0404:13:11##Thisisanautomaticallygeneratedprolog.#bos53Asrc/bos/etc/environment/environment1.25#LicensedMaterials-PropertyofIBM#(C)COPYRIGHTInternationalBusinessMachinesCorp.1989,1994#AllRightsReserved##USGovernmentUsersRestrictedRights-Use,duplication#disclosurerestrictedbyGSAADPScheduleContractwithIBMCorp.#IBM_PROLOG_END_TAG#COMPONENT_NAME:(CMDSH)Shellrelatedcommands#ORIGINS:27#(C)COPYRIGHTInternationalBusinessMachinesCorp.1989,1994#AllRightsReserved#LicensedMaterials-PropertyofIBM#USGovernmentUsersRestrictedRights-Use,duplication#disclosurerestrictedbyGSAADPScheduleContractwithIBMCorp.#Systemwideenvironmentfile.Thisfileshouldonlycontain 1.commentlineswhichhavea#inthefirstcolumn, 2.blanklines, 3.Linesintheformname=value.#WARNING:Thisfileisonlyforestablishingenvironmentvariables. Executionofcommandsfromthisfileoranylinesother thanspecifiedabovemaycausefailureoftheinitialization ##SearchingthecurrentdirectorylastisusuallyaBIGtime#If/usr/ucbisatthebeginningofthePATHtheBSDversionof

#befound.LCFASTMSG=true#ODMroutinesuseODMDIRtodeterminewhichobjectstooperateon#thedefaultis/etc/objrepos-thisiswherethedeviceobjects#reside,whicharerequiredforhardwareconfiguration解决办法若时区不是”BEIST-8”，则通过smittychtz改时区（改完时区之后需要重启才干生效Smittychtz->UseDAYLIGHTSAVINGSTIME?(选择no)->CUT(CoordinatedUniversalTime)TimeZone(选择”(BEIST-8)PeoplesRep.China (CUT+8)”)九、操作系统查看检查rac两节点与否时间同时，用“date”命令查看（首先确认时区要一致）结论，若不同时，通过smittydate改时间十、数据库查询数据库版本检查，与否为最新:检查数据库版本和crs的版本与否打到最新():办法:"sqlplus-version"，查看software版"crsctlquerycrssoftwareversion"查看crs版$sqlplus-SQL*Plus:Release.0–Production#crsctlquerycrssoftwareversionCRSsoftwareversiononnode[zzrac1]is2>、升级raccrs3>、升级oraclesoftware5>十一、数据库查询（数据文献如果采用裸设备的方式）检查与否数据库文献关闭了自动扩展（建议关闭自动扩展)（方案:使用toad检查问价系统状态ALTERDATABASETEMPFILE'/dev/rrac_temp_2G'AUTOEXTEND十二、数据库查询#lsvg-lLVLVMOUNT44144188188188188188188111111111221221221221查看pp大小（1个pp大小为#lsvgVOLUMEVGVGPP256VGTOTAL6143(1572608MAXFREE5951(1523456USED192(49152OPEN2TOTAL1VG2STALE0STALE0ACTIVE1AUTO Auto-Concurrent:DisabledVGMode: NodeID: ActiveNodes:MAXPPsperVG: MAXPPsper MAX LTGsize(Dynamic):1024 AUTO HOTSPARE: BBPOLICY: 因此rac_temp_2G能够扩展到如果没有扩展到适应大小，用下面命令：（确认lv大小ALTERDATABASETEMPFILE'/dev/rrac_temp_2G'RESIZE十三、数据库查询rac两个节点与否做了时间同时方式1>“lssrc-ls2>查看同时的时间间隔#xntpdc-c#lssrc-lsProgramname: Leapindicator: 00(Noleapsecondtoday.)Syspeer: Sys Sys - Rootdistance: Rootdispersion:Reference Referencetime: Sun,Jun27 Broadcastdelay:0.003906(sec)Authdelay: 0.000122(sec)Systemflags: pllmonitorfilegenSystemuptime: 2980(sec)Clockstability:0.000000(sec)Clockfrequency:0.000000(sec)Peer:flags:(configured)(refclock)(syspeer) 3,version:3ourmode:client,hismode:次节点的状况#lssrc-lsProgramname: Leapindicator: 00(Noleapsecondtoday.)Syspeer: Sys Sysprecision: Rootdistance: 0.000305Rootdispersion:Reference Referencetime: Sun,Jun27 Broadcastdelay:0.003906(sec)Authdelay: 0.000122(sec)Systemflags: pllmonitorfilegenSystemuptime: 2529(sec)Clockstability:0.000000(sec)Clockfrequency:0.000000(sec)Peer:flags:(configured)(syspeer) 4,version:3ourmode:client,hismode:如果问题无法解决，配备时间服务器的过程以下AIXxntpd是有关网络时间合同的守护进程，它遵照了因特网时间服务器的通用原则。在启动xntpd时,xntpd/etc/ntp.confntp时钟不能相差超出1000秒。若有不小于1000xntpddatantpdate命令调节本机的系统时间，使偏移量在1000秒之内。然后启动xntpd.构造一种NTP编辑/etc/ntp.confserverdriftfile/etc/ntp.drifttracefile编辑好/etc/ntp.conf后,启动xntpd#startsrc-s也可通过调用smittyxntpd#smittyxntpdxntpd状态查询,使用#lssrc-ls刚启动xntpdsyspeer'insane',xntpd#lssrc-lsxntpdProgramname:--/usr/sbin/xntpd Leapindicator:11(Leapindicatorisinsane.)Syspeer:nopeer