Oracle Database Discussions

http://tinyurl.com/35qxtmp

----------
Sybrand Bakker
Senior Oracle DBA

that sounds like a job for a different piece of software such as a management station or you could write one yourself. it's not exactly the job of a db server, unless you are referring to something else.

No. You need to write a SNMP client that can read SNMP packets and then insert it into the database.

Alternatively, write a MIBs client and read that stats data using MIBs from the switch and insert the results into Oracle.

Perl has MIB and SNMP libraries if I'm not mistaken - and Perl can easily connect to Oracle and insert data.

If you want to do this from inside Oracle.. UDP protocol is not supported by PL/SQL. Only TCP. So you will need to write your own network library (via Java or external procs) and hook that into PL/SQL. Not a trivial task. Alternatively, move this entirely into the Java layer and use Java stored procs instead - but I expect that you will need to load additional jars for this and punch open holes in the Java sandbox.

Ok, Thank you!
I'm not good at perl or java. Have you seen a ready made solution?
Do you have information in near feature is this going to be supported?

regards

Edited by: user10484841 on Sep 10, 2010 3:14 AM

SNMP and MIBs? Yes. But that is in-house developed s/w - copyrighted and so on.
Support what? Oracle is a database server. Not a SNMP collector. You need to write the software to insert user data into the database.

You cannot expect that the database will automagically guess what user data you want, how you want it structured, and then insert that for you - without you lifting a finger.

SNMP and MIB based systems dealing with network devices ito management, configuration, performance, planning and so are, are expensive and sophisticated systems - and typically will cost you more than buying an Oracle RDBMS license. You cannot expect to simply snap your fingers and have the Oracle RDBMS provide this software, interfaces and functionality for you.