Re: Oracle SNMP

Oracle has it's own "SNMP system" if I may call it so. A brief description to give you the direction. It exists of several components

1. the Oracle Intelligent Agent (OIA, dbsnmp processes)
2. the Oracle Management Server (OMS, part of OEM)
3. Oracle Enterprise Manager (OEM)
4. The OEM Repository

OEM can be used standalone as a database management tool. This setup does not allow for monitoring databases and getting alarms. For you purpose you must use an OMS.

On each host where you want to monitor its databases you start the OIA. (lsnrctl dbsnmp_start in V8.1.7, agentctl start in V9.2) Then you choose one host for your entire environment where you run the OMS. Setting up the OMS requires the creation of a Repository, just a set of tables where OEM stores all data.
You best give it its own database but you can store it in any database you want (but not the one you want to monitor). The OMS communicates with all the OIA's all the time. Using the OEM Console you communicate with the OMS to discover new hosts, register events for the databases. OEM comes with a set of predefined events with parameters you can set (like: raise warning when a tablespace is over 80% full, raise error when over 90%) but you can add you own defined events. You can also register jobs to run batches at scheduled intervals. OEM can send emails (you can block certain hours, like when databases are down for a cold backup).
OEM can also send alarms to a pager.

Now you know what it basically can and what to look for in the manuals .. I hope.
If you don't have the Documentation CD, you can find them all on http://tahiti.oracle.com

Kuas <jkuas_at_bigfoot.com> schreef in berichtnieuws 5686ee47.0306131204.4bfce10b_at_posting.google.com...
| Hi all,
|
| I'm sorry if this is a silly question, this is the first time I have
| to work with Oracle.
|
| I'm trying to setup SNMP so the DB will send alarm to NMS. I have been
| reading the documentations. I am confused with the term and product. I
| believe there are differences between OEM (Oracle Enterprise
| Management) and OracleDB. The way I undestand it OEM is only to
| managed some OracleDBs. In that case each DB should still has it's own
| SNMP configuration.
|
| Is it possible to enable alarm in OracleDB without installing OEM?
| Would it be different setup for SNMP on each system if OEM is
| installed?
|
| Thanks in advance for all the comments.
|
| Kuas
Received on Fri Jun 13 2003 - 15:39:16 CDT