Firstly, you will probably want to enable the native Oracle SNMP agent. That will provide a wide array of traps and values. The documentation for your Oracle database will have specific instructions on how to set this up.
If you just want to run a "generic" SNMP agent, then you're probably going to have to use the "Arbitrary Extension Commands" directives, specifically the "extend" directive. Using the "extend" directive requires you to use a fairly recent version of Net-SNMP. What this command allows you to do is to run a script that gets the information you want from Oracle, and then output it. You assign an OID to that script that can then be called using standard snmpget, etc. commands. These directives are placed in the snmpd.conf file. I use the deprecated (i.e., it's going away) "exec" directive because many of my servers are Solaris, which by default uses an older version of Net-SNMP that does not support the "extend" directive. However, it is my understanding that the syntax of the "exec" and "extend" directives is fairly similar. I have a script that makes a sqlplus call to the Oracle database, and retrieves a specific value. This value is stored in a file. My extension directive then simply reads this file. The reason I read a file rather than directly execute the sqlplus script is that SNMP may time out waiting for sqlplus to complete. Therefore, my sqlplus scripts are run by cron every 5 minutes and the results written to specific files. You do not have to do it this way. You can call the sqlplus script directly and simply set a long enough timeout on the call. I have never generated traps from this, but you can do that using cron, a script that retrieves a value from Oracle and compares it to a "threshold" value, and the snmptrap command. The documentation for Net-SNMP is at: http://www.net-snmp.org/docs/readmefiles.html For the "extension" command, you need to refer to the Man pages for the snmpd.conf file. The section on "Arbitrary Extension Commands" is not very extensive, so you're going to have to dig around to make it work. If I were you, I'd look to the native Oracle agent first, then try the above if that doesn't work for you. Michael Peoples Senior Systems Manager AT&T - ATTSI Office: 614-789-8559 Cell: 614-886-0923 FAX: 614-789-8975 [email protected] <mailto:[email protected]> From: Bufalo [mailto:[email protected]] Sent: Monday, May 03, 2010 4:12 AM To: [email protected] Subject: consultation Hi, I just need to receive and send traps and save it to an oracle bbbdd in a Linux, so what module do you recommend me to use? java, perl module?,etc.. Additionally, I would appreciate if you tell me where to find all documentation on installation and administration. Thank you very much !!
------------------------------------------------------------------------------
_______________________________________________ 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
