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.
The following paragraphs make reference to DBA Management Pack applications.

DBA Management Pack Applications

Create a view Schema Manager
Add a datafile to a tablespace Storage Manager
Execute an ad-hoc SQL query SQLPlus Worksheet
View a list of current users Instance Manager
Add a column to a table Schema Manager
Drop a redo log file Storage Manager
Change an initialization parameter Instance Manager
Grant SYSDBA to a user Security Manager

The Console may also be run from a web browser, allowing administrators to run the Console as a "thin" or "fat" client. Thin clients use a web browser to connect to a server where Console files are installed, whereas fat clients have Console files installed locally. Run from a web browser, the Console enables you to perform all the same administration tasks you would normally perform from the installed Console, including access to the DBA Management Pack applications. You can perform these tasks on any machine that supports a web browser.