RE: monitoring bdd with net-snmp

For Oracle...do this...
 
 Step 1: I found a Doc out on the web on how to configure net-snmp with
oracle, it was out on the net-snmp website, I went looking for it the
other day, but was unable to find it, basically oracle uses a snmp
proxy. Your main snmpd runs on port 1161, you tweak the oracle
encapsulator ( $ORACLE_HOME/network/snmp/peer/CONFIG.encap to include
the 1.3.6.1.2.1.2021 and 1.3.6.1.4.1.2021 oid's for net-snmp and what
port the "agent" (net-snmp) runs at (port 1161). 

Step 2: I changed the CONFIG.master changed the line "ALLOW ALL
OPERATIONS" to "ALLOW GET OPERATIONS" 

Step 3: Tweaked the start_peer, changed some of the SNMPD lines to point
to my net-snmpd.conf file. 

Step 4: Started the peer by running this as root: 
#export ORACLE_HOME=/path/to/your/oracle/dir 
#$ORACLE_HOME/network/snmp/peer/start_peer -a 

Step 5: Start the dbsnmp agent 
#su - oracle 
oracle>lsnrctl dbsnmp_start 

Step 6: check and see if things started: 
#ps -ef |grep snmp 

root 11527 1 0 Sep 26 ? 0:03 /usr/local/ucd-snmp/sbin/snmpd -c
/usr/local/ucd-snmp/share/snmp/snmpd.conf -p 
oracle 11763 1 0 Sep 26 ? 0:46 dbsnmp 
oracle 11764 11763 0 Sep 26 ? 1:09 dbsnmp 

#ps -ef | grep encap 
root 11523 1 0 Sep 26 ? 0:02 ./encap_peer -t 1162 -s 1160 -c
CONFIG.encap 

Then you will have the agent working...
 
You will then need to poll the agent OID. But you need to know which
one. Go here and chose one...
 
http://support.ipmonitor.com/mibs_byoidtree.aspx?oid=1.3.6.1.2.1.39#h
 
I can't tell you what you need to poll, only you will know this.
 
However you will then need to view it. My recomendation is to use Cacti.
 
Go here and download and install...
 
http://www.cacti.net/index.php
 
You may need to look around for a template for a graph for databases. Or
make one ...
 
http://docs.cacti.net/node/79 is a HOW-TO on graph templates.
 
Keep smiling.
 
 
 
 
 
 

________________________________

From: [email protected]
[mailto:[email protected]] On Behalf Of snmp
girl
Sent: 18 March 2008 11:08
To: [email protected]
Subject: Re: monitoring bdd with net-snmp



hi,
I still having problem in using net-snmp to monitor my database, I am
really lost .
I want to know how to configure the net-snmp to give me informations
about my database (oracle or mysql or.....) like the capacity of the
disk used by it and to send me a trap if it used more than a limited
capacity.
I want to know just how to start ??
ah another question , do some softwares like zabbix or bixdata help to
monitor those things ?
 
thanks 
 
2008/3/14, Mike Ayers <[email protected]>: 


	> From: [email protected]
	> [mailto:[email protected]] On
	> Behalf Of snmp girl
	> Sent: Friday, March 14, 2008 2:01 AM
	
	> after configuring the net-snmp and testing sending traps ,
	> now I want to start using it in monitoring my bdd ( sql
	> server or mysql).
	> do u have any ideas , how to start it?
	> for example , should I install some softs or configuring some
	> files or something else?
	
	       We recently had posts from a couple of folk who wanted to
SNMP manage their MySQL installations.  If you can help them find the
MIB, I imagine they could help you with monitoring.  Posting the results
would be appreciated.
	
	
	       HTH,
	
	Mike
	



http://www.vital-group.com      - Dedicated to business communications.
http://www.vital-storage.com    - Secure easy-to-use remote backups for business critical data.

The information contained in this message is intended for the addressee only and may contain confidential and/or privileged information.If you are not the addressee, please delete this message and notify the sender; you should not copy or distribute this message or disclose its contents to anyone.Any views or opinions expressed in this message are those of the author and do not necessarily represent those of The Vital International Group or any of its affiliates.No reliance may be placed on this message without written confirmation from an authorised representative of its contents.

Registered in England. Vital International Limited. Leigh House, Weald Road, Brentwood, Essex, CM14 4SX.Company registration number - 45022560. 

03/18/08 13:57:47

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
Net-snmp-users mailing list
[email protected]
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users