OracleOEM配置数据库监控方法

1、Oracle OEM 配置数据库监控邮件通知、配置通知方法1.在OEM主页点击右上方的单中 Notification MehodsSetup链接进人 Setup页面，在 Setup页面点击左边菜链接，配置参数Outgoing Mail（SMTP） Server、IdentifySender As、Sender's E-mail Address。其中 Outgoing Mail(SMTP) Server 参数为发送 邮件的邮件服务器地址， Identify Sender As参数为发件人别名， Sender's E-mailAddress参数为发件人邮件地址。ORACLE Ent

2、er|irise IU a mag er IQq Canlra lSet 叩 P 阳心 BHCGS： H 邱 LCQDLtDai abaseSetupNodffcation MethocfsNotificalion MelhodsP丽匚hing SetiipBlackoutgMamgement Pack2.NnErlitalion也tk allow you to globally d电fin巨 diH由白枇 mechanisms for sending nolifieaticin. These includee-mail. SNMP traps and running cuslom scrip

3、ts. Once definsd, lhese methods can then b used with Nolrfication Rules fgr sending nolrfications to atlmimslraters as a result of alert occurrences Each administratcir has Notilicalion Rules： defined m弓 a preference.Mail ServerOutgoing Mail (SMTP) ServerZJ-MAILD1 Specify ane or g若 server name; sear

4、arted 的 a eentrria gr sr配专Idenlrfy Sender AsIZJOADBSender's E-mail AddressllilianjiaRavgri)【Apply)The informalion below is needed before Enterprise Manage can send e-rnsil nolideations by means <Notification Rules.Scripts and SNMP TrapsAdd | OS Conimarid'Select HrneTypeNo notification met

5、hods found.® TFP Remember to creale Notilication Rules m order to send naiificsticins by means of these methodsBefor& ErM 自 rpri 白巨fan 自自 nd notrficlian by m 白号 n 玄 of OS eflmrnand4H PUSOL procedure-s, ttrSNMP traps, you noed to first dating ihem as methods. Any adminislrsitor can then us l

6、hese methods in Notificalion Rules如佰&才吴 | Sehip | P常Fmuhm | H.lp | Lciguijt Copyfight ©193B, 200B( Oracle. All reserved.四性洞 口陆已灯End印口rig史Mara口er 1g 口artla龄巳Corti心（图1）配置完成后点击 Test Mail Server进行测试，测试成功应返回如（图2）结果，然后点击OK，回到配置页面点击 Apply应用配置。SetLU Pr刖&rences He 口 Log口Dai abaseTest ResultsZJ4M

7、AHLO: Test succeeded - You will also need io verify fliat a let! «-mall has b«en received by IillanjlaORACLE' Entcr|irisc Ms mag er 10g Database Ccniroll口就血能 | 洞口 | F1检伯囱网9 i| H.0 | Lagut Copyright ©1996. 2006( Ovele. All reserved.皿匚I Da 口CfflTH(图2)二、配置邮件通知接收人1.点击页面右上方 Preferences

8、链接进入Preferences页面，在General页面中配置需要接收通知的人员的邮件地址，配置完成后可以点击Test按钮进行测试，测试成功的情况下配置的所有被通知人员都会收到一封测试邮件。DatabaseDathasc ConlrcilPreferencesGeneralPrgfeNd CirpdErili 日IeNotrli cationR腿胸辿！BGeneralPasswordTo change your password! specify and confirm a new pa$wprdAdministrato r SYSTEMPas$wrdConfirm PasswordReven

9、 . ApplyjE-mail AddressesTheseare used Ed send notili cations to you. You can specify muhiple addresses if you want tobe nofiified in different ways, and the (oimat lo use (or each address. Later an, you will need ta define 号 Nolrfication Schedule before any e-mail notifications can be sen! to you.R

10、emove心.回yud3pQngLong Fnrrn凯由回lil诘nj谄口 wking camLoriLi Formal v0liangronghuizking. comLang Formal vEglgcl All | S时 1便冬 Non旧EmME AddressMess<ige For marAdd ArlQlll理 Rsw)if TIP Refr Lo on-line help forformal garTipleReven) >M3piy)Daftabmsis | Smu | 画mck | H自Ip | Lagw(图3)三、配置邮件通知Schedule1. 在Prefer

11、ences页面点击左边 Schedule链接, 是将不同时段的通知信息发送给不同的人员， 的。此处点击 Edit Schedule Definition 按钮, 好。进入Schedule配置页面，该配置作用我个人理解是用在多人轮班的情况下将所有时段接收通知的邮件地址都填ORACLE iEnlsrpriEe MnogBir 10g 却Ojofi qI肿genc? Huy，1 口叩 D我i都电Notification ScheduleNgHlic 就 ionRulesScheduleYou need to sei up your nidiftcalien schedule in arifer lo

12、 fceive e-maii nificartions for alertt For $ach day in 1he Schedin, specif 1he e-mail addne&ses that: sfioiM be used to send you notHications.或L腿叫急；旦h Schedule DgfinlilQn)Adminfstrator SYSTEMSuspend Natific ation H ch呻 Edit)Ro1 alien Frequency 1 Week Curnsnl Week 1View Week Ccmining6.2009 H Go)&

13、#163;j.3fnaE：OctH12M2inM凯聘 lime 加瞻 *rth EmW AddressesiH indicans Suspended NoirficihMA|ii & 2m Apt网9 Apn 8，加的灿 i 9- 2009 Api 10,街呻用ji 11.2049 A|ji 12.网的Mon<lay, Tuesday Wed'ikeaday Thuisilay Fiidiiy Saturday SuiMlay 12:04 -niri ingronghui.liMjr/nqhui伊z. 1话恤如|回;：.1旧1叩口1匝 诵eI囱gn0li伞.i肿钏】他11

14、阿£., limwcmghuiM.ItOO -nm 旧riigrnwhu鄢e, li吊到匚山刊卜皿唇旧.li珂？5例瞄;:1旧19河血 诵笔lianwtngh埠叩，.的】7叫布鄢" lianp/nghuiigz:.,Bini GFiqrci叫hi伯ie. liwgnqhui挣l . I旧叫慰口快注仍邙宅limnpcThL!i§Ji：. 1临币卬叮可埠!三一 而时曰的川尊匚.li日4匚血”如扁任. 3；il<i .nn ngfonjtmjQtL liwpE叫hui物.Il时叩nghuh敢 liripciRphi卿己 |加日1叩"i® ” l

15、iBnigrciriphi鄢二 li日中口叩卜如切. I:IHI .iiiii川叫口叫111用1 r后可原哩削暗I旧叫向叫hi碗Wliengi门qMnjgH们叫口叩川_1耶r1旧口里顷驴1崛i!|：1 -.HiliW印口nqhu顿 F1旧.叩："电卜叫晾7晦坚li iriyi口叫也成!？1啊叩nphw境？Mirl印口r呻心建i£liHr；gE，iiqhui后! J. M linkMl顷顷iilFiLi疝IEliarnj物口hm囱1削狎商山晦ZliMim由北L疱Fh日rwhi&.MiiWiu咨;：liar山rEiqhui咨#?：iKi unigrghLi颜eI佰网r口

16、ghui国m丽顿叨赋的曲I旧旧饵闻怔.商eI佰nwcimihwii屈顿口皿仙即.I佰mrsqhui/a8:(Kl -inn mriMndhu国. li囹rpghui质了 . liafiQronjahuifiSw . hariqrQWihLli-grughiijS" . ©iwciijiihui_L lianiii口nqhuitS；工.ti：-00 in i!anaronnhuiE. li-iw口ncihui:z:. . I福H(3Kin£ahuiw. hmMmqgbufllL |通110£11/1如11-工 haMIQQShuiZ. Iiaiwcmcih

17、iji:z. WjM in Mpnmhu却l. lime；口mjhuiiig旧.I前9顷5仍敢.IiwIil 豆".liGngru叫h昭四.慵ngroMhu而e. liang顽ghu呕h . 11;-04 -nin 局典1口讷11 豚ie. liMMEjhuiigT . 1话兴门昨讪敢.1旧19勺丁也诵三.1浦1皿口119卜环四.而ngfighu耶 己.lia咽nghuiigiz:. 12;0fl phi闻上.liwgnph崛亍.丽兴，啷讪敢 .liTripcTph淄!匕 li孙. h啷啷川既泣li冲匚血加|豆" 归网inn吊时口口加咬耻 1|冲口叩丽挣 h眦叩理川邮宅.1

18、|.?1叩|口5*旧 I旧nqr叩ph陪I ” Mnigwhi-itfg二li日npr-nphui伽 ?：n<l |im日门印匚仃叫卜心电;rI旧呵Enphuii!Ii-ri印叩phi略望li jnqrMphL卿H1旧呵叩仙 此初1期四叫硕印rli，npiTEphiJi尊【?i：IHI |iii|i而四叫加禽E1谄1项EihuHgH1知印如印山爆咔1|"1忡叫血拿(liangUiriQhs蹶？hm印口叫的晦£liSgEnphm®】iJi'U |> in.wgicirMii面;rligrc»ghui®|34狎愈山而£

19、harmrcmhL疝! fiiMCirui-i口h出iiST屈n口i口mFiuiS”lianwwiQhm日! i（图4）四、配置通知规则1. 在Preferences页面点击左边 Rule链接，进入通知规则配置页面，点击Create按钮创建通知规则。SelUP 巨血6：:司 Heto LogoU.DarabaseORACLE' Eiilnrprl Mikiijrir 1ftg 0atab35« ControlPreferencesGpgmlNotification RulesEfflfenad Crsirjni ；iI：m NplifkaimriNodrficlMin rul

20、E allowmi io gIicimb ihe Esrgd$ smd coRditions for whkh jeuwaM toeceire nettestians Ikmn fRewEft、 皿匚, ErH目啊甜 Manager. Thefr nuifitione include e-fliM, SNMP traps awl njniwng custom七方“rPP3JCrefflaJ Asglgri MBimcds 1心 Mulrlplw lule勺)RuPbe-,Creaie Like)泮理"曲§)七丫昭)Edij *电1啤)轴|心倾IU口5。|PuhlirAjgg

21、gti UnreachablESYShrtANSystem-gerier-aledalien rule far rnonit由tig Agents who contactwith the Management Seftice due ta ietodk problems, hosl problems or Agenls going downEoDatabase AvailBhilrt and CrH就ml SLalaaSYSMANSstem-generaled noilfaalien rule fcr mDfiit&ring Databases' avaability and

22、ciitic al metric BCalusm.B0HdF A：Tailtnlitr andSYSWXNSfEtern-genBrsled ncrlriicsrliDn njle 防monitofnng Ho&ls' si相il那ility and diticil mslncEloUmj 辛伯弟 AvadabiligSYSMANSystem-generled nul血almn 叫1华 for mgit面dalba; Usln* aailBbilrty and critical melric gtaluses.Bo尚如Lm ErwSYSTEMAJert Eg Errar回o.电

23、Ll泌SYSTEMSYS LoginBoc菰加HimSYSTEMCache Hit(%)Zo旧 R绑QuruE Uma蚱SYSTEMDB Resdufcg Usage0oElim 血 Irwalkl 口川回SYSTEMError and 1祠id objed:回o论宾匪muK、H拘asmSYSTEMHost Resourc-E UsageEo心朝明SYSTEMIO StatusZoLiElBuw ActionSYSTEMSystem-generarted nolAcalion rule for monitDring dalabae Lisleners' lability and cri

24、tical medric Btsluse?.0o由奕D4ES L.启洲SYSTEMTabletipaces Ltsae0（图5）2.配置通知规则的过程分为7个步骤：1） 配置属性：配置 Name、Description、Target Type。Target Type 分为 Agent、Database Instance、Host、Listener 4 种。监控指标为数据库指标选择Database Instance,主机指标选择 Host, Listener的事件选择ListeneroDatabase ControlSetupPreferences HeHPreferencesORACLE En

25、lcriprise Manager 10Piop«iii Targets： Availabilihf Uelr|c$0bj 就 1$Methods MoreCreate Notification Rule: Properties亡 CancaQ Slep 1 of? | Neap Name TESTDescription TESTEJMake PublicAlkivs other adhwiistrcrfars to let er spediy thotihev shoiid rccerv? e-mwl for 1his rule. Target Type Database Inst

26、ance ,*® Apply rule to all 暗 oflhe target type GelectodSelectng Itis 仙on wll cause you to sfep the Targets 玳知.O Apply rule 1q specified largely,CanceQ Step 1 of? N聊）公七双睫 1 8即即 | Preferences I Htetp | 1 叫口|1Copyright ©l&SGOe, Orscaa. AJI ritfts reserved.AbM Enlf tarlx OciDatbaEwYcinlral

27、（图6）2）配置通知的可用状态Sdun Prefercrices LDcroutDatabaseORACLE" Enlea pulse Munidgef 10g Database ConlrolAvailiilMlity Metrics Objects Memo ds More*ncel） . Ear传 | Slep 3 tj（7 | N的i） Up0DownH Age nt UnreachableFhe agen 冷 unreechabie 山牛 to net州oris p 0 Agent Unreachable Reaolved fhe flgeni is now raachai

28、ale. The cufrenfl tc s by checttng ins aplion. Melric Error Del actedAn error occurred duririihe ev-eiuaiicn of OMelric Error Re soiledFhe error drtectsd durrg the： -cvalLMton of Blackout Smarted Blackout Ended3）Create Notification Rule: AvailabilitySelect the availmhility stes for which you would l

29、ike to recerve notificalions. You will receive nolrfications when there is a transition from another state to the selected state.obiems, orcr host unmiiaMHv ceieffiiringlargel $telu$ 1$ rwt possibleget status will be nclutfed in the notiliDfltnn mesiagE. The。响 wwy to receive twgfft slakhE fllttr on

30、Aga nt UhreacTiabte slate日必ila涧vIci/qH wisieibilt was rssced.kCameeQ Back | Step 3 of?归竺）均法bmse | 3补甲 | Piefeielites I H哪 I I 项"©opyrighl: & 199艮 2006 Oracle;. AJI ritghts reseryiej.Abai OwdiB EnflgirKiriEe Mjnsaar Go Oat启b.seContKri（图7）配置规则包含的指标以及需要发出通知的警告级别Seluu Pri?1erenc55 明口 Logou

31、t at酣M但ORACLE Enilrpri#口 Manaqief IDq CariUalPreferences. m* Metrics Objecls Mefrioda MoreCreate Notification Rule; MetricsStreet <lh metrics and thsir severrtiBS for which you would like Ed receive nolificatians.Canc&jgiT| Slp 4 of 7 Na)a|Severity StatesSelect the seerrt states for which you

32、 would like to receive notification.S Criticali/Vaming ClesrMetricsSeverity s1a1e$ apply to all selected metritsAvailable MetricsS«hct«d Metric?Archive Area Used (%)Archiver Hung Alert Log ErrorArchiver Hung Alert Log Error Status Audited UserAverage File Read Time (centi-seconds) Average

33、File Wrrte Time (cenli-seconds) Average Users Waiting Count SG Chechpoints (per second) Slocking Session CounlBranch Node Spirts (per second)Mgi»-吊帽All逐)a苗 TIP You will skip the Objecls si ep if none of lhe selecled metncs could hwe objectsTablespace Free Space (MB)Tablespace Free Space (MH) (d

34、ictionaryTablespace Space Used (%)3El) EacT Step 4 M7 | Nek?)4)配置通知规则需要发出通知的对象(图8)Create Notification Rule: ObjectsCancejj Back | St&p 5 of 7 Nexi jEach of these metrics monitor a sei of objects within yotir ilargets. You can choose to be natified (or all ar for a subset of objects monitored by

35、the rnetric.Mfrlrk0b|ec1sTablespace Free Space (M6)® All Objects (Tablespace Name)O SelectTablespace Free Space (MB) (dictionary managed)® All Objects Tablespace Name)Q SelectTablespace S网共 Used (%)® All Objects (Tablespace Name)O SelectTablespace Space Used (%) (dictionary managed)&#

36、174; All Objects (Tablespace Name)O Spied.Cancaf) Back | Step 5 of 7 Next口血b河日 洞mp | H日Ip | 皿硕Copyrigihl Q19QB, 20DBi Or3de. AJI rights reservedOrBdr! FidurEiri%廿"或1日事1匚口 口对日上巾:心 匚ni find（图9）5）配置通知规则使用的通知方法，此处勾选Send Me E-mail使用邮件通知ORACLE Enterprise Manaqer 10 Database ControlPreferencesMAttiof-

37、to ReviewCreate Notification Rule: MethodsCcanceQBack | SiepQ of 7 | Next)Specify lh« noEideation methods thal should be Lulled v4ien m&lric seyerities are met.E-mail Not me aton.t! Send Me E-mailE-mail messages wrll be 巽nt art trues- Sfjecired on your natJllcsEn schedulB.Advanced Notificat

38、ion MethodsNJiineTypeDescriplian心Melhod to RirieNo notificafion mathoefs found.Cancel) (Back | :r-p A pf7 : Nwki)| Swtim | Prctferenews- I I LuciquI Copynghl 12Q0B( Orde. All ights reMtved.也.UtLt匚T孕二IB也史宾I 1口| 口此乱|弟白匚CifTrCd（图 10）6） 最后Review之前的配置信息，点击Finish完成配置SigKin Preferences Hdu LonotiORACZLC Fn

39、lEiprisn 怙彳nager DlabaSfl CcrdrulPreferencesReviewCreate Notification Rule: ReviewThis summarizes, how and whan Emerprise Manager will send ruolrfications for this rule.CanceQ (Back | Stsp 7 of7 (Finish)PropertiesNameOwnerDescnplionPublic Target TypeTESTSYSTEMTESTYe-sDnljhds* liTStiinc略TargetsAll ta

40、rgets of type Database InstamceAvailabilityNoY&sYe*YesUpDownAgent UnreachabfeAgent Unreachable Resolv&d(图 11)五、设置合适的告警阀值1. 进入OEM首页（图12）,点击页面下方的 Manage Metric链接（图13）,进人Manage Metric 页面（图 14）ORACLE Enlrprise Manager IDgSeluu Pi由erxAS H日lu LogoutLogged in As SYSTEMDatabase Instance: zjoadbHeme

41、拽血m町成 巴4011响倒|有 MaintenanceActive Sessions8.0SOL Response Time Wait口 Baseline is empty.4.0成他Reseit 瞄eline：)2.0-l.cev0.0GeneralHostCPU2vStiutdown j100Sfiafius 曲75Up Since Feb 12, 2009 10:33:M AM CSTra5hwIns-tame Name 邛omllM zjoadbVersion 10点一0.3.025Host WAD&0Lister USTENEF?_ZJ-QU口日00Matimum CPU 5

42、Load Q.QIJ Paging UDOPage Refreshed Apr 6, 2009 5:0$:17 PM职就弓h) Mew 口artAuiomstic础丫 旧0 知。Diagnostic SummarySpace SummaryHigh AvailabilityADDMnatattm噩 Size (GB)8.439Instance Recovery Tim日(s-ec) 5FindingsAll Policy 洌都何乌3 BNn nPA.Problem°Table spacg?Last Backup商g 湖951:36 AMUsabile Flas-h Recovery

43、Ar&a (%) CQSegment A(hi$or Q? nriminnan rl shin n-crFlashback Lagging 5 -，lMigwAILPrjQpertJQi；(图 12)Hom的 PErfwE&rsi；8 四dminishHliun早FianceRelated Links四日¥世口。耳前旧1Akri HiUtiryAJed Lg CuriErdAll Melfits目 I"kuut3iSCVPIusJobsMeir 低Metric：EmuaMonMoririQ 0削仰口溯肿Mcmilor in 雄匹。叫 Access ModeS

44、QL History4今自卜口血丽独对衅sDnMhekse | 钮LU£ I PferfereM：* | Hel。| 3t Cop,rl寅i © 伯96),次陀 I Crade All rits reserved.皿buul Oracle： ErtlruriE匕 Manaciur 10a partabasE Curtkcil(图 13)ORACLE Ehterpri1 M-AniSQBrDgFreliarGn。登 HeloDlabas Cia nlflD3Eab-3$6口削店公夸由 Instanciec ajitiatlbi > Manage MetricsManage Metrics、Edit Thr£Hnici£Pending change