Overview of Oracle Enterprise Manager (OEM) - The OEM Console Screens (2024)

Donald K. Burleson

Oracle and Expert Systems Technology

Oracle - Overview of Oracle Enterprise Manager (OEM)

Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle products.

From the Oracle Enterprise Manager Console, you can do the following tasks:

* Administer, diagnose, and tune multiple databases

* Distribute software to multiple servers and clients

* Schedule jobs on multiple nodes at varying time intervals

* Monitor objects and events throughout the network

* Customize your display using multiple graphic maps and groups of network objects, such as nodes and databases

* Administer Real Application Clusters (For information about administering Real Application Clusters, see the Real Application Clusters Support for the Oracle Enterprise Manager Console Guide.)

The OEM Console Screens

Objective:

See the features of the OEM console screens

Content:

From our high-level overview, let's move into the four unique areas of OEM administration; the Navigator, the Job scheduler, the Mapper, and the most important of all, the event manager.

Top-left - the Navigator window

The Navigator window allows you to view all of the objects in your database in a quick and simple fashion. It is very similar in functionality to the Oracle schema manager utility and provides the following functionality:

* Discovery of objects in the network system

* A view of the objects in a network environment and the relationships among them

* A way of accessing the objects and administering tasks on them

* The source for dragging and dropping objects to create maps

* A place from which to launch DBA tools and other integrated applications

Note: The Navigator will only display the database that it finds in your topology.ora file on your client PC in the c:\orant\Oracle*Net0\admin directory. You can create a topology.ora file from your tnsnames.ora file by executing the OEM Network Topology Generator from the menu.

Again, the functionality of the Navigator is almost identical to the Oracle Schema Manager. Both can be used to create or alter schema objects and view object relationships. The main benefit of Navigator is that it is integrated into the OEM console. For example, you can clock on a database icon in the navigator window and drag it into the map area where it will be displayed on the map.

The Job Scheduling window is the user interface to the Job Scheduling system, which enables you to automate repetitive tasks and provides the kind of "lights out" management which is vital in a large, distributed environment.

The Job Scheduling system allows you to manage tasks among the databases, groups, listeners, and nodes that you are administering. Using the menus, property sheets, and dialog boxes of the Job Scheduling window, you can execute, schedule, or cancel a job, view its status, and review historical information about jobs.

Jobs can be administered immediately, scheduled once, or scheduled for various times, such as daily or weekly, and at single or multiple destinations. Using the Job Scheduling system, you can also create and manage job scripts.

The Map window provides a customized, graphical map of all databases that participate in your Oracle*Net configuration. With the Map system, you can create, save, modify, and recall views of the network. Objects can be grouped together based on any criteria, simplifying all operations performed on the group members. The map is especially useful for environments with very many databases.

When you double click on a database in the map window, you will see the current SGA size and start time. You also have the option of starting or stopping the database from this screen.

Bottom Left - Event management

Using the Event Management system, you can remotely monitor for critical database and system events. In the Event Management window, you can create and register event sets, view the status of services being monitored and get information about events that have occurred.

With the Event Manager, you can choose to have the events of interest represented graphically on the Console when they are detected. The system can also notify you through e-mail or page. The Oracle Enterprise Manager console provides support for paging and e-mail when a pre-registered event is encountered. The console also supports alphanumeric paging and e-mail notification. Best of all, you can also create a job that you specify to be run to automatically fix the problem.