Nagios Support Forum

You have a good point, I checked all of the plugin options and I do not see a check that checks DB status specifically, you would need to use the Oracle Query wizard to query something in the database that should exist, if it fails the DB isn't up, you would need to infer the DB isn't up based on that check failing.

You could use check_oracle (should be on your XI server but is meant to be run on the remote Oracle system) but you would need to call it through an agent such as NCPA/NRPE/NSClient++ or though SSH Proxy wizard.
Are you currently monitoring it with an agent?

I got this below query, however I dont get the o/p can u plz help me with it, I have used oracle query wizard.

[root@SPSLNAGIOS ~]# /usr/local/nagiosxi/etc/configwizards/oracle/oracle && /usr/local/nagios/libexec/check_oracle_health --connect '192.168.16.225:1521/SBD' --username 'hpemon' --password 'oradbmon' --mode sql --name="select instance_name,uptime from (select round((cast(current_timestamp as date) - cast((select startup_time from v$instance ) as date))* 24 * 60 * 60) as uptime from dual), v$instance" --warning 50 --critical 200
UNKNOWN - got no valid response for select instance_name,uptime from (select round((cast(current_timestamp as date) - cast((select startup_time from v ) as date))* 24 * 60 * 60) as uptime from dual), v - ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 164 in 'select instance_name,uptime from (select round((cast(current_timestamp as date) - cast((select startup_time from v ) as date))* 24 * 60 * 60) as uptime from dual), <*>v')

These Oracle are hosted on HP-UX servers, which are discovered via SNMP on NAgios.

Adding to this I would also like to know how can we monitor pmon and smon process(remember I just have snmp enabled and there is no agent installed), i tried to discover the server and check on the process it discovers and could not find the pmon or smon process.

I talked to you earlier today about the Oracle Query and determined that it has to be adjusted to poll the data from the specific database.

About your SNMP issue, he do not have access to an HP-UX server to test some commands / settings for you but it may be a setting in the SNMP daemon running on the HP-UX server to allow the processes to be polled.

You would have to add this OID .1.3.6.1.2.1.25.4 to the snmp daemons config file to allow poling but I could not find an example on where or how to do that.

But, if your HP-UX server is running the NET-SNMP daemon, you would add the following line to the snmpd.conf file and restart snmpd. Your server has to be running the NET-SNMP package for this to work and it may not be using it.

Thank you.

I had informed the HP-UX team to check on the options mentioned by you and here is the response, please suggest how else can we achieve this:

On the server “saledev” I searched for the file snmpd.conf file and here is the list:

Net-SNMP.NET-SNMP-MAN: /opt/iexpress/net-snmp/man/man3/snmpd.conf.5.def
Net-SNMP.NET-SNMP-MAN: /opt/iexpress/net-snmp/man/man5/snmpd.conf.5
Net-SNMP.NET-SNMP-SHA: /opt/iexpress/net-snmp/share/man/man3/snmpd.conf.5.def
Net-SNMP.NET-SNMP-SHA: /opt/iexpress/net-snmp/share/man/man5/snmpd.conf.5
OVSNMPAgent.MASTER: /etc/SnmpAgent.d/snmpd.conf
OVSNMPAgent.MASTER: /usr/newconfig/etc/SnmpAgent.d/snmpd.conf
OVSNMPAgent.SNMP-ENG-A-MAN: /opt/OV/man/man4.Z/snmpd.conf.4
OVSNMPAgent.SNMP-ENG-A-MAN: /usr/share/man/man4.Z/snmpd.conf.4

Except the one I heighted (in yellow), the rest are all manual pages.

And the file /etc/SnmpAgent.d/snmpd.conf is used by “HP / SNMP Research EMANATE SNMP” here is an excerpt from the file that confirms it:


# The EMANATE SNMP Agent included with HP OpenView Network Node Manager
# uses two configuration files to initialize operational settings on agent
# startup. They are:
#
# snmpd.conf Provides an HP OpenView SNMP Agent compatible
# (this file) configuration file format for the EMANATE SNMP
# Agent. The configuration values in this file
# override and/or supplement the configuration
# in snmpd.cnf.
#
# snmpd.cnf Provides non-volatile storage of configuration
# parameters. The snmpd.cnf is automatically
# updated (re-written) by EMANATE on startup and
# as result of SNMP Set requests that modify the
# configuration values.
#
# HP does NOT recommend that you edit snmpd.cnf
# unless you are an advanced EMANATE user.

The Net-SNMP daemon does not use this file at all. So, there is no point in editing this file. Also, the synrax for “VIEW” is:

get-community-name: <name> IP: <ip_address_list> VIEW: <view_list>

For example:

get-community-name operator VIEW: mib-2 hp

This allows access using community "operator" to all MIB objects under "mib-2" plus all objects under the "hp" sub-tree.

SNMPv3 does not use “community-name” which further proves that the mentioned config is not possible on HP-UX server (using SNMPv3). Please check with the respective team and let us know.

I did a little searching on the Internet and is looks like the MIB / OID required to gather the data you are looking for is not supported on HPUX when using EMANATE SNMP.

If you can remove the EMANATE SNMP package and install the NET-SNMP daemon, that might work for you.

Contact HP for those instructions. Every link I found are no longer valid.

Thank you.