RelationalDBDesign RelationalDBDesign


Managing Users   «Prev  Next»
Lesson 10

Oracle Enterprise Manager Conclusion

In this module, you learned that Oracle Enterprise Manager is Oracle’s GUI solution for managing Oracle databases.
The DBA Management Pack is part of the base product, and consists of the following five applications:
  1. Instance Manager
  2. Storage Manager
  3. Security Manager
  4. Schema Manager
  5. SQLPlus Worksheet
You learned that each application is targeted at one specific domain, or area, of database administration.
The four Manager applications have an interface divided into two panes. The left-hand pane contains a navigation tree similar to that used in Windows Explorer. The right-hand pane changes as you move through the tree to show information about the currently highlighted object, or category of objects.
Throughout the next three courses, you will find that lessons and simulations covering various aspects of OEM are woven into the various modules. As you learn to manage Oracle via the command-line, you also will learn how to use Enterprise Manager to perform the same functions.

OEM Glossary

This module introduced you to the following terms:
  1. DBA Management Pack: The set of Enterprise Manager applications used to perform basic database administration tasks.
  2. Enterprise Manager Console: A central screen used to monitor one or more Oracle databases, and from which you can launch any of the Enterprise Manager applications.
  3. Net service name: A Oracle Network Service is a usually a database instance, but could be some other software that is accessible via Network Services.
  4. OEM: Oracle's flagship suite of database administration software. Enterprise Manager consists of a set up GUI-based tools used to manage users, database objects, and security.
  5. Oracle Diagnostic Pack: A set of Oracle Enterprise Manager applications used to monitor and diagnose problems in an Oracle environment.
  6. Oracle Enterprise Manager: Oracle's flagship suite of database administration software. Enterprise Manager consists of a set up GUI-based tools used to manage users, database objects, and security.
  7. Oracle Change Management Pack: A set of Oracle Enterprise Manager applications that help the DBA plan and implement schema changes in an Oracle environment.
  8. Oracle Tuning Pack: A set of Oracle Enterprise Manager applications used for tuning an Oracle database environment.
  9. packs: With respect to Oracle Enterprise Manager, a pack is a set of related applications that delivers functionality covering one aspect of database administration. The Oracle Tuning Pack, for example, consists of a set of applications that help a DBA tune an Oracle database environment.
  10. two-tier architecture: An application architecture where you have clients that communicate directly with a database server.

DBA management Pack Applications

Take this matching Exercise to test your knowledge of the DBA Management Pack applications.
DBA Management Pack Applications