How to get ora_smon oracle process monitoring on nagios XI

[thrivikramr]

I am using Nagios XI (2012R1.6) hosted on Centos6.x 64bit manual installation

I have a new oracle db server to be monitred that is Hosted on RedHat.

I am using linux snmp monitoring wizard to put it to monitor using some snmp community string.

But when i try to set up oracle process monitoring, is is unable to match the process.

When i grep into the box, there are 11 processes that matches 'ora_smon'

grep output: oracle 11 1 0 Mar19 ? 00:00:16 ora_smon


COMMAND: /usr/local/nagios/libexec/check_snmp_process_wizard.pl -H host1.domain.com -C comstring --v2c -n "ora_smon" -c '0'
OUTPUT: No process matching ora_smon found : CRITICAL

When i try with name 'ora' it is matching and getting all oracle processes.
COMMAND: /usr/local/nagios/libexec/check_snmp_process_wizard.pl -H host1.domain.com -C comstring --v2c -n "ora" -c '0'
OUTPUT: 527 process matching ora (> 0)


How do I get processes that matches 'ora_smon' or 'ora_smon_<DBNAME>'

[scottwilkerson]

Can you run the following to see if the processes are listed in snmp as ora_smon

Code: Select all

snmpwalk -v 2c -c comstring host1.domain.com 1.3.6.1.2.1.25.4.2.1.2 |grep ora

[thrivikramr]

Thanks for your quick turn around on this, We have already figured it out.

/usr/local/nagios/libexec/check_snmp_process_wizard.pl -H host1.domain.com -f -C comstring -2 -n ora_smon_<DBName>

This does the job for me.

Probably you can advice me on setting up thresholds for these. By default i have --waring 50 --critical 100, which will trigger alerts if x>50 and x>100.

But How can i set the threshold like.... if x<30 - warning and x<20 - critical. --warning 30: --critical 20: will do?

[scottwilkerson]

From the Wizard

Tip: The Warning and Critical fields can contain two numbers separated by a comma that represent thresholds for the number of processes that should be running. A field value of 5,10 would generate a warning or critical alert if there were less than 5 or more than 10 processes found.

so

Code: Select all

-w 20,30 -c 0,20

[thrivikramr]

The same problem raised on setting monitoring for different OS process (daemon).

s aux | grep txphub
root 8065 0.0 0.0 4024 700 pts/0 S+ 09:28 0:00 grep txphub
root 27078 0.3 0.7 100452 66104 ? Sl Feb20 247:33 /opt/txp/bin/python /opt/txp/Products/TxpHub/txphub.py --configfile /opt/txp/etc/txphub.conf --cycle --daemon


I am using check_xi_service_snmp_linux_process! -C public --v2c -n 'txphub' -c '0' where I am unable to get any process matching.

Instead if I use check_xi_service_snmp_linux_process! -C public --v2c -n 'txp' -c '0' then 16 processes are matching and I can do it by heck_xi_service_snmp_linux_process! -f -C public -2 -n txp -c '0' which gives me the same result.

Any suggestions on this..!

[sreinhardt]

Without digging into the code of the plugin, I believe that your pattern may be the cause of the issue. It would seem that the plugin is matching whole words and potentially portions of strings if separated by special characters like /. Can you try some different patters such as "TxpHub" "txphub.py" "txphub.conf". If those work, you should ideally be able to workout a unique string that works for you.

[thrivikramr]

Yup, I tried these patterns, none of them has worked for me.

[scottwilkerson]

Lets try

Code: Select all

check_xi_service_snmp_linux_process! -C public --v2c -n 'python' -A '/opt/txp/Products/TxpHub/txphub.py' -c '0'

[thrivikramr]

That is giving a error message

ERROR: Process param table : Message size exceeded buffer maxMsgSize.

[abrist]

Getting : "ERROR: Size table :Message size exceeded buffer maxMsgSize"
Your snmp table is too big. Try passing "-o 5000".