Page 1 of 2

How to get ora_smon oracle process monitoring on nagios XI

Posted: Wed Mar 27, 2013 3:51 am
by 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>'

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Wed Mar 27, 2013 6:56 am
by 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

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Wed Mar 27, 2013 7:59 am
by 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?

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Wed Mar 27, 2013 8:33 am
by 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

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Thu Apr 11, 2013 9:08 am
by 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..!

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Fri Apr 12, 2013 3:13 pm
by 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.

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Sun Apr 14, 2013 12:37 pm
by thrivikramr
Yup, I tried these patterns, none of them has worked for me.

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Mon Apr 15, 2013 11:24 am
by 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'

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Mon Apr 15, 2013 11:47 am
by thrivikramr
That is giving a error message

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

Re: How to get ora_smon oracle process monitoring on nagios

Posted: Mon Apr 15, 2013 2:56 pm
by abrist
Getting : "ERROR: Size table :Message size exceeded buffer maxMsgSize"
Your snmp table is too big. Try passing "-o 5000".