Re: Has anyone tried out SNMP-support ?

From: Bas Varkevisser <Bas.Varkevisser_at_cmg.nl>
Date: 1998/02/16
Message-ID: <EMvC07.84F@atg.cmg.nl>#1/1

"Guus van de Sande" <dyntas_at_wxs.nl> wrote:

>Hi,
 

>Has anyone out there any experience in managing databases via SNMP/Daemon
>manager of Enterprise Manager.

Yes, I have. I found the examples in the installation manuals quite good! The problems I had were not caused by errors in *.ora files but by a bug in de snmp agent.
If your agent still doesnot work, turn on trace and watch for errors.

>I'm using Oracle 7.3.2.2 Server on a Open VMS Digital Alpha environment.
>I'm interested in examples of SNMP.ORA and LISTENER.ORA
The server is called ibm2 (AIX / Rs6000) and the database sqlnet alias is orc2.

################
# Filename......: snmp.ora
# Name..........: ibm2.world
# Date..........: 27-JUN-97 17:17:55
################

# NMI.TRACE_LEVEL = ADMIN

NMI.TRACE_LEVEL = OFF
NMI.TRACE_MASK = (106)
NMI.TRACE_DIRECTORY = /tmp/trace
NMI.TRACE_FILE = agent.trc

DBSNMP.ADDRESS =
(DESCRIPTION=(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host= ibm2)(Port=1527)))
DBSNMP.SPAWNADDRESS =
(DESCRIPTION=(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)( Host=ibm2)(Port=1528)))

SNMP.VISIBLESERVICES =(LISTENER_ibm2.world,orc2.world)
SNMP.INDEX.LISTENER_ibm2.world = 1
SNMP.INDEX.orc2.world = 2
SNMP.CONTACT.LISTENER_ibm2.world = "Bas Listener Contact"
SNMP.CONNECT.orc2.world.USER = dbsnmp
SNMP.CONNECT.orc2.world.PASSWORD = dbsnmp
SNMP.SID.orc2.world = orc
SNMP.ORACLEHOME.orc2.world = /prog/app/oracle/product/7.3.2
SNMP.CONTACT.orc2.world = "Database Contact"

And listener.ora (but that has nothing to do with snmp):

SQLNET.AUTHENTICATION_SERVICES = (NONE) USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =

  (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC) (KEY= orc2.world))
        (ADDRESS= (PROTOCOL=IPC) (KEY= orc))
        (ADDRESS= (PROTOCOL=IPC) (KEY= oio))
        (ADDRESS = (COMMUNITY = TCP.world) (PROTOCOL = TCP) (Host =
ibm2)
                        (Port = 1526))

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = orc2.world)
      (SID_NAME = orc)
      (ORACLE_HOME = /prog/app/oracle/product/7.3.2)
      (PRESPAWN_MAX = 10)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = oio.world)
      (SID_NAME = oio)
      (ORACLE_HOME = /prog/app/oracle/product/7.3.2)
      (PRESPAWN_MAX = 10)

    )
    (SID_DESC=

      (SID_NAME=OD_oio)
      (ORACLE_HOME=/prog/app/oracle/product/7.3.2)
      (PROGRAM=dmsrv)

  )

)

>Thanks in advance,
 

>Guus van de Sande
>Oracle DBA, The Netherlands
 

>dyntas_at_wxs.nl

Groetjes :-)

  ___ __  __  ___  
 / __|  \/  |/ __| 
| (__| |\/| | (_ | ------ Oracle R&D Centre -----------------------
 \___|_|  |_|\___|                                     
    _____             _____                Greetings from The Hague
^..^     \9  -n +  |\/   o /  +ser                       orc_at_cmg.nl
(oo)_____/         |/\_____\                 Bas.Varkevisser_at_cmg.nl
    WW WW
               Opinions expressed here are my own most of the time.

Received on Mon Feb 16 1998 - 00:00:00 CST