[HOWTO] oracle snmp in Cacti

If you figure out how to do something interesting/cool in Cacti and want to share it with the community, please post your experience here.

Moderators: Developers, Moderators

Post Reply
kevinchang
Posts: 5
Joined: Wed Jan 26, 2005 10:31 pm

[HOWTO] oracle snmp in Cacti

Post by 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 :oops:


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
Top
kevinchang
Posts: 5
Joined: Wed Jan 26, 2005 10:31 pm

Post by kevinchang »

:D
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"
Top
fte107
Posts: 5
Joined: Tue Jun 21, 2005 7:01 am

And now how graph tablespace using oracle template

Post by 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.
Attachments
oracle_capture.jpg
oracle_capture.jpg (45.66 KiB) Viewed 21993 times
Top
fte107
Posts: 5
Joined: Tue Jun 21, 2005 7:01 am

Oracle makes me nuts

Post by 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
Top
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by 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:

Code: Select all

enterprises.111.4.1.1.1.13.2.0.0
However, in Cacti you are polling the following OID:

Code: Select all

enterprises.111.4.1.1.1.13.2.0
Do you see the difference. I will comment on the other issues in my next post.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by 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 :))
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Post Reply

Return to “Informational/HOWTO's”

Who is online

Users browsing this forum: No registered users and 0 guests