ÿØÿà JFIF    ÿÛ „ !.%+&8&+/1555$;@;4?.451 4,$,44444444444414444444444444444444444444444444444444ÿÀ  á á" ÿÄ     ÿÄ ?    !1AQaq"2‘¡±ÁðBRbrÑá#‚’¢²3S CñÿÄ   ÿÄ !    !1QAa‘2ÿÚ   ? 5˜Z¯V¦cø)›t/? z¨±>Õ5€¶‹Á¤·¼z¼Ü¬+ñ®v¤¨_ˆR­BFn©—˜ý®ç̝P8gýt·ÉSTŦˆìät?þé¼íìN/Þa)ì–í6ô… Ï¿øÃj´¿KÇü]ÿ ªô¹-eKànëÕHTx}ýSÜ›ÿ ”7Ø×&µ<¦  ¥ÑO¶[Ù¯ä¨ÞÃÿ PZ-¬;#õ|•oaÿ ©CìÞz3˜öː/¤­ñTûIØ}š^ mÓ%ªxˆ¥ÉŸu=Z+ISe¿45™¼u;ú&WØ÷€æßQ™®{|íx*TC“#ZŠìZ§²‹ 6pv…³¿¡äª*áZÐ%ÒOáˆo"x«OHk w±æ+¬V(kMúŸ5Vö«$ ÁrÏbàb57/luR ¸ÑÛj Òµì`Ðœq­û žICÀÊ•©4€Âcà¨Ï€O´<èÐ:›ù(Ë^L8þ‘ÍÌ#¸Ð_Ì©ÙK(Öz 4¬û+¸;ü’V’84‘¬ÃŽ:[â‡ÔÌáõp¢~§ªlæ£ö{®G>J¼"°‡7¯ÆÉèßû ‹É‹§ÁòÃýâßî ^ƾÙõ‹×óH#«LP½ïX=xÑÍ$|W?•~• îëÔ©ª‹ {ÝT…Kÿ ”hûâá)J*ö˜–ÔU;iÇ€/ ÆþjóZ\ýwØ=Ìm ºèËL9 ýèÆð/¨’¥öo=nË.%Îì ŽÕ¯È|{Oj²ƒE6e/ßdÄõ²Ìâ1O®ò×TsəԸhOMýíMˆ¿¼H˜l²,7Â¥#MF/Úf°Ö½± ¸–dr‹NýÊ íjqx{œÉ ä-È ¦ øÄër¨q°ð †nцýÑÄÆ’mä…n<0È™;ÁÝá¯ÁZƒ7FÀmì­ É&9ˆîéi¶ùN§Y• ÃZãAâ?•‡©‰ , ó¾IŸŠc1 4â&y­&pŠ­6;M À 0¹qç»p.á …ŸÅáK@%6·y6ƒ‰3?”úºŽ‰éX5ªPT §µ!=Mž«Ú½‹ÅgÂSâÉaþÓoö–¯ÁÔìR>5éÿ üs¶ÆUcÌ kÇR ]ÿ ù¬¼«VŽ;Â|‡~¢¦”ÏÅ°æ {L™Õ°Óv¹ò¸írŽ¡×¢CÃ!íVÕ {¶»sŒNPg/ "uÕbkm²“$ďå¿é¹§°½æz¯6 †s¿!s–wÚÝ“™Œ °.ûj>·+™Òa…©Œ&rÝÎtÛë긪Ît’LAVp%c Úý[ÄzJ¾ÇàXXç@˜ó<êL]·T˜¾¥1Ó©V‡g´æ½¦Ý@¹óø!_@´ÞâSÁ —S3™•& ]@JHÚý©ZŽ €×æÔr»Áf!‡yÞ4Mv*èÓã_{‘åóUuљØ«Oïé*®EvÑ Œ÷‡U \"㪒ÍK+À 4“M¡ï:0¥5í!'<@î´”>Ç»&Z–ïCCV˜Ì5Šo&îhè.žû |ÓK©h$s6KìŒëã)¹hI¦GïOåóI;ììü#É$Š0…Ææ¥TØ.5­¾gn´ “ÂÖ\:hœ89G)J@„}œ:’Ò{/Š"¦_Æ×7Æ3VÇŠÊa]ÚŒÙ€Ä–=®uÁßâACZƒ§§£ Qnâ:«,×{tyø¬iÛcœÜÄ€H½ÄÍCk´÷šß .W'b¤Íåh]÷€=,Žv×cÚEÚHXJX¶îo¨FÒtèöŸ>ªª6[J®Fµ£sGÁeqõfe\íjÒÐïÄÐGˆe1Ø‹.Ø”‘Ëuø Y­ˆÜ ŽG|zùªüMpDnQWÄ”%JŠ™)â*p@Örš«ÕT2Ð%ˆG#ª„ ·¤!°ŸOTÂT¸aÚ%4&h™LµšØüÐ.F¿²ÐÞ_Ç‚¾ÅÃaÜ÷09Æ q€öy˜v‡85õN÷]¬äѼóS{°_MŽ¬úÔ#°Ç¸0åÞè2ëôPcvÆw9®ií1Ä8F™˜à‰´+‰Ik1òÝ7“Ñ×ÒsÝ\x‚h`ÞÑ`ó"|µEcý£n˜h`}GÞ !±ù²Ápü²ß6 0ïi󜵩SÈÇ7˜-ÕURO˜¦´f$ªž-Í6(œ}<„ éc øs]ŽŽ„*—¾ ìdŽ„)méª\¿êÎIg¾ØÞ~I#C/¼¼´EÁÈŽi8“©õådô·>euä ƒ'Ê×लR1ÉJE1ÐAát`t;ÇР%Ý<‡¥„ÍÆ`×Oyó)õiI€ñQaŸ4Ûù\áàaÃÔ¹HÃu¹*k€¦<„e S‡&õÏ B!ŽhüÞ`yj}mªf×\¿ Ç~æ­9‡û\՞Ǖg²1Žû5V7 !àöšm° c`ܬøÇìµÒ'P"?…´Ö,"§^•õŽ¨sÔ)6˜sæéÍR¼ ò|Sl”‹7 nPW Gòú÷½§O¯‡„l¡kSÞŒr½PÊ@æ¢pŽ-mÿ #Ÿ˜Àº¶Áä¦;ïÔæ$1££`“Õ>„—·ž)ßð³ñ#Ï Ô$¶œ‰ÊE‹À;÷º ¯«P:Ñ”8–IÊtpÞ3ª“>ê“þës4ò2OÏÕ­±zô†Õ§‰.÷ä¸;¿˜“'œ›žª}«Œ{ª±Ì 9ÔóÞÕ‡0 $íWV3Üì¬ —@kÝ4@¿r¼±½¬™›?øØæ´'Áé®CË3-g$˜ö‡×auÚi´Žp/êÛ æF›Ú2v‹ã¿¿,nB1̨ƃqÞa5͝@&Æû“él÷ \C²½UÍc ¯k×¢U ÖéQå™—-r wô ÞÏ<Ò=&=ÿ Ôê Òêˈt,i—;LîÜ á¸*ÚÃ1$êL•LÍ <É)ýÐà’ ;F™{ƒ™˜€&'}‚ãÄK`¡ÞT@I;®žZóè‚s’7®°›+§O­Åq©é»²9<Ô J ¼9O’HL»Ùïì¸rk¼Ž_ý‘TŸu[²ßÚŒ·ü÷B%¯E ŸÔX5êO´ Ç•€’I0 ÉJX` ñ¹õ%;µŸD‘«´€àwÒ™U ûئžÖö\×®×´8 ½‡ºÐÆÓ§?Àkmœ=;d5*@-ì0F Rªýš[Ü6âö̃ڸr*KA9· u*µæ£?U¸Âêí†8@¦X4 e-ò„0s{ HâUpU?¼mñRa°®a%Ð'tÉ×’\¾ÊÉ]t›h>·(Ë@R¼¡Ãt h}’O÷au<+nT…Ö…MӐ??Óe95 q>í/;&JSû °¯ÊéÞ øƒ*Ã2½Ài&:nôUl=¾¿5eˆ3”ñc|Ú2V”>„»&eE;«ÚäC p¢Û úy 9š[ŒÌx¼擼A&DåÒ¯ˆ¤ÀÌ;"˜ ÏQä¸åhÊ}Ûq«Û0WžÒ|»€ø®öCm5•\ÇÀ§Pe3£]0ÃàLDÉ‰1øªxjgwT‚÷¿LΨK‹›ùs—xˆÜ±µ kæ¸f‰‰ÜGk/LÛØ6d9ò¶ùA{ƒA3š/¬D¬khÓk‰`˜"㯒r¿±Óã jx‡°e}<Ñø\3y:'À•/h½Í€Ç4~g ?Û(¼]v‘ªlKÎâ~?O‚W%{Ì:“'©úNq¾›úo(X’¥¯ˆ nFê{Ç€ü?º'ë ø‹ì Þ09ŒÌç9Æ —ËC`j@ÓÄ(+a‹un¸#ÂꟋ{K`‘ÑÍÍ'à´»/Û,KW;Þ4²þð ï Nm|~fGÏ(…³Ã)«1ö­Õ ¥‡¨©ƒÃ™ü-s=à=U66Ï«Ýc蓦W¹íž®›nÔ%êÇìŒ<#Ü×84ån®Ð ÒåOC` ñânÑs‡¢ç 1õ%Îhì½Ã½® e:ݼUZo™`  ÅZŸŒÊ«ê1ÏÄo$q¹Þ€©ˆhÐÉä¯ñ[!…Ú˜àJ:x2$Íß&PåT£6ç— ‡Í*4Ýšçjÿ ‰É nófÐ ó(L5C•åÆ\rMÒ@ò }y-W}™üýVù—ú¢=Ù”c®‘< M ž ´Phr ¦©TD ‘ù.$´÷O‡‘V2Æò.=IUŒ=ž‡â¬i™aþÓåÙ?òUø'ØÖ•.~* šTŒ!•-×áºTâ®ä#õü'´ eýlYÅÓeÕKÂrT"CÚ@u!Óxƒ{š3€}1¿(r}%«nËamjÑ%ÑNEò v ˜à  σöK³,*º.àzù¨™Ó ÚçâU¦*¿ 9{%Ö¹ njûdaXöb) kÛƱûÓ\°M7ˆÂ=û›ç¿Ã‚­V»Cg–8ÙêE- j)k$º`Ã-ùEýeBÆÇ]c¡°ñty&Òd0nõ'¡W+ƒ*|–øµFa\GQªEAÔp5\Ǽ·¼Ç8·õ -â§Ú[ ‡ uZeÖ 3}×d'+¹:ð+K†Û®s!Ï$úe€<Û”x)1»a­¡LC]¸µík…ÚàA»AYº{†ªS[¦5HÒ7ù --,ísòDØ€èk ÞÀîÜ ò@â( ËNˆë›4ô½•/¦o‡€Û7 ê•ÆêòðÜy'Án½µ á˜ݦ ndeo…[ì¶Ê,¥R³Ä=À±—–ß;£™´ñSâ*g§”ïaið‘Jå~™ÓÞ ß³Õ¢»8x埒²52>AÊb&-÷\7´éÄù€T˜,w;3{ï˜k…à¹ÄqÀ«œ{€\ ˆ¾[´¨јr &Úé„Ívˆ±8†¿]|¬ņ4I×pÞS1ÈÖz‰#Ìv‡G!YNògñ:màTz¢Ý1ô©^O=~ë|5Bã™ç•¼µõ•bÆ@úÕS¬ÈŒ#¬zünrŸ û” Z²•ï›èðV"ÁHÚý©wÝ €7¼Ìu1hÑa3Éä û f$o¿É ™Ú›ÝçnpÒ3äÌ3†Í§,Äï]$‰/pê †«À¼¸e9­Æê_C]žƒ·ý·frÁN«, E=›Çq -‰öŒ:aÏ¿±í&£Í:-} 84‘ÿ eƒQÑeëSsuiA ³g㟥ú£?ÿ ʼn*”“÷aühe:ÊWa@ÒÞk±eØ] F Ô—r.åä˜ @ö¥ªZoÐýYL·¥S²G/‡ñ <~*ZÆ´è>JlòàÛƽÿ 窘ìGN¢:I®KšJp/`íIÁÀõ#Ä-€ö­šµŒoF4|ÆQØÆ@Ì|£Ô…¢À{9˜è½Üó›€ôYÒÎYsið;ís¤€à²ˆ‚4qÉVŒI$ ‰"° æµ8cXGjœˏ¡Aâý•ËÜ¢ûï e·çLx']á"oÅÎê3¯Ç—¹”ó0nå‚âg{Œñ> S´˜îè°g238‚ãköÝfÚd´6Ò€;ò÷±¢™¼›º ¢Æ'¥Ðx'e¬ç ]bÈÆV¢ó‹kýBO ðÊâ$Ÿ!×T 3Mýמ žìٍàÌü‘8÷€àæØ8æ©6‰©L´«…oãpð„~Çk‰!ñ;‹”ÛžÍ àž±z Ÿôû øŸÝužÏ;ÿ #|u6™Þ¬ÚˆÐõA4¶â|ôl|Ê2ŽÇ¤ÝÅÇY.<#Aí.k§hóF‚”Y; M½Ö4hŸ4&›­¿tès´%FìL¥£Ãk‰ÇT¤haÁ¤ÚxfÉ`ÑìË›>i 3t‚:,–+^÷´–{Û–Nxi"x‘Ûg î¨>¥Õ܁ùZH,2Û“:8xÊ¢Çí9.É-Ìâã-=çjwµS˜dütžçwýGòú®®ûº_ˆýx$–¡ãøO EÚÛÏ÷R„×w+3£Á£öUMyR²¹âŒ°š›¸Ñãò9§Ó_Dl+Ùßc›úšGÅÌc†Ž!Ko=¶.‘Îÿ c²(2®V mª.ÿ ¹B›¹å ù„öŸSV>™ü¯$y:G¢Z×àøúdî¹û­·ýÇ´:•c LÍõi_‹ö+ÎæGÊè>OŠ•äž´§Þ{X}¨1ÚTc›»Qþ•êô°t¿OP?eæ~É{5]•ÙR£r5†nZ\ã@ &îJõ ¾àC°þV>fé¥/ü5ñÊIº_é5 ;e­h<@ Ä&æÃëE%;X,ÒãÆÞ`Oò¦kŸm#˜!ÀyÄ¢| óLšò¥Ä` ¶R=|ÈCâh5ò3DˆïF†ðÒ#ÅìÛœ?¸yhBãœí ZxßÎÄhºRK„`Þödvײ™ÀÈÑÒgŒuY w³%†ƒÓzõ ÖÏp‚dH®¦A´ù§»ÓÇMæ~)ˆð‡û:ù&Ä •vGD´À n ݇¼Ö8Fö óáà£~Ë¥x`oK|Ä?fxiØü%pìR>éò+Û±éÎ>núlFŤ'tq8LZÏvÃ?„¡ß±È⽆¯³íü@x|PöUäèØã¡ð‚ŒAìÏ"vÍwóŸÍ{ ý0.z È•Ö{,N¡£¡ŸKÕÙž>Ýœþ ÍÀ°<×EA!Å‚D™IúOÍ¡>ôG}Â` ÍßkÜL™Ž Þð™ {IøF²¹òQ3&!ÃÂÞz.d&Ï-sH¸,Ôõ˜ŽP€ 77ˆÝ¼ÊëÜw =cÕ Ú,ØÐ5ÎYÐ)ì´öœgŒ[¤ßv㙑8心>h]§µháYš£²ºÑ.{Ï7Sð•?´~×SÃKýJÛ˜ ™Íäiúu<µX¶1õ^kâçIÑ£sZ4h>j*ÔšD:4­¿_ ÷¸ Õxæÿ ¸?Mù _•­ÊÐ ä ÷ý ÑwL œ­ïnTkÛUÍN©ë:¦fV ¶ÜÔÜMªÅâA½–¿R×TXš-%iTÊT•‡Ù‚JôϐZxWÑè‰f‰òG º ×Õû2aZ7OU3[“×AT–ÞŒ…-‘¤”Ì ì&(ˆ¿­•ƒkï’:ðY¦W‘ Å)“†‘˜³Åtcø˜ñTÂwÚÇ4|üLÇªí–v- qˆèU qPE.†â‘˜µ Æ,ÐÅs]8¾„oúÑ i>ÜxxÈó)ƒ ´æÁâØ$À‰vžŸf$Ž |ãw;ÀÁIJ»b` {¦Ó¤Ú$©YÀ‘n@Óïž«9J¼êG m¤ ܯ¹ÌW4€ÐÒÅÛ‡#褕Ÿn-?í|с¥÷Ú¹¬'´ÞÜ9ÓK `hê£SÄSà?7—Wí_´…óB›»:=Ãïq`<8ñÓŒÑlú2d¬ê³£hÖ[l|$vÝro~'R®‰§°ñmY ͧäP |PUª¹·:3Œ[Û{Xÿ ºâ@‚W–Äé u‚ ¯´*=íή.pûÒdt @G‰¬ s¸ ëÉücr ÞæѨÊ@>¤¢Ö±. Þ'¯°ÌME[YéïĵÂCå½ Ué©Áû'Ê9%eÔðNU”ë‘ÌsD3/®+UI˜9h.WC”빓$#:pz:YÓ ¿xž* ³$Í +$kñAŠ‹†¢ Uê>¸)_š¬÷©ßAÂÔb9ÇU ¯¾á•9¯ÏÏ÷O÷¼¼Fähal1‰3Ì[Ïr•´UCksNÐ] R‘¸¥H+§Šé†c©vÖÞ0iÓ76s†î!§=ß ¼~Ô'°Ãmäoäš³ªøi1úÉ)³yV8 CLÄØÁ‘WYïi€H6ÖÑiámø^ÈY´°Ñ7¥Û*—Ñ©L«Qƒï—Ùrÿ ›£Ð*š¸ˆL©ˆ$ˆ ÷¾D§9È®«qbqC)–ˆïv´çñsÑVT­Ø, <àïºÀO«Jý·õ àfPìð .wFšir´þ’2_Y *Æ€x\« ì€9š@ Ž|F⇥ˆkZ@hÖÄ0t¿-<“‹qµ¾*ZL¤Ú)&BJpÓF5=$„at*Zš$’ÑtdûÝRI1 2Ž‰$€$I$#‰SÞ’Hë¬ï;Á$¡t$’`<(ñÇt)$‡Ð.Êf¢X’Kt=Éé$‚ˆªè¢oÝëòI%Rgcª÷ŠyI%¡‰ÿ !ñ)´õ $¤ Ô’IIGÿÙ""" FortiMonitor Monitoring Agent Oracle Database Plugin Copyright 2023 Fortinet, Inc. All Rights Reserved. fm-ops@fortinet.com To Configure: The following configuration options need to be set under the [oracle] block in the agent configuration file: - oracle_home - ORACLE_HOME value that points to the local database installation - oracle_sid - name of the database instance to be used for connections - username - username for user that the agent should use when connecting to the database - password - password for user that the agent should use when connecting to the database - tns_listener_ip (optional) - IP address that the TNS listenener service is running on The user that will be used by the agent needs the following permission grants to fully operate: GRANT CREATE SESSION TO ; GRANT SELECT ON dba_data_files TO ; GRANT SELECT ON dba_segments TO ; GRANT SELECT ON dba_free_space, v$resource_limit to ; GRANT SELECT ON v_$resource_limit to ; """ import agent_util import os import os.path import tempfile from agent_util import float import logging logger = logging.getLogger(__name__) tablespace_query = """select b.tablespace_name, tbs_size SizeMb, a.free_space FreeMb from (select tablespace_name, round(sum(bytes)/1024/1024 ,2) as free_space from dba_free_space group by tablespace_name) a, (select tablespace_name, sum(bytes)/1024/1024 as tbs_size from dba_data_files group by tablespace_name) b where a.tablespace_name(+)=b.tablespace_name; """ resource_query = """select resource_name, current_utilization, max_utilization from v$resource_limit;""" def execute_query(sid, config, query, tnsname=None): "Run an Oracle query via sqlplus and parse the results" # Generate a temporary file for the query script (file, filename) = tempfile.mkstemp() orig_filename = filename filename += ".sql" f = open(filename, "w") f.write("set pages 1000;\nset linesize 1000;\n %s\nquit;" % query) f.close() # Build the SQL*PLUS command and call it global_vars = "LD_LIBRARY_PATH=%s/lib ORACLE_HOME=%s ORACLE_SID=%s " % ( config["oracle_home"], config["oracle_home"], sid, ) command = os.path.join(config.get("oracle_home"), "bin", "sqlplus") command_format = " -S %s/" command_arguments = (config.get("username"), config.get("password"), filename) command_format += '\\"%s\\"' if tnsname: command_format += "@%s" command_arguments = ( config.get("username"), config.get("password"), tnsname, filename, ) elif config.get("rds_end_point"): command_format += "@//%s:1521/orcl" command_arguments = ( config.get("username"), config.get("password"), config.get("rds_end_point"), filename, ) command_format += " @%s" cmd = global_vars + command + command_format % command_arguments status, output = agent_util.execute_command(cmd, timeout=10) # Remove our temporary file os.remove(filename) os.remove(orig_filename) # Parse the output results = [] lines = output.strip().split("\n") columns = lines[0].lower().split() for line in lines[2:]: line = line.strip() if not line: continue if line.endswith("rows selected."): continue values = line.split() results.append(dict(zip(columns, values))) return results class OraclePlugin(agent_util.Plugin): textkey = "oracle" label = "Oracle" @classmethod def get_metadata(self, config): status = agent_util.SUPPORTED msg = None # Make sure they provided an oracle configuration block if not config: self.log.info("No oracle configuration block found") return {} # Check to see if Oracle block has been setup in the configuration file - if not, no op if not ( "oracle_home" in config and "oracle_sid" in config and "username" in config and "password" in config ): msg = "One or more Oracle configuration parameters missing from the agent config file" self.log.info(msg) status = agent_util.MISCONFIGURED # Make sure the sqlplus executable is installed and executable if status == agent_util.SUPPORTED and not os.path.exists( os.path.join(config.get("oracle_home"), "bin", "sqlplus") ): msg = "Oracle sqlplus executable not found in directory specified in agent config file." self.log.info(msg) status = agent_util.MISCONFIGURED if status == agent_util.MISCONFIGURED: data = { "tnslistener": { "label": "Whether TNS listener is active and rechable", "options": None, "status": status, "error_message": msg, } } return data data = {} sid_list = [s.strip() for s in config.get("oracle_sid").split(",")] # Verify that the tnsping executable is present if os.path.exists(os.path.join(config.get("oracle_home"), "bin", "tnsping")): data["tnslistener"] = { "label": "Whether TNS listener is active and reachable", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } """ To support mapping the query parameter to the sid, introduce the oracle_servicenames_ keyset. The SID name should be lower() for the oracle_servicenames_ keys. This can be either service names or tnsnames, but need verification. [oracle] oracle_sids = SID1, SID2 oracle_servicenames_sid1 = pdb1, pdb2 oracle_servicenames_sid2 = pdb3, pdb4 """ # Gather up the available tablespaces that can be reported on spaces = [] for sid in sid_list: tsname_key = "oracle_servicenames_{}".format(sid.lower()) tsnames = config.get(tsname_key, None) if tsnames: tnsnames = [ts.strip() for ts in tsnames.split(",")] for tnsname in tnsnames: results = execute_query(sid, config, tablespace_query, tnsname) key = "{}:{}".format(sid, tnsname) for r in results: spaces.append("{}:{}".format(key, r["tablespace_name"])) elif config.get("tnsname"): results = execute_query( sid, config, tablespace_query, config.get("tnsname") ) for r in results: spaces.append("{}:{}".format(sid, r["tablespace_name"])) elif config.get("rds_end_point"): results = execute_query(sid, config, tablespace_query) for r in results: spaces.append("{}:{}".format(sid, r["tablespace_name"])) if spaces: valid_spaces = agent_util.SUPPORTED msg = "" else: valid_spaces = agent_util.MISCONFIGURED msg = "Unable to find spaces with the current oracle agent configuration" data["tablespace.size"] = { "label": "Size of tablespace in MB", "options": spaces, "status": valid_spaces, "error_message": msg, "units": "MB", } data["tablespace.free"] = { "label": "Free space of tablespace in MB", "options": spaces, "status": valid_spaces, "error_message": msg, "units": "MB", } data["tablespace.percent_free"] = { "label": "Percent of tablespace free", "options": spaces, "status": valid_spaces, "error_message": msg, "units": "percent", } # Gather up the resource utilization metrics results = execute_query(sid_list[0], config, resource_query) if results: data["resource.process.current"] = { "label": "Number of current processes", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.process.max"] = { "label": "Maximum number of processes", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.session.current"] = { "label": "Number of current sessions", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.session.max"] = { "label": "Maximum number of sessions", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.enqueue_lock.current"] = { "label": "Number of current enqueue locks", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.enqueue_lock.max"] = { "label": "Maximum number of enqueue locks", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.enqueue_resource.current"] = { "label": "Number of current enqueue resources", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.enqueue_resource.max"] = { "label": "Maximum number of enqueue resources", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.ges_lock.current"] = { "label": "Number of current Global Enqueue Service locks", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.ges_lock.max"] = { "label": "Maximum number of Global Enqueue Service locks", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.ges_proc.current"] = { "label": "Number of current Global Enqueue Service processes ", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.ges_proc.max"] = { "label": "Maximum number of Global Enqueue Service processes", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.ges_resource.current"] = { "label": "Number of Global Enqueue Service resources", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.ges_resource.max"] = { "label": "Maximum number of Global Enqueue Service resources", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.max_shared_servers.current"] = { "label": "Current number of Maximum Shared Servers", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.max_shared_servers.max"] = { "label": "Maximum number of Maximum Shared Servers", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.transactions.current"] = { "label": "Current number of transactions", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } data["resource.transactions.max"] = { "label": "Maximum number of transactions", "options": sid_list, "status": agent_util.SUPPORTED, "error_message": "", } return data def check(self, textkey, data, config): if not data: msg = "Resource option is missing for metric type `%s`." % textkey self.log.info(msg) if textkey.startswith("resource."): sid = data junk, metric, kind = textkey.split(".") metric_mapping = { "process": "processes", "session": "sessions", "enqueue_lock": "enqueue_locks", "enqueue_resource": "enqueue_resources", "ges_lock": "ges_locks", "ges_proc": "ges_procs", "ges_resource": "ges_ress", "max_shared_servers": "max_shared_servers", "transactions": "transactions", } results = execute_query(sid, config, resource_query) for r in results: if r["resource_name"] == metric_mapping.get(metric, None): if kind == "current": return int(r["current_utilization"]) elif kind == "max": return int(r["max_utilization"]) elif textkey.startswith("tablespace"): sid = None tablespace = None tsname = None items = data.split(":") if 2 == len(items): sid = items[0] tablespace = items[1] tsname = config.get("tsname", None) elif 3 == len(items): sid = items[0] tsname = items[1] tablespace = items[2] if sid is None or tablespace is None: raise Exception("Unrecognized option {}".format(data)) results = execute_query(sid, config, tablespace_query, tsname) for r in results: if r["tablespace_name"] == tablespace: if textkey.endswith(".size"): return float(r["sizemb"]) elif textkey.endswith(".free"): return float(r["freemb"]) elif textkey.endswith(".percent_free"): if float(r["sizemb"]) == 0: return 0.0 else: return float(r["freemb"]) * 100.0 / float(r["sizemb"]) # If we got here, the target tablespace wasn't found, return None so # graphs don't render return elif textkey == "tnslistener": sid = data ip_address = config.get("tns_listener_ip", "127.0.0.1") cmd = "ORACLE_HOME=%s ORACLE_SID=%s " % (config["oracle_home"], sid) cmd += "%s %s" % ( os.path.join(config.get("oracle_home"), "bin", "tnsping"), ip_address, ) status, output = agent_util.execute_command(cmd) if "OK" in output: return 1 else: return 0 else: msg = "Unknown metric type `%s` retuning `%s` as value." % (textkey, 0) self.log.info(msg) # Unknown metric type, return None by default return