Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

check_oracle_health

https://support.nagios.com/forum/viewtopic.php?t=26824

Page 1 of 1

check_oracle_health

Posted: Tue Apr 29, 2014 4:21 am
by hanya.radwan
hi,

when used check_oracle_health and choose Tablespace Usage as mode and used the below command, from command it gives result as the following, but on nagios XI the service still pending, so is this caused by huge size of performance data ,if yes how can stop showing performance data, if not what is the problem:


COMMAND:

Code: Select all

/usr/bin/env TNS_ADMIN=/usr/lib/oracle/12.1/client64/network/admin LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 /usr/local/nagios/libexec/check_oracle_health  --connect "10.100.1.176:1521/ppcalls" --username nagios_appl --password "m0n_4jawwalppcalls50937" --mode tablespace-usage  --report short  --warning 87  --critical 95
OUTPUT:

Code: Select all

WARNING - tbs SYSAUX usage is 92.21%, tbs OUTCALLS_INDX03 usage is 92.07%, tbs OUTCALLS_INDX02 usage is 91.80%, tbs OUTCALLS_DATA03 usage is 94.42%, tbs INCCALLS_DATA2014_02 usage is 94.03% | 'tbs_users_usage_pct'=65.62%;87;95 'tbs_users_usage'=21502MB;28508;31129;0;32768 'tbs_users_alloc'=32768MB;;;0;32768 'tbs_undotbs1_usage_pct'=4.02%;87;95 'tbs_undotbs1_usage'=1441MB;31180;34048;0;35840 'tbs_undotbs1_alloc'=29780MB;;;0;35840 'tbs_temporary_usage_pct'=0.84%;87;95 'tbs_temporary_usage'=600MB;62361;68096;0;71680 'tbs_temporary_alloc'=71650MB;;;0;71680 'tbs_system_usage_pct'=26.71%;87;95 'tbs_system_usage'=1094MB;3563;3891;0;4096 'tbs_system_alloc'=1300MB;;;0;4096 'tbs_sysaux_usage_pct'=92.21%;87;95 'tbs_sysaux_usage'=5665MB;5345;5836;0;6144 'tbs_sysaux_alloc'=5992MB;;;0;6144 'tbs_shared_acc_indxq4_usage_pct'=23.14%;87;95 'tbs_shared_acc_indxq4_usage'=474MB;1781;1945;0;2048 'tbs_shared_acc_indxq4_alloc'=1024MB;;;0;2048 'tbs_shared_acc_indxq3_usage_pct'=23.14%;87;95 'tbs_shared_acc_indxq3_usage'=474MB;1781;1945;0;2048 'tbs_shared_acc_indxq3_alloc'=1024MB;;;0;2048 'tbs_shared_acc_indxq2_usage_pct'=18.26%;87;95 'tbs_shared_acc_indxq2_usage'=374MB;1781;1945;0;2048 'tbs_shared_acc_indxq2_alloc'=1024MB;;;0;2048 'tbs_shared_acc_indxq1_usage_pct'=8.50%;87;95 'tbs_shared_acc_indxq1_usage'=174MB;1781;1945;0;2048 'tbs_shared_acc_indxq1_alloc'=1024MB;;;0;2048 'tbs_shared_acc_dataq4_usage_pct'=23.14%;87;95 'tbs_shared_acc_dataq4_usage'=474MB;1781;1945;0;2048 'tbs_shared_acc_dataq4_alloc'=1024MB;;;0;2048 'tbs_shared_acc_dataq3_usage_pct'=23.14%;87;95 'tbs_shared_acc_dataq3_usage'=474MB;1781;1945;0;2048 'tbs_shared_acc_dataq3_alloc'=1024MB;;;0;2048 'tbs_shared_acc_dataq2_usage_pct'=20.70%;87;95 'tbs_shared_acc_dataq2_usage'=424MB;1781;1945;0;2048 'tbs_shared_acc_dataq2_alloc'=1024MB;;;0;2048 'tbs_shared_acc_dataq1_usage_pct'=15.82%;87;95 'tbs_shared_acc_dataq1_usage'=324MB;1781;1945;0;2048 'tbs_shared_acc_dataq1_alloc'=1024MB;;;0;2048 'tbs_rmng_indxq4_usage_pct'=58.57%;87;95 'tbs_rmng_indxq4_usage'=2399MB;3563;3891;0;4096 'tbs_rmng_indxq4_alloc'=3799MB;;;0;4096 'tbs_rmng_indxq3_usage_pct'=46.02%;87;95 'tbs_rmng_indxq3_usage'=3770MB;7127;7782;0;8192 'tbs_rmng_indxq3_alloc'=5120MB;;;0;8192 'tbs_rmng_indxq2_usage_pct'=72.05%;87;95 'tbs_rmng_indxq2_usage'=2951MB;3563;3891;0;4096 'tbs_rmng_indxq2_alloc'=3601MB;;;0;4096 'tbs_rmng_indxq1_usage_pct'=31.36%;87;95 'tbs_rmng_indxq1_usage'=1325MB;3675;4013;0;4225 'tbs_rmng_indxq1_alloc'=4225MB;;;0;4225 'tbs_rmng_dataq4_usage_pct'=41.53%;87;95 'tbs_rmng_dataq4_usage'=1701MB;3563;3891;0;4096 'tbs_rmng_dataq4_alloc'=2851MB;;;0;4096 'tbs_rmng_dataq3_usage_pct'=72.05%;87;95 'tbs_rmng_dataq3_usage'=2951MB;3563;3891;0;4096 'tbs_rmng_dataq3_alloc'=3501MB;;;0;4096 'tbs_rmng_dataq2_usage_pct'=55.54%;87;95 'tbs_rmng_dataq2_usage'=2275MB;3563;3891;0;4096 'tbs_rmng_dataq2_alloc'=2775MB;;;0;4096 'tbs_rmng_dataq1_usage_pct'=23.80%;87;95 'tbs_rmng_dataq1_usage'=975MB;3563;3891;0;4096 'tbs_rmng_dataq1_alloc'=2225MB;;;0;4096 'tbs_pp_dm_dev_tbs_usage_pct'=72.74%;87;95 'tbs_pp_dm_dev_tbs_usage'=8938MB;10690;11673;0;12288 'tbs_pp_dm_dev_tbs_alloc'=10240MB;;;0;12288 'tbs_ppcalls_indx_usage_pct'=23.15%;87;95 'tbs_ppcalls_indx_usage'=2371MB;8908;9728;0;10240 'tbs_ppcalls_indx_alloc'=2497MB;;;0;10240 'tbs_ppcalls_data_usage_pct'=86.71%;87;95 'tbs_ppcalls_data_usage'=31078MB;31180;34048;0;35840 'tbs_ppcalls_data_alloc'=32820MB;;;0;35840 'tbs_outcalls_stat_data_usage_pct'=10.45%;87;95 'tbs_outcalls_stat_data_usage'=3209MB;26726;29184;0;30720 'tbs_outcalls_stat_data_alloc'=20480MB;;;0;30720 'tbs_outcalls_indx_10_usage_pct'=43.44%;87;95 'tbs_outcalls_indx_10_usage'=8896MB;17817;19456;0;20480 'tbs_outcalls_indx_10_alloc'=9496MB;;;0;20480 'tbs_outcalls_indx_09_usage_pct'=43.44%;87;95 'tbs_outcalls_indx_09_usage'=8896MB;17817;19456;0;20480 'tbs_outcalls_indx_09_alloc'=9496MB;;;0;20480 'tbs_outcalls_indx_08_usage_pct'=43.44%;87;95 'tbs_outcalls_indx_08_usage'=8896MB;17817;19456;0;20480 'tbs_outcalls_indx_08_alloc'=9496MB;;;0;20480 'tbs_outcalls_indx2014_12_usage_pct'=24.54%;87;95 'tbs_outcalls_indx2014_12_usage'=12564MB;44544;48640;0;51200 'tbs_outcalls_indx2014_12_alloc'=13264MB;;;0;51200 'tbs_outcalls_indx2014_11_usage_pct'=23.76%;87;95 'tbs_outcalls_indx2014_11_usage'=12164MB;44544;48640;0;51200 'tbs_outcalls_indx2014_11_alloc'=12864MB;;;0;51200 'tbs_outcalls_indx2014_10_usage_pct'=24.54%;87;95 'tbs_outcalls_indx2014_10_usage'=12564MB;44544;48640;0;51200 'tbs_outcalls_indx2014_10_alloc'=13264MB;;;0;51200 'tbs_outcalls_indx2014_09_usage_pct'=23.76%;87;95 'tbs_outcalls_indx2014_09_usage'=12164MB;44544;48640;0;51200 'tbs_outcalls_indx2014_09_alloc'=12864MB;;;0;51200 'tbs_outcalls_indx2014_08_usage_pct'=24.54%;87;95 'tbs_outcalls_indx2014_08_usage'=12564MB;44544;48640;0;51200 'tbs_outcalls_indx2014_08_alloc'=13264MB;;;0;51200 'tbs_outcalls_indx2014_07_usage_pct'=24.54%;87;95 'tbs_outcalls_indx2014_07_usage'=12564MB;44544;48640;0;51200 'tbs_outcalls_indx2014_07_alloc'=13264MB;;;0;51200 'tbs_outcalls_indx2014_06_usage_pct'=23.76%;87;95 'tbs_outcalls_indx2014_06_usage'=12164MB;44544;48640;0;51200 'tbs_outcalls_indx2014_06_alloc'=12864MB;;;0;51200 'tbs_outcalls_indx2014_05_usage_pct'=24.54%;87;95 'tbs_outcalls_indx2014_05_usage'=12564MB;44544;48640;0;51200 'tbs_outcalls_indx2014_05_alloc'=13264MB;;;0;51200 'tbs_outcalls_indx2014_04_usage_pct'=50.93%;87;95 'tbs_outcalls_indx2014_04_usage'=67800MB;115814;126464;0;133120 'tbs_outcalls_indx2014_04_alloc'=76800MB;;;0;133120 'tbs_outcalls_indx2014_03_usage_pct'=56.01%;87;95 'tbs_outcalls_indx2014_03_usage'=68828MB;106905;116736;0;122880 'tbs_outcalls_indx2014_03_alloc'=73728MB;;;0;122880 'tbs_outcalls_indx2014_02_usage_pct'=75.10%;87;95 'tbs_outcalls_indx2014_02_usage'=61520MB;71270;77824;0;81920 'tbs_outcalls_indx2014_02_alloc'=64120MB;;;0;81920 'tbs_outcalls_indx2014_01_usage_pct'=66.15%;87;95 'tbs_outcalls_indx2014_01_usage'=67740MB;89088;97280;0;102400 'tbs_outcalls_indx2014_01_alloc'=70440MB;;;0;102400 'tbs_outcalls_indx13_usage_pct'=63.92%;87;95 'tbs_outcalls_indx13_usage'=52360MB;71270;77824;0;81920 'tbs_outcalls_indx13_alloc'=61060MB;;;0;81920 'tbs_outcalls_indx12_usage_pct'=34.93%;87;95 'tbs_outcalls_indx12_usage'=42920MB;106905;116736;0;122880 'tbs_outcalls_indx12_alloc'=81920MB;;;0;122880 'tbs_outcalls_indx11_usage_pct'=51.17%;87;95 'tbs_outcalls_indx11_usage'=39922MB;67879;74120;0;78022 'tbs_outcalls_indx11_alloc'=78022MB;;;0;78022 'tbs_outcalls_indx10_usage_pct'=47.83%;87;95 'tbs_outcalls_indx10_usage'=39180MB;71270;77824;0;81920 'tbs_outcalls_indx10_alloc'=71580MB;;;0;81920 'tbs_outcalls_indx09_usage_pct'=48.57%;87;95 'tbs_outcalls_indx09_usage'=39785MB;71270;77824;0;81920 'tbs_outcalls_indx09_alloc'=73085MB;;;0;81920 'tbs_outcalls_indx08_usage_pct'=47.06%;87;95 'tbs_outcalls_indx08_usage'=38548MB;71270;77824;0;81920 'tbs_outcalls_indx08_alloc'=69748MB;;;0;81920 'tbs_outcalls_indx03_usage_pct'=92.07%;87;95 'tbs_outcalls_indx03_usage'=75421MB;71270;77824;0;81920 'tbs_outcalls_indx03_alloc'=75421MB;;;0;81920 'tbs_outcalls_indx02_usage_pct'=91.80%;87;95 'tbs_outcalls_indx02_usage'=75200MB;71270;77824;0;81920 'tbs_outcalls_indx02_alloc'=77300MB;;;0;81920 'tbs_outcalls_indx01_usage_pct'=83.52%;87;95 'tbs_outcalls_indx01_usage'=68416MB;71270;77824;0;81920 'tbs_outcalls_indx01_alloc'=71716MB;;;0;81920 'tbs_outcalls_data_10_usage_pct'=43.54%;87;95 'tbs_outcalls_data_10_usage'=8916MB;17817;19456;0;20480 'tbs_outcalls_data_10_alloc'=9516MB;;;0;20480 'tbs_outcalls_data_09_usage_pct'=41.21%;87;95 'tbs_outcalls_data_09_usage'=8440MB;17817;19456;0;20480 'tbs_outcalls_data_09_alloc'=10240MB;;;0;20480 'tbs_outcalls_data_08_usage_pct'=40.61%;87;95 'tbs_outcalls_data_08_usage'=8316MB;17817;19456;0;20480 'tbs_outcalls_data_08_alloc'=9216MB;;;0;20480 'tbs_outcalls_data2014_12_usage_pct'=6.34%;87;95 'tbs_outcalls_data2014_12_usage'=3248MB;44544;48640;0;51200 'tbs_outcalls_data2014_12_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_11_usage_pct'=6.15%;87;95 'tbs_outcalls_data2014_11_usage'=3148MB;44544;48640;0;51200 'tbs_outcalls_data2014_11_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_10_usage_pct'=6.34%;87;95 'tbs_outcalls_data2014_10_usage'=3248MB;44544;48640;0;51200 'tbs_outcalls_data2014_10_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_09_usage_pct'=6.15%;87;95 'tbs_outcalls_data2014_09_usage'=3148MB;44544;48640;0;51200 'tbs_outcalls_data2014_09_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_08_usage_pct'=6.34%;87;95 'tbs_outcalls_data2014_08_usage'=3248MB;44544;48640;0;51200 'tbs_outcalls_data2014_08_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_07_usage_pct'=6.34%;87;95 'tbs_outcalls_data2014_07_usage'=3248MB;44544;48640;0;51200 'tbs_outcalls_data2014_07_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_06_usage_pct'=6.15%;87;95 'tbs_outcalls_data2014_06_usage'=3148MB;44544;48640;0;51200 'tbs_outcalls_data2014_06_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_05_usage_pct'=6.34%;87;95 'tbs_outcalls_data2014_05_usage'=3248MB;44544;48640;0;51200 'tbs_outcalls_data2014_05_alloc'=3548MB;;;0;51200 'tbs_outcalls_data2014_04_usage_pct'=68.96%;87;95 'tbs_outcalls_data2014_04_usage'=91800MB;115814;126464;0;133120 'tbs_outcalls_data2014_04_alloc'=102400MB;;;0;133120 'tbs_outcalls_data2014_03_usage_pct'=74.45%;87;95 'tbs_outcalls_data2014_03_usage'=91480MB;106905;116736;0;122880 'tbs_outcalls_data2014_03_alloc'=97280MB;;;0;122880 'tbs_outcalls_data2014_02_usage_pct'=79.78%;87;95 'tbs_outcalls_data2014_02_usage'=81692MB;89088;97280;0;102400 'tbs_outcalls_data2014_02_alloc'=84992MB;;;0;102400 'tbs_outcalls_data2014_01_usage_pct'=74.30%;87;95 'tbs_outcalls_data2014_01_usage'=91304MB;106905;116736;0;122880 'tbs_outcalls_data2014_01_alloc'=98304MB;;;0;122880 'tbs_outcalls_data13_usage_pct'=60.90%;87;95 'tbs_outcalls_data13_usage'=74750MB;106783;116603;0;122740 'tbs_outcalls_data13_alloc'=85250MB;;;0;122740 'tbs_outcalls_data12_compressed_usage_pct'=50.39%;87;95 'tbs_outcalls_data12_compressed_usage'=46444MB;80179;87552;0;92160 'tbs_outcalls_data12_compressed_alloc'=47644MB;;;0;92160 'tbs_outcalls_data11_compressed_usage_pct'=47.14%;87;95 'tbs_outcalls_data11_compressed_usage'=43444MB;80179;87552;0;92160 'tbs_outcalls_data11_compressed_alloc'=45544MB;;;0;92160 'tbs_outcalls_data10_usage_pct'=32.56%;87;95 'tbs_outcalls_data10_usage'=42010MB;112250;122572;0;129024 'tbs_outcalls_data10_alloc'=118510MB;;;0;129024 'tbs_outcalls_data09_usage_pct'=35.36%;87;95 'tbs_outcalls_data09_usage'=42181MB;103774;113316;0;119281 'tbs_outcalls_data09_alloc'=119281MB;;;0;119281 'tbs_outcalls_data08_usage_pct'=32.49%;87;95 'tbs_outcalls_data08_usage'=40590MB;108687;118681;0;124928 'tbs_outcalls_data08_alloc'=115290MB;;;0;124928 'tbs_outcalls_data03_usage_pct'=94.42%;87;95 'tbs_outcalls_data03_usage'=87020MB;80179;87552;0;92160 'tbs_outcalls_data03_alloc'=88820MB;;;0;92160 'tbs_outcalls_data02_usage_pct'=82.66%;87;95 'tbs_outcalls_data02_usage'=84640MB;89088;97280;0;102400 'tbs_outcalls_data02_alloc'=87040MB;;;0;102400 'tbs_outcalls_data01_usage_pct'=63.89%;87;95 'tbs_outcalls_data01_usage'=98140MB;133632;145920;0;153600 'tbs_outcalls_data01_alloc'=106540MB;;;0;153600 'tbs_outcalls_2nd_indx09_usage_pct'=28.13%;87;95 'tbs_outcalls_2nd_indx09_usage'=11524MB;35635;38912;0;40960 'tbs_outcalls_2nd_indx09_alloc'=12124MB;;;0;40960 'tbs_outcalls_2nd_indx08_usage_pct'=31.80%;87;95 'tbs_outcalls_2nd_indx08_usage'=13024MB;35635;38912;0;40960 'tbs_outcalls_2nd_indx08_alloc'=13924MB;;;0;40960 'tbs_outcalls_2nd_indx07_usage_pct'=31.80%;87;95 'tbs_outcalls_2nd_indx07_usage'=13024MB;35635;38912;0;40960 'tbs_outcalls_2nd_indx07_alloc'=13924MB;;;0;40960 'tbs_outcalls_2nd_data10_usage_pct'=20.48%;87;95 'tbs_outcalls_2nd_data10_usage'=17824MB;75724;82688;0;87040 'tbs_outcalls_2nd_data10_alloc'=18724MB;;;0;87040 'tbs_outcalls_2nd_data09_usage_pct'=24.69%;87;95 'tbs_outcalls_2nd_data09_usage'=20224MB;71270;77824;0;81920 'tbs_outcalls_2nd_data09_alloc'=21424MB;;;0;81920 'tbs_outcalls_2nd_data08_usage_pct'=35.40%;87;95 'tbs_outcalls_2nd_data08_usage'=18124MB;44544;48640;0;51200 'tbs_outcalls_2nd_data08_alloc'=19324MB;;;0;51200 'tbs_mtp_tbs_usage_pct'=19.17%;87;95 'tbs_mtp_tbs_usage'=1570MB;7127;7782;0;8192 'tbs_mtp_tbs_alloc'=5870MB;;;0;8192 'tbs_mcalc2ppc_data_usage_pct'=0.01%;87;95 'tbs_mcalc2ppc_data_usage'=1MB;16035;17510;0;18432 'tbs_mcalc2ppc_data_alloc'=4096MB;;;0;18432 'tbs_indx_usage_pct'=17.94%;87;95 'tbs_indx_usage'=1102MB;5345;5836;0;6144 'tbs_indx_alloc'=1160MB;;;0;6144 'tbs_inccalls_indx_08_usage_pct'=72.95%;87;95 'tbs_inccalls_indx_08_usage'=52292MB;62361;68096;0;71680 'tbs_inccalls_indx_08_alloc'=53492MB;;;0;71680 'tbs_inccalls_indx2014_12_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_12_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_12_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_11_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_11_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_11_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_10_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_10_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_10_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_09_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_09_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_09_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_08_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_08_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_08_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_07_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_07_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_07_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_06_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_06_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_06_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_05_usage_pct'=1.66%;87;95 'tbs_inccalls_indx2014_05_usage'=848MB;44544;48640;0;51200 'tbs_inccalls_indx2014_05_alloc'=2048MB;;;0;51200 'tbs_inccalls_indx2014_04_usage_pct'=78.25%;87;95 'tbs_inccalls_indx2014_04_usage'=56092MB;62361;68096;0;71680 'tbs_inccalls_indx2014_04_alloc'=59392MB;;;0;71680 'tbs_inccalls_indx2014_03_usage_pct'=65.75%;87;95 'tbs_inccalls_indx2014_03_usage'=53860MB;71270;77824;0;81920 'tbs_inccalls_indx2014_03_alloc'=56560MB;;;0;81920 'tbs_inccalls_indx2014_02_usage_pct'=46.82%;87;95 'tbs_inccalls_indx2014_02_usage'=47948MB;89088;97280;0;102400 'tbs_inccalls_indx2014_02_alloc'=49748MB;;;0;102400 'tbs_inccalls_indx2014_01_usage_pct'=72.32%;87;95 'tbs_inccalls_indx2014_01_usage'=51840MB;62361;68096;0;71680 'tbs_inccalls_indx2014_01_alloc'=61440MB;;;0;71680 'tbs_inccalls_data2014_12_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_12_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_12_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_11_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_11_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_11_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_10_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_10_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_10_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_09_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_09_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_09_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_08_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_08_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_08_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_07_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_07_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_07_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_06_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_06_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_06_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_05_usage_pct'=1.07%;87;95 'tbs_inccalls_data2014_05_usage'=548MB;44544;48640;0;51200 'tbs_inccalls_data2014_05_alloc'=2048MB;;;0;51200 'tbs_inccalls_data2014_04_usage_pct'=72.68%;87;95 'tbs_inccalls_data2014_04_usage'=74420MB;89088;97280;0;102400 'tbs_inccalls_data2014_04_alloc'=81920MB;;;0;102400 'tbs_inccalls_data2014_03_usage_pct'=82.05%;87;95 'tbs_inccalls_data2014_03_usage'=75620MB;80179;87552;0;92160 'tbs_inccalls_data2014_03_alloc'=81920MB;;;0;92160 'tbs_inccalls_data2014_02_usage_pct'=94.03%;87;95 'tbs_inccalls_data2014_02_usage'=67400MB;62361;68096;0;71680 'tbs_inccalls_data2014_02_alloc'=70400MB;;;0;71680 'tbs_inccalls_data2014_01_usage_pct'=70.85%;87;95 'tbs_inccalls_data2014_01_usage'=72548MB;89088;97280;0;102400 'tbs_inccalls_data2014_01_alloc'=78848MB;;;0;102400 'tbs_inccalls_data08_usage_pct'=86.12%;87;95 'tbs_inccalls_data08_usage'=70552MB;71270;77824;0;81920 'tbs_inccalls_data08_alloc'=74752MB;;;0;81920 'tbs_dfeed_index_usage_pct'=1.63%;87;95 'tbs_dfeed_index_usage'=50MB;2672;2918;0;3072 'tbs_dfeed_index_alloc'=100MB;;;0;3072 'tbs_dfeed_data_usage_pct'=30.42%;87;95 'tbs_dfeed_data_usage'=6230MB;17817;19456;0;20480 'tbs_dfeed_data_alloc'=20480MB;;;0;20480 'tbs_db_sys_aud$_data_usage_pct'=0.02%;87;95 'tbs_db_sys_aud$_data_usage'=1MB;8908;9728;0;10240 'tbs_db_sys_aud$_data_alloc'=10240MB;;;0;10240 'tbs_db_audit_data_usage_pct'=0.64%;87;95 'tbs_db_audit_data_usage'=130MB;17817;19456;0;20480 'tbs_db_audit_data_alloc'=16620MB;;;0;20480 'tbs_cml_indxq4_usage_pct'=25.66%;87;95 'tbs_cml_indxq4_usage'=1051MB;3563;3891;0;4096 'tbs_cml_indxq4_alloc'=1301MB;;;0;4096 'tbs_cml_indxq3_usage_pct'=13.45%;87;95 'tbs_cml_indxq3_usage'=551MB;3563;3891;0;4096 'tbs_cml_indxq3_alloc'=751MB;;;0;4096 'tbs_cml_indxq2_usage_pct'=21.19%;87;95 'tbs_cml_indxq2_usage'=651MB;2672;2918;0;3072 'tbs_cml_indxq2_alloc'=801MB;;;0;3072 'tbs_cml_indxq1_usage_pct'=11.43%;87;95 'tbs_cml_indxq1_usage'=351MB;2672;2918;0;3072 'tbs_cml_indxq1_alloc'=1251MB;;;0;3072 'tbs_cml_dataq4_usage_pct'=20.14%;87;95 'tbs_cml_dataq4_usage'=825MB;3563;3891;0;4096 'tbs_cml_dataq4_alloc'=1275MB;;;0;4096 'tbs_cml_dataq3_usage_pct'=32.35%;87;95 'tbs_cml_dataq3_usage'=1325MB;3563;3891;0;4096 'tbs_cml_dataq3_alloc'=1525MB;;;0;4096 'tbs_cml_dataq2_usage_pct'=22.00%;87;95 'tbs_cml_dataq2_usage'=901MB;3563;3891;0;4096 'tbs_cml_dataq2_alloc'=1101MB;;;0;4096 'tbs_cml_dataq1_usage_pct'=12.23%;87;95 'tbs_cml_dataq1_usage'=501MB;3563;3891;0;4096 'tbs_cml_dataq1_alloc'=851MB;;;0;4096 'tbs_ccn_indxq4_usage_pct'=54.55%;87;95 'tbs_ccn_indxq4_usage'=39100MB;62361;68096;0;71680 'tbs_ccn_indxq4_alloc'=59800MB;;;0;71680 'tbs_ccn_indxq3_usage_pct'=67.46%;87;95 'tbs_ccn_indxq3_usage'=41450MB;53452;58368;0;61440 'tbs_ccn_indxq3_alloc'=51200MB;;;0;61440 'tbs_ccn_indxq2_usage_pct'=74.54%;87;95 'tbs_ccn_indxq2_usage'=43510MB;50780;55449;0;58368 'tbs_ccn_indxq2_alloc'=49260MB;;;0;58368 'tbs_ccn_indxq1_usage_pct'=41.58%;87;95 'tbs_ccn_indxq1_usage'=28950MB;60579;66150;0;69632 'tbs_ccn_indxq1_alloc'=59900MB;;;0;69632 'tbs_ccn_dataq4_usage_pct'=67.54%;87;95 'tbs_ccn_dataq4_usage'=69160MB;89088;97280;0;102400 'tbs_ccn_dataq4_alloc'=92160MB;;;0;102400 'tbs_ccn_dataq3_usage_pct'=71.34%;87;95 'tbs_ccn_dataq3_usage'=73050MB;89088;97280;0;102400 'tbs_ccn_dataq3_alloc'=87100MB;;;0;102400 'tbs_ccn_dataq2_usage_pct'=76.25%;87;95 'tbs_ccn_dataq2_usage'=76520MB;87306;95334;0;100352 'tbs_ccn_dataq2_alloc'=85020MB;;;0;100352 'tbs_ccn_dataq1_usage_pct'=52.86%;87;95 'tbs_ccn_dataq1_usage'=52508MB;86415;94361;0;99328 'tbs_ccn_dataq1_alloc'=94208MB;;;0;99328 'tbs_auditdbs_usage_pct'=82.28%;87;95 'tbs_auditdbs_usage'=10953MB;11581;12646;0;13312 'tbs_auditdbs_alloc'=12288MB;;;0;13312

Re: check_oracle_health

Posted: Tue Apr 29, 2014 1:29 pm
by slansing
If your command is spewing that much information you are going to want to trim it down to size. It should not be pending just because it is dumping that much information, can you share the service definition? As well as the host definition for the objects in question?

Re: check_oracle_health

Posted: Tue Apr 29, 2014 5:08 pm
by Box293
If you don't want the perfdata to be processed then you can add this directive to your service definition:

Code: Select all

process_perf_data 0
NOTE: This won't reduce the amount of information being received by the service check.

Re: check_oracle_health

Posted: Wed Apr 30, 2014 3:33 am
by hanya.radwan
please find the service definition, and I added(process_perf_data 0), but the same problem
define service {
host_name jaw-cdrs.jawwal.ps
service_description Tablespace Usages
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect "10.100.1.176:1521/ppcalls" --username nagios_appl --password "m0n_4jawwalppcalls50937"!--mode tablespace-usage --report short --warning 87 --critical 95!!!!!!
is_volatile 0
max_check_attempts 10
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
process_perf_data 0
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
contact_groups DBAs
_xiwizard oracletablespace
register 1
}


and host definition:
define host {
host_name jaw-cdrs.jawwal.ps
use xiwizard_linuxserver_host
address 10.100.1.176
hostgroups DBA
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
contact_groups DBAs
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
icon_image solaris.png
statusmap_image solaris.png
_xiwizard nrpe
_xiwizard solaries
register 1
}

Re: check_oracle_health

Posted: Wed Apr 30, 2014 10:30 am
by scottwilkerson
There are 2 solutions I can think of, first would be to modify the plugin, but this would cause all performance data to turn off for the plugin...
around line 4196 comment out the push(@{$self->{nagios}->{perfdata}}, $data); line like so:

Code: Select all

sub add_perfdata {
   my $self = shift;
   my $data = shift;
#   push(@{$self->{nagios}->{perfdata}}, $data);
 }
The second method would be to adjust the size of the columns in the nagios database, to allow this much data, here's how you would do it:

Code: Select all

echo "ALTER TABLE nagios_servicestatus MODIFY perfdata VARCHAR(65536);"|mysql -pnagiosxi nagios
echo "ALTER TABLE nagios_servicechecks MODIFY perfdata VARCHAR(65536);"|mysql -pnagiosxi nagios
echo "ALTER TABLE nagios_hoststatus MODIFY perfdata VARCHAR(65536);"|mysql -pnagiosxi nagios
echo "ALTER TABLE nagios_hostchecks MODIFY perfdata VARCHAR(65536);"|mysql -pnagiosxi nagios

Re: check_oracle_health

Posted: Thu May 01, 2014 4:43 am
by hanya.radwan
I applied the first solution and all of things Ok. thanks very much :)
All times are UTC-05:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited