Lesson 11

This module covered the Oracle Enterprise Manager, focusing especially on the OEM Event Manager. You should now have a firm understanding of the four quadrant windows of the OEM console and the general functions of each. You should also understand how the Event Manager within the OEM console functions to monitor the remote databases.
The main points of this module included:

1. The OEM console consists of four quadrants: the Navigator, the Job Scheduler, the Map utility and the Event Manager.
2. The Navigator window displays all schema information for each database.
3. The Job Scheduling window enables the Oracle DBA to schedule remote database tasks.
4. The Map window provides a graphical map of your entire distributed Oracle database topology.
5. The Event Management window allows for the definition of customized alerts.
6. Oracle uses the Simple Network Management Protocol (SNMP) to govern communications between the OEM console and the Intelligent Agents.
7. Remote Intelligent Agents must be installed on each remote server in order to use job scheduling of event-management functions. Only one agent is required for each server.
8. The Intelligent Agent software is installed on each server as part of the Oracle installation.
9. The Event Management system comes with three default events called UpDown. Additional events may be added by using the Tcl language to write new events.

Oracle Enterprise Manager was first distributed with Oracle7 and was focused at that time on just simplifying database management. Early EM versions required Windows based workstations as client machines. A Java applet browser-based EM console appeared with the Oracle8i database release. The HTML-based console was introduced with Oracle9i and is now the basis for Enterprise Manager 12c used to manage the database and many other Oracle products and platforms for cloud-based and other deployments. Alternatively, Enterprise Manager 12c can be accessed via iOS devices including iPhones and iPads.
Oracle Database 12c also comes with a small footprint version of Enterprise Manager called Enterprise Manager Express that requires no additional middleware. Enterprise Manager Express provides basic storage, security, and configuration administration support as well as advanced performance diagnostics and tuning. Enterprise Manager provides a basic interface for monitoring and management of Oracle Database users and user privileges, database schema and database configuration status, and backup and recovery.

This module introduced you to the following terms:

1. Bridge:A firmwear device that helps manage distributed environments.
2. Intelligent Agent
3. Router:A device used to connect networks of different types, such as those using different architectures and protocols. Routers work at the Network layer of the OSI model. This means they can switch and route packets across multiple networks. They do this by exchanging protocol-specific information between separate networks. Routers determine the best path for sending data and filter broadcast traffic to the local segment.
4. Threshold:A pre-defined value that will trigger an alert to be reported to the OEM console.
5. UpDown threshold: A threshold that runs on the remote Intelligent Agent and reports when the Oracle database is not running.

The next module will introduce using and configuring the multi-threaded server.

Before moving on to the next module, take a quiz to confirm your understanding of OEM.
Oracle Enterprise Manager - Quiz