dbsnmp: one Sun box quits answering for one OID for MRTG

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Thu, 12 Feb 2004 15:49:02 -0600
Message-ID: <152798389421.20040212154902@dfweahs.net>

We use MRTG to do some monitoring of our 8.1.7 databases that are running on Solaris 9 Sparcs, mostly as a visual tool to look back and see when certain things started to happen.

Our MRTG config uses the perl snmp modules to grab stuff from the various machines. One of our long gone DBA's grabbed the scripts from who knows where. It's been working fine, but I've notice that one of our remote machines has quit answering for just one of the OID's that the scripts ask for:

# Database State
$oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2';

This one machine just suddenly quit liking this particular request:

$snmpget -c public -v1 -Ou z1 .1.3.6.1.2.1.39.1.9.1.1.2.2 .1.3.6.1.2.1.39.1.7.1.4
.5.7.100.98.95.110.97.109.101.1 enterprises.111.4.1.1.1.2.5 enterprises.111.4.1. 1.1.4.5 enterprises.111.4.1.1.1.8.5

Error in packet
Reason: (genError) A general failure occured Failed object: 39.1.9.1.1.2.2

39.1.7.1.4.5.7.100.98.95.110.97.109.101.1 = STRING: "DEV"
enterprises.111.4.1.1.1.2.5 = Counter32: 118585464
enterprises.111.4.1.1.1.4.5 = Counter32: 1079032
enterprises.111.4.1.1.1.8.5 = Counter32: 66598668

Curiously, the script never uses the value once it has it, but it's annoying that a machine that is supposed to be identically configured to several other machines quits responding with no apparent provocation for one OID, but continues to answer for the others.

I say supposed to be configured identically, but we're not absolutely sure. We inherited the machine from a sister company and they were supposed to configure it to our instruction. It was responding as expected then just stopped on a day when no changes were being made.

I know there must be some difference as I do see one apparently snmp related process running on the machine that I don't see on the others, atmsnmpd.

I've made my scripts work again by removing the offending but unused OID. But I just don't like it when something changes with no explanation.

Has anyone seen this before when playing with dbsnmp?

-rje

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 12 2004 - 15:49:02 CST