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.

The OEM Event Manager has been deprecated in Oracle. The last version of the OEM Event Manager was released in 2013, and it is no longer supported by Oracle. Oracle has replaced the OEM Event Manager with the Oracle Cloud Infrastructure Monitoring service. The Oracle Cloud Infrastructure Monitoring service provides a more comprehensive set of features for monitoring Oracle Cloud Infrastructure resources, and it is more tightly integrated with other Oracle Cloud Infrastructure services.
If you are currently using the OEM Event Manager, you should migrate to the Oracle Cloud Infrastructure Monitoring service as soon as possible. The Oracle Cloud Infrastructure Monitoring service is a more secure, reliable, and scalable way to monitor your Oracle Cloud Infrastructure resources. Here are some of the benefits of using the Oracle Cloud Infrastructure Monitoring service:

1. It is a cloud-native service, so it is designed to work seamlessly with other Oracle Cloud Infrastructure services.
2. It provides a comprehensive set of features for monitoring Oracle Cloud Infrastructure resources, including metrics, alerts, and dashboards.
3. It is more secure than the OEM Event Manager, as it uses the same security features as other Oracle Cloud Infrastructure services.
4. It is more reliable than the OEM Event Manager, as it is backed by Oracle's commitment to uptime and availability.
5. It is more scalable than the OEM Event Manager, as it can be scaled to meet the needs of your organization.

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