Linux NET-SNMP MRTG Oracle
Thomas Willomitzer
Yes, you have to specify two sources. I didn't notice that in your
conf.
kind regards,
Ivan
-----Original Message-----
From: Willomitzer Thomas [mailto:Thomas.Wi...@kuoni.at]
Sent: dinsdag 5 november 2002 11:31
To: 'Saez Scheihing, I.A.'
Subject: AW: oracle snmp stuff
Hello Ivan,
the mib resolution was no problem...but now i understood how mrtg
works...
unless you provide two mib sources source1&source2...mrtg tries to get
ifInOctets.2 ifOutOctets.2 for a single mib...
Your mrtg.cfg line
Target[ivan]: 1.3.6.1.2.1.27.1.1.8.2&.1.3.6.1.2.1.27.1.1.8.2:public@localhost
is composed of two sources and that's why it works
The single mib line
Target[ivan]: 1.3.6.1.2.1.27.1.1.8.2:public@localhost (requires
ifInOctets.2 ifOutOctets.2)
produces errors
The Errors for
sysUptime sysName on public@localhost
disappear with the nomib2 keyword in mrtg.cfg
thanks a lot
Thomas
p.s. maybe we should publish this thread somewhere...
-----Ursprüngliche Nachricht-----
Von: Saez Scheihing, I.A. [mailto:I.A.Saez....@tue.nl]
Gesendet: Dienstag, 05. November 2002 07:35
An: 'Willomitzer Thomas'
Betreff: RE: oracle snmp stuff
Thomas,
It seems that your problem is more related to mrtg than Oracle-snmp.
The error :
error status: noSuchName
index 4 (OID: 1.3.6.1.2.1.1.5.0)
indicates that mrtg can't read the sysname and that it expects a
number but it gets a empty string.
Did you define the MIBDIRS environment variable? Probably mrtg isn't
able to locate the mibs.
Try this simple mrtg conf I use
YLegend[ivan]: Oracle
ShortLegend[ivan]: connecties
Legend1[ivan]: Oracle connecties
Legend2[ivan]:
Legend3[ivan]: Max Observed Oracle connecties
Legend4[ivan]:
LegendI[ivan]: Oracle :
LegendO[ivan]:
WithPeak[ivan]: ywm
MaxBytes[ivan]: 15
Options[ivan]: growright, gauge, nopercent
Workdir: /home/oracle/product/8.1.7/Apache/Apache/htdocs/mrtg
Target[ivan]: 1.3.6.1.2.1.27.1.1.8.2&.1.3.6.1.2.1.27.1.1.8.2:public@localhost
Title[ivan]: Oracle Hits
PageTop[ivan]: <H2>Oracle Statistics: aantal connecties</H2>
Thus try to use the oid number instead of the variable name.
kind regards,
Ivan
-----Original Message-----
From: Willomitzer Thomas [mailto:Thomas.Wi...@kuoni.at]
Sent: maandag 4 november 2002 17:44
To: 'Saez Scheihing, I.A.'
Subject: AW: oracle snmp stuff
hello....
there is a little problem left....
seems like snmpwalk can get all the data but mrtg fails........
please help me again before you post your cv to oracle :)....
cheers
thom
if i do
--------------------------------------------------------------------------------------------
[root@stream mrtg]# snmpwalk -m all localhost public
oraDbTablespaceSizeUsed.2.2
enterprises.oracle.oraDbMIB.oraDbObjects.oraDbTablespaceTable.oraDbTablespaceEntry.oraDbTablespaceSizeUsed.2.2
= 148480
--------------------------------------------------------------------------------------------
i get the correct usage of the tablespace of 148480kb
when i write this in the mrtg.conf there comes an error
--------------------------------------------------------------------------------------------
[root@stream mrtg]# mrtg /etc/mrtg/mrtg.cfg
SNMP Error:
Received SNMP response with error code
error status: noSuchName
index 4 (OID: 1.3.6.1.2.1.1.5.0)
SNMPv1_Session (remote host: "localhost" [127.0.0.1].161)
community: "public"
request ID: 1831483728
PDU bufsize: 8000 bytes
timeout: 2s
retries: 5
backoff: 1)
at /usr/bin/../lib/mrtg2/SNMP_util.pm line 450
SNMPGET Problem for ifInOctets.2 ifOutOctets.2 sysUptime sysName on
public@localhost
at /usr/bin/mrtg line 1491
WARNING: Expected a number but got ''
WARNING: Expected a number but got ''
Scalar found where operator expected at (eval 13) line 1, near "2. $"
(Missing operator before $?)
ERROR: Target[lastfm.tablespace] eval warning: syntax error at (eval
13) line 1, near "2. $"
--------------------------------------------------------------------------------------------
content of mrtg.conf
--------------------------------------------------------------------------------------------
# Minimal mrtg.cfg
#--------------------
LoadMIBs: /usr/share/snmp/mibs/UCD-SNMP-MIB.txt,/usr/share/snmp/mibs/oradb.v1
WorkDir: /web/site/html/admin/mrtg
Target[eth0]: 2:public@localhost:1161
MaxBytes[eth0]: 12500000
Title[eth0]: LAST.FM Traffic Analysis
PageTop[eth0]: <H1>LAST.FM Traffic Analysis</H1>
BodyTag[eth0]: <body bgcolor="#837456" link="#DDDDDD">
Target[cpusum]:ssCpuRawUser.0&ssCpuRawUser.0:public@localhost:1161 +
ssCpuRawSystem.0&ssCpuRawSystem.0:public@localhost:1161 +
ssCpuRawNice.0&ssCpuRawNice.0:public@localhost:1161
RouterUptime[cpusum]: public@localhost:1161
MaxBytes[cpusum]: 100
Title[cpusum]: CPU LOAD
PageTop[cpusum]: <H1>Active CPU Load %</H1>
BodyTag[cpusum]: <body bgcolor="#837456" link="#DDDDDD">
Unscaled[cpusum]: ymwd
ShortLegend[cpusum]: %
YLegend[cpusum]: CPU Utilization
Legend1[cpusum]: Active CPU in % (Load)
Legend2[cpusum]:
Legend3[cpusum]:
Legend4[cpusum]:
LegendI[cpusum]: Active
LegendO[cpusum]:
Options[cpusum]: growright,nopercent
Target[lastfm.tablespace]:
oraDbTablespaceSizeUsed.2.2:public@localhost
RouterUptime[lastfm.tablespace]: public@localhost:1161
MaxBytes[lastfm.tablespace]: 100
Title[lastfm.tablespace]: Oracle lastfm tablespace usage
PageTop[lastfm.tablespace]: <H1>Oracle lastfm tablespace usage %</H1>
BodyTag[lastfm.tablespace]: <body bgcolor="#837456" link="#DDDDDD">
Unscaled[lastfm.tablespace]: ymwd
ShortLegend[lastfm.tablespace]: %
YLegend[lastfm.tablespace]: Tablespace Usage
Legend1[lastfm.tablespace]: Usage in %
Legend2[lastfm.tablespace]:
Legend3[lastfm.tablespace]:
Legend4[lastfm.tablespace]:
LegendI[lastfm.tablespace]: Used
LegendO[lastfm.tablespace]:
Options[lastfm.tablespace]: growright,nopercent
--------------------------------------------------------------------------------------------
-----Ursprüngliche Nachricht-----
Von: Saez Scheihing, I.A. [mailto:I.A.Saez....@tue.nl]
Gesendet: Montag, 04. November 2002 16:26
An: 'Willomitzer Thomas'
Betreff: RE: oracle snmp stuff
Thomas,
I'm glad it works for you! I think I'll send my CV to Oracle:-)
If you want to play with Mrtg then let me know. I have a Mrtg website.
kind regards,
Ivan
p.s. all the snmp stuff is poorly supported by Oracle (IMHO). In all
their online support databases, Metalink,
technet, etc there is nothing to be found about oranamesmib.
-----Original Message-----
From: Willomitzer Thomas [mailto:Thomas.Wi...@kuoni.at]
Sent: maandag 4 november 2002 16:19
To: 'Saez Scheihing, I.A.'
Subject: AW: oracle snmp stuff
WOW!
Never got such precise help!
after editing the .v1 file and
lsnrctl dbsnmp_stop
lsnrctl dbsnmp_start
lsnrctl stop
lsnrctl start
everything works!
thanks for the help!
made my day...
Cheers
Thomas
-----Ursprüngliche Nachricht-----
Von: Saez Scheihing, I.A. [mailto:I.A.Saez....@tue.nl]
Gesendet: Montag, 04. November 2002 16:10
An: 'Willomitzer Thomas'
Betreff: RE: oracle snmp stuff
Willomitzer ,
Did you start de intelligent agent (lsnrctl dbsnmp_start)?
My sequence for starting everything is:
....
....
echo "starting snmp peer"
$ORA_HOME/network/snmp/peer/start_peer -a
sleep5
echo "Starting Oracle Databases (zie /var/opt/oracle/oratab)"
$SU - $ORA_OWNER -c "$ORA_HOME/bin/dbstart"
sleep 5
echo "Starting Oracle Intelligent Agent (dbsnmp)"
$SU - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl dbsnmp_start"
sleep 5
echo "Starting Oracle Names"
$SU - $ORA_OWNER -c "$ORA_HOME/bin/namesctl start"
sleep 5
echo "Starting Oracle Listener"
$SU - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
....
....
When you do a lsnrctl status do you see: SNMP ON or SNMP OFF?
Try a snmpwalk -m all localhost public oraListenerTable to poll the
listener or
a snmpwalk -m all localhost public rdbmsMIB to poll the rdbmsMIB
The *.v1 files are not correct. In the onrs.v1 file you have to edit
the
import section:
Counter
FROM RFC1155-SMI
becomes
Counter, enterprises
FROM RFC1155-SMI
-----Original Message-----
From: Willomitzer Thomas [mailto:Thomas.Wi...@kuoni.at]
Sent: maandag 4 november 2002 15:22
To: 'Saez Scheihing, I.A.'
Subject: AW: oracle snmp stuff
config:
oracle 8.1.7.0
Redhat 7.3
NET-SNMP version: 5.0.6
mrtg-2.9.17
What i did (maybe completely wrong...)
installed net-snmp, made it work for cpuload and eth0 traffic
mrtg reporting cpuload and eth0
Then thought would be nice to monitor oracle tablespaces
edited the following files:
$ORACLE_HOME/network/snmp/peer/CONFIG.master
----------------------------------------------------------
TRANSPORT ordinary SNMP
OVER UDP SOCKET
AT PORT 161
COMMUNITY public
ALLOW ALL OPERATIONS
USE NO ENCRYPTION
MANAGER localhost
SEND ALL TRAPS
WITH COMMUNITY PUBLIC
----------------------------------------------------------
$ORACLE_HOME/network/snmp/peer/CONFIG.encap
----------------------------------------------------------
AGENT AT PORT 1161 WITH COMMUNITY public
SUBTREES 1.3.6.1.2.1.1,
1.3.6.1.2.1.2,
1.3.6.1.2.1.3,
1.3.6.1.2.1.4,
1.3.6.1.2.1.5,
1.3.6.1.2.1.6,
1.3.6.1.2.1.7,
1.3.6.1.2.1.8,
1.3.6.1.4.1.11.2
FORWARD ALL TRAPS;
----------------------------------------------------------
copied the $ORACLE_HOME/network/doc/*.v1 into /usr/share/snmp/mibs
in the snmpd.conf (net-snmp) i added the line
---------------------------------------------------------
agentaddress 1161
---------------------------------------------------------
to let it listen to 1161 instead of 161 (which is now reserverd by the
oracle master agent)
killed the snmpd process
then started with
start_peer -a
works fine for me:
> snmpget -p 1161 localhost public system.sysUpTime.0
system.sysUpTime.0 = Timeticks: (249785) 0:41:37.85
> snmpget -p 161 localhost public system.sysUpTime.0
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: system.sysUpTime.0
is there any major mistake / misunderstanding....
the port swapping seems a bit strange ...
Thanks in advance
thomas
-----Ursprüngliche Nachricht-----
Von: Saez Scheihing, I.A. [mailto:I.A.Saez....@tue.nl]
Gesendet: Montag, 04. November 2002 15:13
An: 'Willomitzer Thomas'
Betreff: RE: oracle snmp stuff
Hi Willomitzer,
Yes I did solve the problems. I can query the listener, rdbms and
database mib. Only the Oracle Names
mib is still a problem. My conf is:
- oracle 8.1.7.4
- Redhat Linux 7.3
- ucd-snmp 4.2.4
- mrtg 2.9.18
Tell me what your problem is and maybe I can help you.
kind regards,
Ivan
-----Original Message-----
From: Willomitzer Thomas [mailto:Thomas.Wi...@kuoni.at]
Sent: maandag 4 november 2002 15:06
To: 'i.a.saez....@tue.nl'
Subject: oracle snmp stuff
Hello Ivan!
Have you solved your problems with snmp? I am in the same situation...
What have you done to make it work?
Thanks in advance
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Hi,
I'm very close to solve my problem (to make Oracle snmp work with
ucd-snmp). I can now poll the rdbms-mib (in database.v1):
oracle@linux:~/OraHome1/network/log > snmpget -m all localhost public
rdbmsDbName.2
rdbmsMIB.rdbmsObjects.rdbmsDbTable.rdbmsDbEntry.rdbmsDbName.2 =
"IVAN.tue.nl"
but when I try to pool the listener mib I get:
oracle@linux:~/OraHome1/network/log > snmpget -m all localhost public
oraListenAddress.1
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object:
enterprises.oracle.oraListenerMIB.oraListenerObjects.oraListenAddressTable.oraListenAddressEntry.oraListenAddress.1
I've also tried snmpwalk -m all localhost public
enterprises.oracle.oraListenerMIB
but without results. Any ideas?
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
Thomas Willomitzer
IT Development
Kuoni Reisebüro Ges.m.b.H.
Modecenterstrasse 16, A-1030 VIENNA, AUSTRIA
Tel: +43 1 514 78 487
Fax: +43 1 514 78 9480