資源oracle運維故事李真旭云和服務(wù)交付總經(jīng)理

關(guān)于我李真 云和恩墨西區(qū)服務(wù)交付總經(jīng)?名Roger，近10年的OracleACOUG核?2014年被授予OracleACE ACOUG和數(shù)據(jù)庫? 者； 參與翻譯《ExportOracleRAC； ：oPhone:云和恩墨國內(nèi)綜合數(shù)據(jù)服OracleACE總監(jiān)，OracleACE，SQL?賽冠軍，以及數(shù)OCM專家，同時具備MySQL和DB2 OracleRACSatOct0816:14:10IPCSendtimeoutdetected.Sender:ospid11292[oracle@xxxx Receiver:inst1 ospidSatOct0816:14:35IPCSendtimeoutdetected.Sender:ospid11278[oracle@xxxx(LMD0)]Receiver:inst1binc ospid11388IPCSendtimeoutto1.0inc10formsgtype65518fromopidSatOct0816:14:51IPCSendtimeoutdetected.Sender:ospid11270[oracle@xxxx Receiver:inst1 ospidSatOct0816:14:59DetectedaninconsistentinstancemembershipbyinstanceEvictinginstance1from進程的作用是什么LMD進程的作用是什OracleRac腦裂機制的判斷SatOct0816:14:59DetectedaninconsistentinstancemembershipbyinstanceErrorsinfile/u01/../xxxx1lmon11382.trc ORA-29740:evictedbyinstancenumber2,groupincarnationdetailsin:/u01/../xxxx1lmon11382i363695.trcUseADRCIorSupportWorkbenchtopackagethe SeeNote411.1atMyOracleSupportforerrorandpackagingErrorsinfile/u01/../xxxx1lmonORA-29740:evictedbyinstancenumber2,groupincarnationLMON(ospid:11382):terminatingtheinstanceduetoerror[ora10g@~]$oerrora29740,00000,"evictedbymember%s,groupincarnation//*Cause:Thismemberwasevictedfromthegroupbyanothermemberof clusterdatabaseforoneofseveralreasons,which includeacommunicationserrorinthecluster,failureto aheartbeattothecontrolfile,//*Action:Checkthetracefilesofotheractiveinstancesinthe groupforindicationsoferrorsthatcausedaIPCSendtimeout網(wǎng)絡(luò)問題造成丟包或通訊異主機資源（CPU、內(nèi)存、I/O等）問題導(dǎo)致進程無法響OracleBUG(例如OracleDRM的一些xxdb1netstat16.10.08.1600.dat:zzz***SatOct816:10:09CST2016xxdb1netstat16.10.08.1600.dat: 19535packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:11:09CST2016xxdb1netstat16.10.08.1600.dat: 25890packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:12:09CST2016xxdb1netstat16.10.08.1600.dat: 33085packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:13:09CST2016xxdb1netstat16.10.08.1600.dat: 41839packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:14:09CST2016xxdb1netstat16.10.08.1600.dat: 52560packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:15:09CST2016xxdb1netstat16.10.08.1600.dat: 61970packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:16:09CST2016xxdb1netstat16.10.08.1600.dat: 62215packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:17:09CST2016xxdb1netstat16.10.08.1600.dat: 63082packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:18:09CST2016xxdb1netstat16.10.08.1600.dat: 64273packetreassemblesfailedxxdb1netstat16.10.08.1600.dat:zzz***SatOct816:19:09CST2016xxdb1netstat16.10.08.1600.dat: 65436packetreassemblesfailed關(guān)于LinuxIPpacketreassemblesfailed使用Jumbo-high-low-計 High>=numcpus*sizeof(packetreassemblyRHEL6.6:IPCSendtimeout/nodeevictionetcwithhighpacketreassemblesfailurTheCRSDisintermediatestateandnotjoiningtotheclusterfragmentsdroppedaftertimeoutgccrblockSID469947184720520952205239

BLOCKING_SESSION 4718ckbx663tb92mcenq:TX-rowlockcontention5239ckbx663tb92mcenq:TX-rowlockcontention4718ckbx663tb92mcenq:TX-rowlockcontention4718ckbx663tb92mcenq:TX-rowlock7jaq6ay3qppwuSQL*Netmoredata4718ckbx663tb92mcenq:TX-rowlockCycleCycle1:<cnode/sid/sesssrno/procptr/ospid/waitevent> /enq:TX-rowlock-- /enq:TX-rowlockupdateUPDATEUPDATEEVENTSET =:VALUE+GIVENVALUE=:GIVENVALUE,VERSIONID=:VERSIONIDWHEREEVENTAGGRID=:EVENTAGGRRowSource02EVENTAGGR(cr=6pr=0pw=0time=456INDEXUNIQUESCANPKEVENTAGGR12H(cr=6pr=0pw=0time=8610046trace000000000ElapsedtimesincludewaitingonfollowingEventwaited

Max.WaitTotalSQL*NetmessagetoSQL*Netmessagefromdbfilesequentialread

gccurrentgrant2-latch:KCLgcelement1Javatestoracle@xx:/home/oracle/enmo$java-cp.:classes12.zip135.xx.xx.xx:1521:billxxbillxxUsage:java-cp.:classes12.zioTestBatchip:port:SIDusercommitSize346155252525000rowsupdatedin8326000rowsupdatedin5827000rowsupdatedin5728000rowsupdatedin6829000rowsupdatedin77allrowsupdatedin2069UPDATEEVENTSET