Re: Using Oracle snmp module(diamond?) for Solaris

--May,

        You need to fit together four pieces of your network management puzzle in order enable the "remote" management of your engine:

1. get the MIBs from Oracle that define the managed objects The file extensions would be something like: *.mib, *.my, *.smi, etc All management software that I've seen support at least the MOSY format (*.my).
2. determine if the MIBs use SNMPv1 or v2 syntax Most Network/Systems/Enterprise Mangement software only supports SNMPv1 (maybe latest releases support V2)
3. determine what local protocol is used by the subagent: Emanate, SMUX, RPC, DPI2, Extensible, etc.
4. determine the recommended security management for the master agent: What community strings or parties are recommended by Oracle for access to the database? ...

        BTW, this is a generic process and could easily be followed to enable an Informix, Oracle, Sybase or MS database! In fact, if you had all four mibs installed in your Mangement system your could manage all four engines on four different hardware platforms on four different backbones.

        SNMP is an application-layer procotol and is independent (mostly) of lower layers. Management would included, at least, the objects defined in RFC-1697 (RDBMS-MIB). Additional objects might have to be walked to see what additional management is available (private.enterprise) mib branch.

--Scott

May Tsai wrote:
>
> Hi,
>
> I'm new to SNMP and Oracle, and try to find a way to set up
> Oracle SNMP support(Diamond?) for 7.3.2 server on a solaris 2.x
> Oracle database server.
>
> The Diamond manual talked about working with SunNet manager, I'm
> wondering if anyone try Cabletron's Spectrum instead of SunNet
> Manager or other network management software. Also, since SunNet
> Manager now changed to Sun Site/Domain Manager, does anyone have
> experience with it along with Oracle SNMP stuff?
>
> Regards,
> May
> --
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Work Phone : (972) 997-2544 mailto:May-Tsai_at_ti.com
> Personal MSGID: : M59T Group MSGID : UNIX
> Alpha Pager: (972) 598-0314 Mail Stop : 8366
> Fax : (972) 997-2420 PC Drop : PVP6
> Mailing Address : P.O. Box 650311, M/S 8366, Dallas, Texas 75265
> Shipping Address: 8330 LBJ Freeway, Dallas, Texas 75243
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 

-- 
========================================================================
Scott Noack                             Phone: 415.926.6547
Ext Connectivity R&D                    Fax:   415.926.5985
Informix Software                       Email: snoack_at_informix.com
========================================================================