[HOWTO] oracle snmp in Cacti

[kevinchang]

Dear Sirs
there is a problem : i can get snmp-value by using snmpget :
for example :
[cactiuser@dbateam cactiuser]$ snmpget -Os -v 1 -c public 172.16.28.223 .1.3.6.1.4.1.111.4.1.1.1.13.2.0.0
enterprises.111.4.1.1.1.13.2.0.0 = Counter32: 0

but i cannot using ""Get SNMP Data"" to graphic ,
i execute command :
% /www/php/bin/php /www/htdocs/cacti/poller.php
the result :
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: enterprises.111.4.1.1.1.13.2.0

please help me to make it success. thank a lot


Dear Sirs
the root cause of this error is "oracle mib file" , i try to edit oradb.v1 , and marked one line. try cacti again, it can work smothly. thanks

[kevinchang]

Step 0 : Enverionment

OS : SunOS dbateam 5.8
Oracle Version: 8.1.6

Step 1 : Stop Sun's snmpdx process.

login as root account:
1-0
%ps -ef | grep snmp | grep -v grep
root 6438 1 0 Sep 10 ? 0:01 /usr/lib/dmi/snmpXdmid -s bscss02d
root 6427 1 0 Sep 10 ? 0:20 /usr/lib/snmp/snmpdx -y -c /etc/snmp/conf
%
%kill -9 6438 6427

1-2
# ps -ef | grep mib
root 6405 1 0 Nov 01 ? 0:24 mibiisa -r -p 32934
root 2373 1 0 Oct 21 ? 3:23 mibiisa -r -p 32882
root 6512 1 0 Nov 01 ? 0:25 mibiisa -r -p 32956
root 6578 1 0 Nov 01 ? 0:26 mibiisa -r -p 32977
root 6620 1 0 Nov 01 ? 0:01 mibiisa -r -p 32998
root 6558 1 0 Nov 01 ? 0:24 mibiisa -r -p 32972
root 6434 1 0 Nov 01 ? 0:30 mibiisa -r -p 32941
root 7284 7280 0 19:03:46 ? 0:00 mibiisa -r -p 40714
# kill -9 6405 2373 6512 6578 6620 6434 7284

1-3
check process of oracle snmp
%ps -ef | grep peer
root 6607 1 0 Nov 01 ? 0:06 ./encap_peer -t 1162 -s 1160 -c CONFIG.encap
root 6605 1 0 Nov 01 ? 0:13 ./master_peer CONFIG.master NOV
%kill -9 6607 6605


Step 2 : Start Oracle Snmp

2-0: check $ORACLE_HOME/network/snmp/peer/CONFIG.master
COMMUNITY public
ALLOW ALL OPERATIONS
USE NO ENCRYPTION
MANAGER xxx.xxx.xxx.xxx
SEND ALL TRAPS

2-1: check $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;

2-3: check start_peer
SNMPD=/usr/lib/snmp/snmpdx
SNMPD_CONFIG=/etc/snmp/conf
SNMPD_OPTIONS=-y


2-4: loging as root

%/bin/ksh
%export ORACLE_HOME=/oracle/816/product/8.1.6
%cd $ORACLE_HOME/network/snmp/peer/
%./start_peer -a
Starting master_peer ...
./master_peer CONFIG.master NOV >master_peer.out 2>&1 &
Done!

Starting encap_peer ...
./encap_peer -t 1162 -s 1160 -c CONFIG.encap >encap_peer.out 2>&1 &
Done!

Starting /usr/lib/snmp/snmpdx ...
/usr/lib/snmp/snmpdx -y -c /etc/snmp/conf -p 1161 >snmpd.out 2>&1 &
Done!

check files ( master_peer.out,encap_peer.out,snmpd.out )
there will be no content,if start oracle snmp success,like ..
%ls -ltr *.out
-rw-r--r-- 1 root other 0 nov 2 19:11 master_peer.out
-rw-r--r-- 1 root other 0 nov 2 19:11 encap_peer.out
-rw-r--r-- 1 root other 0 nov 2 19:11 snmpd.out

startup oracle listener for dbsnmp
su - oracle account
%lsnrctl
%LSNRCTL>dbsnmp_start

2-5: check result

login host that has net-snmp

%snmpwalk -Os -v 1 -c public 172.16.28.223 1.3.6.1.4.1.111
Note:
172.16.28.223 --> hostname IP
1.3.6.1.4.1.111 --> ORACLE MIB Tree start
Reference Paper --> oracle_oid.txt
Result:
enterprises.111.4.1.1.1.1.2 = Counter32: 11
enterprises.111.4.1.1.1.2.2 = Counter32: 125978
enterprises.111.4.1.1.1.3.2 = Counter32: 724
enterprises.111.4.1.1.1.4.2 = Counter32: 34981
enterprises.111.4.1.1.1.5.2 = Counter32: 0
enterprises.111.4.1.1.1.6.2 = Counter32: 40980
enterprises.111.4.1.1.1.8.2 = Counter32: 40969
enterprises.111.4.1.1.1.9.2 = Counter32: 184
enterprises.111.4.1.1.1.10.2 = Counter32: 484
enterprises.111.4.1.1.1.11.2 = Counter32: 0
enterprises.111.4.1.1.1.12.2 = Counter32: 6
enterprises.111.4.1.1.1.13.2 = Counter32: 0
enterprises.111.4.1.1.1.14.2 = Counter32: 727
enterprises.111.4.1.1.1.15.2 = Counter32: 13961
enterprises.111.4.1.1.1.16.2 = Counter32: 3500
enterprises.111.4.1.1.1.17.2 = Counter32: 32
enterprises.111.4.1.1.1.18.2 = Counter32: 67505
enterprises.111.4.1.1.1.19.2 = Counter32: 243864
enterprises.111.4.1.1.1.20.2 = Counter32: 3942
enterprises.111.4.1.1.1.21.2 = Counter32: 1125
enterprises.111.4.1.1.1.22.2 = Counter32: 11646
enterprises.111.4.1.1.1.23.2 = Counter32: 2
enterprises.111.4.1.1.1.24.2 = Counter32: 0
enterprises.111.4.1.1.1.25.2 = Counter32: 0
enterprises.111.4.1.2.1.1.2.1 = INTEGER: 1
enterprises.111.4.1.2.1.1.2.2 = INTEGER: 2
enterprises.111.4.1.2.1.1.2.3 = INTEGER: 3
enterprises.111.4.1.2.1.1.2.4 = INTEGER: 4
enterprises.111.4.1.2.1.2.2.1 = STRING: "DATA"
enterprises.111.4.1.2.1.2.2.2 = STRING: "RBS"
enterprises.111.4.1.2.1.2.2.3 = STRING: "SYSTEM"
enterprises.111.4.1.2.1.2.2.4 = STRING: "TEMP"
enterprises.111.4.1.2.1.3.2.1 = INTEGER: 10240
enterprises.111.4.1.2.1.3.2.2 = INTEGER: 20480
enterprises.111.4.1.2.1.3.2.3 = INTEGER: 204800
enterprises.111.4.1.2.1.3.2.4 = INTEGER: 20480
enterprises.111.4.1.2.1.4.2.1 = INTEGER: 8
enterprises.111.4.1.2.1.4.2.2 = INTEGER: 6248
enterprises.111.4.1.2.1.4.2.3 = INTEGER: 47504
enterprises.111.4.1.2.1.4.2.4 = INTEGER: 8
enterprises.111.4.1.2.1.5.2.1 = INTEGER: 1
enterprises.111.4.1.2.1.5.2.2 = INTEGER: 1
enterprises.111.4.1.2.1.5.2.3 = INTEGER: 1
enterprises.111.4.1.2.1.5.2.4 = INTEGER: 1
enterprises.111.4.1.2.1.6.2.1 = INTEGER: 10232
enterprises.111.4.1.2.1.6.2.2 = INTEGER: 14232
enterprises.111.4.1.2.1.6.2.3 = INTEGER: 156336
enterprises.111.4.1.2.1.6.2.4 = INTEGER: 20472
enterprises.111.4.1.3.1.1.2.1 = INTEGER: 1
enterprises.111.4.1.3.1.1.2.2 = INTEGER: 2
enterprises.111.4.1.3.1.1.2.3 = INTEGER: 3
enterprises.111.4.1.3.1.1.2.4 = INTEGER: 4
enterprises.111.4.1.3.1.2.2.1 = STRING: "/oradata/ORA816/system01.dbf"
enterprises.111.4.1.3.1.2.2.2 = STRING: "/oradata/ORA816/rbs01.dbf"
enterprises.111.4.1.3.1.2.2.3 = STRING: "/oradata/ORA816/temp01.dbf"
enterprises.111.4.1.3.1.2.2.4 = STRING: "/oradata/ORA816/data01.dbf"

[fte107]

Hi kevinchang,

Do you know how graph oracle tablespace using templates supplied by o_dupuis ??

Because I've got all running process (peer + dbsnmp) but no graphs.

Thanks in advance if you can help me ....

See attachements below. Must I fill -> Index Type -> Index value and Output type Id ??

Can you give me an example, please, if you have alredy successfully graph something with Oracle.

[fte107]

Hi all,

If someone have successfully graph Oracle Tablespace, I need to understand how fill Index type and cie..... because all i have got is

RRDTool Says:

ERROR: Could not parse color in ''

when i look in graph management for "Oracle TableSpace Size - |query_DbName| - |query_TableSpaceName|

Thanks a lot because I'm not a developer and even less database administrator

[TheWitness]

kevinchang,

Please note in your initial post, when you performed the snmpget from the command line you performed the get on the following OID:

[TheWitness]

fte107,

The RRD error message is typically associated with a graph function with no associated DS specifcation in the Graph Syntax. In other words, the graph is not currently associated with a Data Source. I can't help other than that for the reason below.

TheWitness

(In Washington DC at the moment, about to go downtown on the 4th of July, might see Ian there )