{"id":1167,"date":"2010-11-16T16:52:06","date_gmt":"2010-11-16T14:52:06","guid":{"rendered":"http:\/\/michauko.org\/blog\/?p=1167"},"modified":"2015-11-21T10:06:52","modified_gmt":"2015-11-21T09:06:52","slug":"nagios-supervision-dune-base-oracle","status":"publish","type":"post","link":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/","title":{"rendered":"Nagios : supervision d&rsquo;une base Oracle"},"content":{"rendered":"<p>Hop, j&rsquo;ai trouv\u00e9 \u00e7a : <a href=\"http:\/\/labs.consol.de\/nagios\/check_oracle_health\/\">http:\/\/labs.consol.de\/nagios\/check_oracle_health\/<\/a> rep\u00e9r\u00e9 sur <a href=\"http:\/\/exchange.nagios.org\/directory\/Plugins\/Databases\/Oracle\/check_oracle_health\/details\">exchange.nagios.org<\/a>.<br \/>\nY&rsquo;a aussi le pendant pour MySQL, MSSQL etc. A voir \u00e0 l&rsquo;occasion.<\/p>\n<p>Ca permet de contr\u00f4ler depuis Nagios tout un tas de choses dans une instance Oracle : hit ratio, nb de sessions, vitesse de remplissage des redo logs, espace libre des tablespaces etc.<br \/>\nAvec \u00e7a et <a href=\"https:\/\/michauko.org\/blog\/2010\/02\/03\/oracletoolbox-sous-linux-pour-analyser-vos-perfs-oracle\/\">Oracle ToolBox que je d\u00e9cris l\u00e0<\/a>, y&rsquo;a de quoi surveiller et optimiser.<\/p>\n<p>L&rsquo;installation de ce plug-in est assez simple. Le plus dur est d&rsquo;avoir un environnement PERL\/Oracle fonctionnel. Je le d\u00e9cris <a href=\"https:\/\/michauko.org\/blog\/2010\/11\/15\/libdbd-oracle-perl-sur-debian\/\">dans un pr\u00e9c\u00e9dent article, car \u00e7a bug un peu<\/a>.<\/p>\n<h1>Installation<\/h1>\n<p>Ensuite, il faut simplement <!--more-->r\u00e9cup\u00e9rer les sources (actuellement cette version), lire le fichier \u00ab\u00a0INSTALL\u00a0\u00bb, ce qui revient \u00e0 taper un classique configure\/make\/make check\/make install et v\u00e9rifier qu&rsquo;on obtient bien le binaire dans <code>\/usr\/local\/nagios\/libexec\/<\/code>.<br \/>\nSi vous devez cr\u00e9er un utilisateur Oracle d\u00e9di\u00e9 pour analyser ces indicateurs, la doc dit de lui donner ces permissions :<\/p>\n<pre>serveur:~# sqlplus sys\/manager_que_t_as_pas_change_gros_malin@MABASE as sysdba\r\nCREATE user nagios IDENTIFIED BY super_motdepasse;\r\nGRANT CREATE session TO nagios;\r\nGRANT SELECT any dictionary TO nagios;\r\nGRANT SELECT ON V_$SYSSTAT TO nagios;\r\nGRANT SELECT ON V_$INSTANCE TO nagios;\r\nGRANT SELECT ON V_$LOG TO nagios;\r\nGRANT SELECT ON SYS.DBA_DATA_FILES TO nagios;\r\nGRANT SELECT ON SYS.DBA_FREE_SPACE TO nagios;<\/pre>\n<h1>Test en ligne de commande<\/h1>\n<p>Enfin, on l&rsquo;essaye avec :<br \/>\n<code>\/usr\/local\/nagios\/libexec\/check_oracle_health<\/code><br \/>\nPar exemple :<\/p>\n<pre>serveur:~#\/usr\/local\/nagios\/libexec\/check_oracle_health  --connect nagios\/super_motdepasse@MABASE --mode sga-library-cache-hit-ratio\r\nCRITICAL - SGA library cache hit ratio 53.51% | sga_library_cache_hit_ratio=53.51%;98:;95:\r\n<\/pre>\n<p>Houuuuu, la baffe !<\/p>\n<h1>Int\u00e9gration dans Nagios<\/h1>\n<p>Et pour int\u00e9grer tout \u00e7a dans Nagios, il suffit de jouer avec NRPE en ajoutant les petites commandes qui vont bien dans le fichier <code>\/etc\/nagios\/nrpe_local.cfg<\/code>. <a href=\"https:\/\/michauko.org\/blog\/2010\/01\/06\/nrpe-monitorer-des-linux-avec-nagios\/\">J&rsquo;en parle d\u00e9j\u00e0 ici<\/a>. Et comme je suis sympa, j&rsquo;en donne un long exemple en fin de cet article.<\/p>\n<p>Une fois lanc\u00e9 depuis Nagios, alors qu&rsquo;en utilisateur nagios et ligne de commande, \u00e7a marchait bien, je me suis r\u00e9cup\u00e9r\u00e9 l&rsquo;erreur ORA-24327 \u00ab\u00a0need explicit attach before authenticating a user\u00a0\u00bb en sortie de NRPE&#8230;<br \/>\nIl manquait des variables d&rsquo;environnement \u00e0 passer \u00e0 l&rsquo;utilisateur nagios pour le daemon NRPE. Je n&rsquo;ai rien trouv\u00e9 plus propre que de modifier le script de lancement du service&#8230; (si vous avez mieux, dites moi) :<\/p>\n<pre>serveur_nrpe:~# head -30 \/etc\/init.d\/nagios-nrpe-server\r\n#! \/bin\/sh\r\n#\r\n\r\n### BEGIN INIT INFO\r\n# Provides:          nagios-nrpe-server\r\n# Required-Start:    $local_fs $remote_fs $syslog $named $network $time\r\n# Required-Stop:     $local_fs $remote_fs $syslog $named $network\r\n# Should-Start:\r\n# Should-Stop:\r\n# Default-Start:     2 3 4 5\r\n# Default-Stop:      0 1 6\r\n# Short-Description: Start\/Stop the Nagios remote plugin execution daemon\r\n### END INIT INFO\r\n\r\n\r\nPATH=\/usr\/local\/sbin:\/usr\/local\/bin:\/sbin:\/bin:\/usr\/sbin:\/usr\/bin\r\nDAEMON=\/usr\/sbin\/nrpe\r\nNAME=nagios-nrpe\r\nDESC=nagios-nrpe\r\nCONFIG=\/etc\/nagios\/nrpe.cfg\r\n\r\n<strong>### JACQUES pour ORACLE\/Nagios check_oracle_health\r\nexport ORACLE_HOME=\/usr\/lib\/oracle\/11.1\/client\r\nexport PATH=$PATH:$ORACLE_HOME\/bin\r\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib\r\n###\r\n<\/strong>\r\ntest -x $DAEMON || exit 0\r\n\r\nblablablababla...<\/pre>\n<h1>R\u00e9sultat<\/h1>\n<p>A la fin, ouaaa, \u00e7a donne \u00e7a :<br \/>\n<a href=\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343-300x103.png\" alt=\"check_oracle_health\" title=\"check_oracle_health\" width=\"300\" height=\"103\" class=\"aligncenter size-medium wp-image-1169\" srcset=\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343-300x103.png 300w, https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343.png 994w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nYapuka corriger la palanqu\u00e9e de probl\u00e8mes. O\u00f9 est mon DBA ? ah, y&rsquo;en a pas, \u00e7a promet. Allez, on ressort \u00ab\u00a0Oracle for dummies\u00a0\u00bb.<\/p>\n<h1>Annexes<\/h1>\n<h2>Conf NRPE de tous les tests<\/h2>\n<p>Comme je suis sympa, je donne un bout de fichier de conf NRPE au cas o\u00f9. J&rsquo;ai simplement fait cracher tous les \u00ab\u00a0modes\u00a0\u00bb (contr\u00f4les)  possibles en scriptant, histoire de g\u00e9n\u00e9rer \u00e7a facilement.<\/p>\n<pre>#command[ORAOCTM_tnsping]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tnsping\r\ncommand[ORAOCTM_connection-time]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode connection-time\r\ncommand[ORAOCTM_connected-users]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode connected-users\r\ncommand[ORAOCTM_sga-data-buffer-hit-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sga-data-buffer-hit-ratio\r\ncommand[ORAOCTM_sga-library-cache-hit-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sga-library-cache-hit-ratio\r\ncommand[ORAOCTM_sga-dictionary-cache-hit-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sga-dictionary-cache-hit-ratio\r\ncommand[ORAOCTM_sga-latches-hit-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sga-latches-hit-ratio\r\ncommand[ORAOCTM_sga-shared-pool-reload-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sga-shared-pool-reload-ratio\r\ncommand[ORAOCTM_sga-shared-pool-free]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sga-shared-pool-free\r\ncommand[ORAOCTM_pga-in-memory-sort-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode pga-in-memory-sort-ratio\r\ncommand[ORAOCTM_invalid-objects]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode invalid-objects\r\ncommand[ORAOCTM_stale-statistics]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode stale-statistics\r\ncommand[ORAOCTM_tablespace-usage1]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-usage --tablespace BASEDATA\r\ncommand[ORAOCTM_tablespace-usage2]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-usage --tablespace BASEIDX\r\ncommand[ORAOCTM_tablespace-usage3]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-usage --tablespace SYSAUX\r\ncommand[ORAOCTM_tablespace-usage4]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-usage --tablespace SYSTEM\r\ncommand[ORAOCTM_tablespace-usage5]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-usage --tablespace TEMP\r\ncommand[ORAOCTM_tablespace-usage6]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-usage --tablespace UNDOTBS1\r\n#command[ORAOCTM_tablespace-free]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-free\r\n### A s\u00e9parer en plusieurs tablespace au besoin :\r\ncommand[ORAOCTM_tablespace-remaining-time]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-remaining-time\r\n###\r\ncommand[ORAOCTM_tablespace-fragmentation1]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-fragmentation --tablespace BASEDATA\r\ncommand[ORAOCTM_tablespace-fragmentation2]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-fragmentation --tablespace BASEIDX\r\ncommand[ORAOCTM_tablespace-fragmentation3]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-fragmentation --tablespace SYSAUX\r\ncommand[ORAOCTM_tablespace-fragmentation4]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-fragmentation --tablespace SYSTEM\r\n#command[ORAOCTM_tablespace-fragmentatioN5]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-fragmentation --tablespace TEMP\r\ncommand[ORAOCTM_tablespace-fragmentation6]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-fragmentation --tablespace UNDOTBS1\r\ncommand[ORAOCTM_tablespace-io-balance1]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-io-balance --tablespace BASEDATA\r\ncommand[ORAOCTM_tablespace-io-balance2]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-io-balance --tablespace BASEIDX\r\ncommand[ORAOCTM_tablespace-io-balance3]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-io-balance --tablespace SYSAUX\r\ncommand[ORAOCTM_tablespace-io-balance4]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-io-balance --tablespace SYSTEM\r\ncommand[ORAOCTM_tablespace-io-balance5]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-io-balance --tablespace TEMP\r\ncommand[ORAOCTM_tablespace-io-balance6]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-io-balance --tablespace UNDOTBS1\r\ncommand[ORAOCTM_tablespace-can-allocate-next1]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-can-allocate-next --tablespace BASEDATA\r\ncommand[ORAOCTM_tablespace-can-allocate-next2]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-can-allocate-next --tablespace BASEIDX\r\ncommand[ORAOCTM_tablespace-can-allocate-next3]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-can-allocate-next --tablespace SYSAUX\r\ncommand[ORAOCTM_tablespace-can-allocate-next4]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-can-allocate-next --tablespace SYSTEM\r\ncommand[ORAOCTM_tablespace-can-allocate-next5]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-can-allocate-next --tablespace TEMP\r\ncommand[ORAOCTM_tablespace-can-allocate-next6]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode tablespace-can-allocate-next --tablespace UNDOTBS1\r\ncommand[ORAOCTM_datafile-io-traffic1]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode datafile-io-traffic --name INDEX01.DBF\r\ncommand[ORAOCTM_datafile-io-traffic2]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode datafile-io-traffic --name SYSAUX01.DBF\r\ncommand[ORAOCTM_datafile-io-traffic3]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode datafile-io-traffic --name SYSTEM01.DBF\r\ncommand[ORAOCTM_datafile-io-traffic4]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode datafile-io-traffic --name TEMP01.DBF\r\ncommand[ORAOCTM_datafile-io-traffic5]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode datafile-io-traffic --name UNDOTBS01.DBF\r\ncommand[ORAOCTM_datafile-io-traffic6]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode datafile-io-traffic --name USERS01.DBF\r\ncommand[ORAOCTM_soft-parse-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode soft-parse-ratio\r\ncommand[ORAOCTM_switch-interval]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode switch-interval\r\ncommand[ORAOCTM_retry-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode retry-ratio\r\ncommand[ORAOCTM_redo-io-traffic]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode redo-io-traffic\r\ncommand[ORAOCTM_roll-header-contention]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode roll-header-contention\r\ncommand[ORAOCTM_roll-block-contention]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode roll-block-contention\r\ncommand[ORAOCTM_roll-hit-ratio]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode roll-hit-ratio\r\ncommand[ORAOCTM_roll-wraps]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode roll-wraps\r\ncommand[ORAOCTM_roll-extends]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode roll-extends\r\ncommand[ORAOCTM_roll-avgactivesize]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode roll-avgactivesize\r\ncommand[ORAOCTM_seg-top10-logical-reads]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode seg-top10-logical-reads\r\ncommand[ORAOCTM_seg-top10-physical-reads]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode seg-top10-physical-reads\r\ncommand[ORAOCTM_seg-top10-buffer-busy-waits]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode seg-top10-buffer-busy-waits\r\ncommand[ORAOCTM_seg-top10-row-lock-waits]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode seg-top10-row-lock-waits\r\ncommand[ORAOCTM_event-waits]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode event-waits\r\ncommand[ORAOCTM_event-waiting]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode event-waiting\r\ncommand[ORAOCTM_enqueue-contention]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode enqueue-contention\r\ncommand[ORAOCTM_enqueue-waiting]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode enqueue-waiting\r\ncommand[ORAOCTM_latch-contention]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode latch-contention\r\ncommand[ORAOCTM_latch-waiting]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode latch-waiting\r\ncommand[ORAOCTM_sysstat]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sysstat\r\ncommand[ORAOCTM_flash-recovery-area-usage]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode flash-recovery-area-usage\r\ncommand[ORAOCTM_flash-recovery-area-free]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode flash-recovery-area-free\r\n#command[ORAOCTM_sql]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode sql\r\n#command[ORAOCTM_list-tablespaces]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-tablespaces\r\n#command[ORAOCTM_list-datafiles]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-datafiles\r\n#command[ORAOCTM_list-enqueues]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-enqueues\r\n#command[ORAOCTM_list-latches]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-latches\r\n#command[ORAOCTM_list-events]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-events\r\n#command[ORAOCTM_list-background-events]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-background-events\r\n#command[ORAOCTM_list-sysstats]=\/usr\/local\/nagios\/libexec\/check_oracle_health --connect nagios\/super_motdepasse@BASE --mode list-sysstats<\/pre>\n<h2>Conf Nagios pour appeler ces tests NRPE<\/h2>\n<p>La m\u00eame chose pour le fichier Nagios appelant NRPE :<\/p>\n<pre>define service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_connection-time\r\n        check_command check_nrpe_1arg!ORAOCTM_connection-time\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_connected-users\r\n        check_command check_nrpe_1arg!ORAOCTM_connected-users\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sga-data-buffer-hit-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_sga-data-buffer-hit-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sga-library-cache-hit-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_sga-library-cache-hit-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sga-dictionary-cache-hit-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_sga-dictionary-cache-hit-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sga-latches-hit-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_sga-latches-hit-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sga-shared-pool-reload-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_sga-shared-pool-reload-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sga-shared-pool-free\r\n        check_command check_nrpe_1arg!ORAOCTM_sga-shared-pool-free\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_pga-in-memory-sort-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_pga-in-memory-sort-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_invalid-objects\r\n        check_command check_nrpe_1arg!ORAOCTM_invalid-objects\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_stale-statistics\r\n        check_command check_nrpe_1arg!ORAOCTM_stale-statistics\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-usage1\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-usage1\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-usage2\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-usage2\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-usage3\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-usage3\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-usage4\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-usage4\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-usage5\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-usage5\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-usage6\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-usage6\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-remaining-time\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-remaining-time\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-fragmentation1\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-fragmentation1\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-fragmentation2\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-fragmentation2\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-fragmentation3\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-fragmentation3\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-fragmentation4\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-fragmentation4\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-fragmentation5\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-fragmentation5\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-fragmentation6\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-fragmentation6\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-io-balance1\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-io-balance1\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-io-balance2\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-io-balance2\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-io-balance3\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-io-balance3\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-io-balance4\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-io-balance4\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-io-balance5\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-io-balance5\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-io-balance6\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-io-balance6\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-can-allocate-next1\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-can-allocate-next1\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-can-allocate-next2\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-can-allocate-next2\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-can-allocate-next3\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-can-allocate-next3\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-can-allocate-next4\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-can-allocate-next4\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-can-allocate-next5\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-can-allocate-next5\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_tablespace-can-allocate-next6\r\n        check_command check_nrpe_1arg!ORAOCTM_tablespace-can-allocate-next6\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_datafile-io-traffic1\r\n        check_command check_nrpe_1arg!ORAOCTM_datafile-io-traffic1\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_datafile-io-traffic2\r\n        check_command check_nrpe_1arg!ORAOCTM_datafile-io-traffic2\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_datafile-io-traffic3\r\n        check_command check_nrpe_1arg!ORAOCTM_datafile-io-traffic3\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_datafile-io-traffic4\r\n        check_command check_nrpe_1arg!ORAOCTM_datafile-io-traffic4\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_datafile-io-traffic5\r\n        check_command check_nrpe_1arg!ORAOCTM_datafile-io-traffic5\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_datafile-io-traffic6\r\n        check_command check_nrpe_1arg!ORAOCTM_datafile-io-traffic6\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_soft-parse-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_soft-parse-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_switch-interval\r\n        check_command check_nrpe_1arg!ORAOCTM_switch-interval\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_retry-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_retry-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_redo-io-traffic\r\n        check_command check_nrpe_1arg!ORAOCTM_redo-io-traffic\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_roll-header-contention\r\n        check_command check_nrpe_1arg!ORAOCTM_roll-header-contention\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_roll-block-contention\r\n        check_command check_nrpe_1arg!ORAOCTM_roll-block-contention\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_roll-hit-ratio\r\n        check_command check_nrpe_1arg!ORAOCTM_roll-hit-ratio\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_roll-wraps\r\n        check_command check_nrpe_1arg!ORAOCTM_roll-wraps\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_roll-extends\r\n        check_command check_nrpe_1arg!ORAOCTM_roll-extends\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_roll-avgactivesize\r\n        check_command check_nrpe_1arg!ORAOCTM_roll-avgactivesize\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_seg-top10-logical-reads\r\n        check_command check_nrpe_1arg!ORAOCTM_seg-top10-logical-reads\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_seg-top10-physical-reads\r\n        check_command check_nrpe_1arg!ORAOCTM_seg-top10-physical-reads\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_seg-top10-buffer-busy-waits\r\n        check_command check_nrpe_1arg!ORAOCTM_seg-top10-buffer-busy-waits\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_seg-top10-row-lock-waits\r\n        check_command check_nrpe_1arg!ORAOCTM_seg-top10-row-lock-waits\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_event-waits\r\n        check_command check_nrpe_1arg!ORAOCTM_event-waits\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_event-waiting\r\n        check_command check_nrpe_1arg!ORAOCTM_event-waiting\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_enqueue-contention\r\n        check_command check_nrpe_1arg!ORAOCTM_enqueue-contention\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_enqueue-waiting\r\n        check_command check_nrpe_1arg!ORAOCTM_enqueue-waiting\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_latch-contention\r\n        check_command check_nrpe_1arg!ORAOCTM_latch-contention\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_latch-waiting\r\n        check_command check_nrpe_1arg!ORAOCTM_latch-waiting\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_sysstat\r\n        check_command check_nrpe_1arg!ORAOCTM_sysstat\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_flash-recovery-area-usage\r\n        check_command check_nrpe_1arg!ORAOCTM_flash-recovery-area-usage\r\n}\r\ndefine service {\r\n        use generic-service\r\n        host_name srvnrpe\r\n        service_description ORAOCTM_flash-recovery-area-free\r\n        check_command check_nrpe_1arg!ORAOCTM_flash-recovery-area-free\r\n}\r\n<\/pre>\n<h2>Remarques<\/h2>\n<p>J&rsquo;ai fait le bourrin : un \u00ab\u00a0service Nagios\u00a0\u00bb = un \u00ab\u00a0appel NRPE\u00a0\u00bb = un \u00ab\u00a0lancement de check_oracle_health\u00a0\u00bb. On doit pouvoir fignoler avec des param\u00e8tres et le \u00ab\u00a0check_nrpe\u00a0\u00bb normal plut\u00f4t que le \u00ab\u00a01arg\u00a0\u00bb-ument.<\/p>\n<p>Enfin, vous pouvez d\u00e9tailler chaque test pour les probl\u00e8mes de verrous, events etc. La liste est m\u00e9ga longue. Vous pourrez facilement scripter pour obtenir la liste de tous les test si vous \u00eates un bon gros psychopathe.<br \/>\nA base de :<\/p>\n<pre>check_oracle_health --blabla -mode list-events | awk ...<\/pre>\n<p> et idem pour les sysstats, enqueues, latches etc.<br \/>\nAttention, dans les 3000 tests (de m\u00e9moire) et des fichiers de conf Nagios de 10 km de long. C&rsquo;est passablement cr\u00e9tin de tout mettre d&rsquo;un coup (bon OK, je l&rsquo;ai fait quand m\u00eame, histoire de voir ;)) car le serveur Nagios accuse un peu le coup.<br \/>\nJe crois de plus que les tests g\u00e9n\u00e9riques, genre <code>check_oracle_health --mode event-waits<\/code> sortent en premier les erreur critiques les plus graves. Pas la peine de descendre dans un d\u00e9tail sans fin de <code>check_oracle_health --blabla --mode event-waits --name 687721825<\/code> par exemple, ou encore <code>\/usr\/local\/nagios\/libexec\/check_oracle_health --connect bla\/bla@BLA --mode enqueue-waiting --name XR<\/code>.<\/p>\n<p>Voil\u00e0, vous devriez pouvoir sortir un reporting de votre base en 17 tomes, de quoi assomer n&rsquo;importe quel patron, emmerder un DBA et vous laisser du temps libre. \ud83d\ude00<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hop, j&rsquo;ai trouv\u00e9 \u00e7a : http:\/\/labs.consol.de\/nagios\/check_oracle_health\/ rep\u00e9r\u00e9 sur exchange.nagios.org. Y&rsquo;a aussi le pendant pour MySQL, MSSQL etc. A voir \u00e0 l&rsquo;occasion. Ca permet de contr\u00f4ler depuis Nagios tout un tas de choses dans une instance &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,82,384,83],"tags":[476,325,383,306,429],"class_list":["post-1167","post","type-post","status-publish","format-standard","hentry","category-debian","category-pl","category-supervision","category-ubuntu","tag-check_oracle_health","tag-nagios","tag-nrpe","tag-oracle","tag-oracletoolbox"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Nagios : supervision d&#039;une base Oracle - Le blog de Michauko<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nagios : supervision d&#039;une base Oracle - Le blog de Michauko\" \/>\n<meta property=\"og:description\" content=\"Hop, j&rsquo;ai trouv\u00e9 \u00e7a : http:\/\/labs.consol.de\/nagios\/check_oracle_health\/ rep\u00e9r\u00e9 sur exchange.nagios.org. Y&rsquo;a aussi le pendant pour MySQL, MSSQL etc. A voir \u00e0 l&rsquo;occasion. Ca permet de contr\u00f4ler depuis Nagios tout un tas de choses dans une instance &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/\" \/>\n<meta property=\"og:site_name\" content=\"Le blog de Michauko\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-16T14:52:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-11-21T09:06:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343-300x103.png\" \/>\n<meta name=\"author\" content=\"michauko\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"michauko\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/\"},\"author\":{\"name\":\"michauko\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"headline\":\"Nagios : supervision d&rsquo;une base Oracle\",\"datePublished\":\"2010-11-16T14:52:06+00:00\",\"dateModified\":\"2015-11-21T09:06:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/\"},\"wordCount\":617,\"commentCount\":7,\"image\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/20101116_152343-300x103.png\",\"keywords\":[\"check_oracle_health\",\"nagios\",\"NRPE\",\"oracle\",\"oracletoolbox\"],\"articleSection\":[\"Debian\",\"planet-libre.org\",\"supervision\",\"Ubuntu\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/\",\"name\":\"Nagios : supervision d'une base Oracle - Le blog de Michauko\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/20101116_152343-300x103.png\",\"datePublished\":\"2010-11-16T14:52:06+00:00\",\"dateModified\":\"2015-11-21T09:06:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#primaryimage\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/20101116_152343.png\",\"contentUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/20101116_152343.png\",\"width\":\"994\",\"height\":\"342\",\"caption\":\"check_oracle_health\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/nagios-supervision-dune-base-oracle-1167\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nagios : supervision d&rsquo;une base Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\",\"name\":\"Le blog de Michauko\",\"description\":\"Si tu ne comprends pas le titre de l&#039;article, passe ton chemin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/michauko.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\",\"name\":\"michauko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"caption\":\"michauko\"},\"sameAs\":[\"http:\\\/\\\/michauko.org\\\/\"],\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/author\\\/randomized2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nagios : supervision d'une base Oracle - Le blog de Michauko","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/","og_locale":"fr_FR","og_type":"article","og_title":"Nagios : supervision d'une base Oracle - Le blog de Michauko","og_description":"Hop, j&rsquo;ai trouv\u00e9 \u00e7a : http:\/\/labs.consol.de\/nagios\/check_oracle_health\/ rep\u00e9r\u00e9 sur exchange.nagios.org. Y&rsquo;a aussi le pendant pour MySQL, MSSQL etc. A voir \u00e0 l&rsquo;occasion. Ca permet de contr\u00f4ler depuis Nagios tout un tas de choses dans une instance &hellip;","og_url":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/","og_site_name":"Le blog de Michauko","article_published_time":"2010-11-16T14:52:06+00:00","article_modified_time":"2015-11-21T09:06:52+00:00","og_image":[{"url":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343-300x103.png","type":"","width":"","height":""}],"author":"michauko","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"michauko","Dur\u00e9e de lecture estim\u00e9e":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#article","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/"},"author":{"name":"michauko","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"headline":"Nagios : supervision d&rsquo;une base Oracle","datePublished":"2010-11-16T14:52:06+00:00","dateModified":"2015-11-21T09:06:52+00:00","mainEntityOfPage":{"@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/"},"wordCount":617,"commentCount":7,"image":{"@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#primaryimage"},"thumbnailUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343-300x103.png","keywords":["check_oracle_health","nagios","NRPE","oracle","oracletoolbox"],"articleSection":["Debian","planet-libre.org","supervision","Ubuntu"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/","url":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/","name":"Nagios : supervision d'une base Oracle - Le blog de Michauko","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#primaryimage"},"image":{"@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#primaryimage"},"thumbnailUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343-300x103.png","datePublished":"2010-11-16T14:52:06+00:00","dateModified":"2015-11-21T09:06:52+00:00","author":{"@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"breadcrumb":{"@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#primaryimage","url":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343.png","contentUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2010\/11\/20101116_152343.png","width":"994","height":"342","caption":"check_oracle_health"},{"@type":"BreadcrumbList","@id":"https:\/\/michauko.org\/blog\/nagios-supervision-dune-base-oracle-1167\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/michauko.org\/blog\/"},{"@type":"ListItem","position":2,"name":"Nagios : supervision d&rsquo;une base Oracle"}]},{"@type":"WebSite","@id":"https:\/\/michauko.org\/blog\/#website","url":"https:\/\/michauko.org\/blog\/","name":"Le blog de Michauko","description":"Si tu ne comprends pas le titre de l&#039;article, passe ton chemin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michauko.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9","name":"michauko","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","caption":"michauko"},"sameAs":["http:\/\/michauko.org\/"],"url":"https:\/\/michauko.org\/blog\/author\/randomized2\/"}]}},"_links":{"self":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/comments?post=1167"}],"version-history":[{"count":7,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1167\/revisions"}],"predecessor-version":[{"id":1714,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1167\/revisions\/1714"}],"wp:attachment":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/media?parent=1167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/categories?post=1167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/tags?post=1167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}