SNMP and Oracle Intelligent Agent

From: APS <abdelkafi_at_skynet.be>
Date: Tue, 09 Mar 1999 12:50:32 +0000
Message-ID: <36E51918.2B6B4236@skynet.be>

I have installed Oracle 8.0.3 on a computer (NT4 + SP3) and Hp OpenView Network Node Manager 6.0
on another (NT4 + SP3).
I would like to monitor Oracle database, the listener oracle process and the Oracle Intelligent
Agent (8.0.3) from my management console (HP OV). To do that, I have load, with success, the following three MIBS : ORADB, LISTENER and OEMTRAPS
on my management console.
When I tried to Get the value of a MIB variable (example : OraDbSysDbBlockGets), I receive the
following message : ERROR:SNMP:Variable does not exist or Access is denied.

REM : The SNMP process (a NT process) is started and configured with the following community name :

           public and private. The SNMP trap process is also started.
           I have thus configure HP OV so that it use these community

name (public and private).

REM : The Oracle Intelligent Agent (8.0.3) is started on the "Oracle machine" and works properly.

           I have tested it with Oracle Entreprise Manager.

REM : When I tried to get the value of a non-Oracle SNMP variable
(example : SysContact), the

            system respond correctly to this query. Thus SNMP work properly !

In the Oracle documentation, it is write that when the Intelligent Agent is started, it'll be able to respond to the SNMP query. Is it correct ?

The Oracle Intelligent Agent use two configuration files : SNMP_RO.ORA and SNMP_RW.ORA.
Are they corrects ?
REM : RAS is my DB name and ORC1 the instance name.

SNMP_RO.ORA

---

snmp.visibleservices = (LISTENER, ras)
snmp.shortname.LISTENER = LISTENER
snmp.longname.LISTENER = LISTENER_APS-RAS
snmp.configfile.LISTENER = D:\ORANT\net80\admin\listener.ora
snmp.SID.ras = ORC1
snmp.oraclehome.ras = D:\ORANT
snmp.address.ras = (DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=

IPC)(KEY= oracle.world))(ADDRESS=(PROTOCOL= IPC)(KEY= ORC1))(ADDRESS=(COMMUNITY= NMP.world)(PROTOCOL= NMP)(SERVER= APS-RAS)(PIPE= ORAPIPE))(ADDRESS=(PROTOCOL= TCP)(Host= ras)(Port=

1521))(ADDRESS=(PROTOCOL= TCP)(Host= ras)(Port=
1526))(ADDRESS=(PROTOCOL= TCP)(Host= 127.0.0.1)(Port=
1521)))(CONNECT_DATA=(SID=ORC1)))

ifile = D:\ORANT\net80\admin\snmp_rw.ora

SNMP_RW.ORA

---

snmp.contact.LISTENER = "ME"
snmp.index.LISTENER = 1
snmp.contact.ras = "ME"
snmp.index.ras = 2

DBSNMP.ADDRESS = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=ras)(PORT=1748)))

DBSNMP.SPAWNADDRESS = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=ras)
(PORT=1754)))

SNMP.CONNECT.ras.USER = dbsnmp
SNMP.CONNECT.ras.PASSWORD = dbsnmp
SNMP.DBPOLLTIME = 60

What can I do to solve this problem ?
What's wrong in my configuration ?

Any help would be appreciate.

Thanks. Received on Tue Mar 09 1999 - 06:50:32 CST