check_oracle_health

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
hanya.radwan
Posts: 194
Joined: Tue Feb 25, 2014 6:12 am
Location: palestine

check_oracle_health

Post 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
Top
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: check_oracle_health

Post 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?
Top
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:
Contact Box293

Re: check_oracle_health

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Top
hanya.radwan
Posts: 194
Joined: Tue Feb 25, 2014 6:12 am
Location: palestine

Re: check_oracle_health

Post 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
}
Top
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:
Contact scottwilkerson

Re: check_oracle_health

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Top
hanya.radwan
Posts: 194
Joined: Tue Feb 25, 2014 6:12 am
Location: palestine

Re: check_oracle_health

Post by hanya.radwan »

I applied the first solution and all of things Ok. thanks very much :)
Top
Locked

Return to “Nagios XI”