|Oracle Enterprise Manager Concepts Guide
Part Number A96674-01
Enterprise Manager is based upon a lightweight, three-tier architecture that offers flexible deployment options, round-the-clock reliability and unparalleled scalability. Console clients and integrated tools provide a graphical interface for administrators. Management Servers and a database repository provide a scalable middle tier for processing system management tasks. Intelligent Agents installed on each node monitor its services and execute tasks from the Management Server.
An Oracle Enterprise Manager administrative user is an account that provides users permission to perform administrative tasks and access administrative information. An administrative account is usually created for each person on an administrative team by the super administrator. Oracle Enterprise Manager is installed with a default user/password super administrator account which can be used for the initial login. The super administrator account is similar to root on UNIX or Administrator on Windows NT and is a user which cannot be deleted or renamed.
When you launch the Console with a Management Server connection, you login as an Enterprise Manager administrator. This administrator account should not be confused with your user account on any of the databases or systems that you manage.
When you launch the Console standalone, you connect directly to databases as a database user (such as SYS). Standalone connections do not use Enterprise Manager's middle tier, so do not require an Enterprise Manager administrator account.
A set of additional pre-defined events that are included in Oracle Diagnostics Pack, Oracle Management Pack for Oracle Applications, and Oracle Management Pack for SAP R/3. These events provide advanced options for use with the Event System.
Oracle9i introduces a new approach for undo space management called Automatic Undo Management, which eliminates the need to manage rollback segments, by using a new UNDO tablespace.
A feature which can be set up to prevent administrators from being flooded with e-mails and pages if a managed target is brought down for scheduled maintenance; deactivates enhanced notification (page/e-mail) while the target is down.
A tool in Oracle Diagnostics Pack used for collecting, storing, and analyzing historical performance data collected from managed databases.
The client user interface of Oracle Enterprise Manager; the first tier in the three-tier framework from which network tasks are administered; The Oracle Enterprise Manager Console uses a master/detail view to provide an integrated, consistent, and efficient way of managing your enterprise. When an object in the Navigator (master) is selected, the appropriate details are displayed on the right-hand side of the Console (the detail pane).
Enterprise Manager is also available in standalone mode, a two-tier framework which connects directly to the databases. The Console launched standalone allows a single person to use one or more applications without requiring an Oracle Management Server or Intelligent Agent. Use the standalone Console if you want to perform basic administrative tasks that do not require the job, event, or group system.
An optional system management pack that is used with Oracle Enterprise Manager to help simplify the managing of complex changes to the Oracle Server and database objects.
The first tier of Oracle Enterprise Manager is comprised of clients such as consoles and management applications, which present a graphical user interface to administrators for all management tasks. These client components can be installed locally or brought up with a web browser.
A tool in Change Management Pack used for selecting two sets of database object definitions and comparing them.
A tool in Change Management Pack used for capturing database definitions in the form of a baseline to be used by other Change Management Pack tools.
Oracle Data Guard Manager provides the monitoring, control, and automation necessary to manage a Data Guard configuration, including the primary and standby databases, and the log transport and log apply services.
A tool in the Console that helps administrators locate database objects based on naming characteristics.
A user of a database managed by Oracle Enterprise Manager; not an Oracle Enterprise Manager user.
A tool in Oracle Change Management Pack used for making changes to one or more object definitions in one or more databases.
A tool in Change Management Pack that helps administrators select one or more object definitions from a database and reproduce them in a destination schema within the source or destination database.
A tool in Change Management Pack that helps administrators make one or more changes to a single definition of a database object.
An optional system management pack that is used with Oracle Enterprise Manager to help manage the health of a system, including detecting and diagnosing problems and planning for the future.
There are two types of discovery
Without the Intelligent Agent discovery, there is no Console discovery. Both discoveries must be successful and must happen in the correct order for the services to appear in the Console Navigator.
When you use the Discovery Wizard in the Console, the Management Server contacts the Intelligent Agent installed on that node to discover the Oracle services installed on the node.
When the Intelligent Agent starts, it performs its service discovery by scanning the system for Oracle targets to manage. The Intelligent Agent records the target discovery. When the Console requests a discovery of the node, the Intelligent Agent transmits the service discovery information it has detected to the Management Server.
The Management Server then places the new information in the repository, and updates the Console Navigator, displaying a view of all nodes and their respective targets.
Target discovery allows administrators to run jobs and monitor for events on those nodes and allows the information to be centrally managed by the Consoles.
An application integrated with Oracle Enterprise Manager used for administering most functional areas of Oracle Internet Directory and its related processes; can be used to connect to directory servers; manage configuration parameters; add, modify, and delete entries, attributes, and object classes; set up access control policies; configure security; and view and modify replication agreements.
The Oracle e-Business Management Tools are a set of applications that enable centralized management of the complete e-Business infrastructure including the client, middle-tier HTTP servers, and database.
An application integrated with Oracle Enterprise Manager used for administering the Oracle environment for user security using an LDAP-compliant directory server; allows an administrator to manage enterprise-level role authorization among multiple databases simultaneously.
A potential problem occurrence registered with the Event System in the form of one or more tests on a managed database or other service; triggers an alert to the Console, as well as a possible corrective action, if an event occurs; can also trigger e-mail or page alerts.
The Event Handler allows you to customize responses to event occurrences, either by logging event information to a file and/or by executing any operating system command. For example, the Event Handler can log an in-house trouble-ticket when the database goes down. This allows much more flexibility in defining responses specific to your business needs.
The system through which events are registered from the Events detail view in the Oracle Enterprise Manager Console; provides proactive alert notification.
See Oracle Expert.
The Enterprise Manager architecture can be easily extended on each tier to handle any number of clients and managed targets. As the number of managed systems increases, you can add more Oracle Management Servers to share and balance the workload. In this case, both the original and new Management Servers can share a single repository as their back-end store.
A data management wizard that aids in transferring data from an Oracle database to an Oracle binary operating system file.
You can perform client operations with Enterprise Manager directly through an installed Console as a fat client. A fat client can be launched either with a Management Server connection or standalone.
A job that can be scheduled to run when a particular event occurs to automatically correct the problem.
An application integrated with Oracle Enterprise Manager that allows administrators to control and monitor Forms Listener, Forms Server, Load Balancer Server, and Load Balancer Client.
A logical administrative collection of objects which are grouped together in the Group detail view of the Oracle Enterprise Manager Console for more efficient management and administration.
A data management wizard that aids in transferring data from an exported binary file to an Oracle database.
A tool in Oracle Tuning Pack that helps administrators quickly identify and correct index problems by recommending optimal indexing strategies and implementing the tuning recommendations.
An independent object that resides on a managed node in the third tier and executes commands sent by the Oracle Management Server; monitors for critical occurrences (events) and executes jobs on the databases and other managed services on the node; is responsible for reporting back to the Console via the Oracle Management Server the status of jobs and events on the node; functions independently of the databases and other services it supports, and is also independent of the Oracle Management Server and Console clients.
Functionality in the Console that helps administrators manage database instances and sessions.
A set of one or more administrative tasks scheduled with the Oracle Enterprise Manager Job System; runs on managed databases or other services.
The system through which jobs are scheduled from the Jobs detail view of the Oracle Enterprise Manager Console.
A data management wizard that aids in transferring data from operating system files, such as text files, to an Oracle database.
Oracle9i LogMiner is a relational utility that helps you analyze online or archived log files to evaluate all updates to a database.
A managed node is any machine that is being monitored by an Intelligent Agent that has been discovered by the Console.
Every service running on a managed node is a managed service or target. Multiple services (targets) can exist on a single machine (node).
An optional system management pack that is used with Oracle Enterprise Manager; a set of applications for monitoring and diagnosing the Oracle Applications environment and planning for future resource needs.
An optional system management pack that is used with Oracle Enterprise Manager; a set of applications for monitoring, diagnosing, and planning for future needs in the SAP R/3 environment.
The view in the Oracle Enterprise Manager Console where a tree list of discovered databases and their objects appears when connected to an Oracle Management Server; provides access to managed databases and other services which can be viewed and managed from this pane.
Oracle Net Manager is a graphical user interface tool that combines configuration abilities with Oracle Names component control to provide an integrated environment for configuring and managing Oracle Net. It can be used on either the client or server. Oracle Net Manager is also integrated with Oracle Enterprise Manager.
A machine in the third tier of the Oracle Enterprise Manager framework where the managed databases and other services reside; also hosts an Intelligent Agent which monitors performance and performs tasks on the node's databases and services.
The ability of Enterprise Manager administrators to be notified of the status of jobs and the occurence of events by Console alert, e-mail, or page; allows you to choose which administrators to have notified, and whether to use notification filtering.
Notification filters allow each administrator to specify when to send an email notification as opposed to a page notification as a result of a job or event status change.
A tool in the Console that enables administrators to create and edit OLAP metadata using the CWMLite Release 1 APIs.
An application integrated with Oracle Enterprise Manager; a text-search system for managing and searching for text in the Oracle database.
The Oracle Enterprise Manager Console and its three-tier architecture provide a wide view of your entire Oracle environment. Use the Console to automatically discover and manage Oracle databases, application servers, and Oracle applications across your entire network.
The middle tier and the core of the Oracle Enterprise Manager framework. The Management Server provides administrative user accounts, processes management functions such as jobs and events, and manages the flow of information between the tiers.
As the number of nodes and managed services in your network increases or if the current Management Server is overloaded, you can add more Oracle Management Servers to the middle tier to share and balance the workload. These additional Management Servers provide fault-tolerance in the case where one Management Server becomes unavailable. All Management Servers administering the same set of managed nodes share a single Repository, which stores all system data, application data, and the state of managed nodes throughout the environment.
A tool in Oracle Tuning Pack that helps administrators with database initialization parameter tuning, application tuning, and structure tuning.
Oracle9i Real Application Clusters provide transparent application scalability by sharing cluster-wide caches for coordinated data access. Along with standard DBA features, the Console supports startup and shutdown of an entire cluster database or a select set of instances. Individual cluster database instances can be managed in the same way as a single instance database. In addition to common database jobs and events, Cluster Database Instances support specialized event tests. Version 9.2 also includes diagnostics overview and drilldown charts.
A tool in Oracle Diagnostics Pack that is used for collecting precise database-occurrence statistics from Oracle products as well as end-user and third-party applications.
Outline Editor is an advanced Oracle9i application that allows the user to control the optimizer behavior by modifying the optimizer mode, join order, or index usage without having to change the statement in the application code.
The Outline Management is an advanced Oracle9i application that allows you to manage stored outlines directly using a GUI-based tool. Specifically you can browse, sort, delete, and edit outlines with this tool.
A tool in Oracle Diagnostics Pack that helps administrators monitor the factors that most affect database performance; provides real-time graphical views of performance data collected from Oracle databases, other services, and the host operating system.
You can use Oracle Policy Manager to administer Oracle Label Security. The navigator tree lists policies, along with their labels, authorizations, and protected objects. The detail view shows a property sheet in which labels are specified.
The right to execute a particular Oracle Enterprise Manager command or SQL statement; a right granted to a database administrator by a Super Administrator, or to a database user by a database administrator.
An individualized summary of data specifying system privileges as well as limitations on system resources; assigned to each database administrator and database user.
A summary of information about a database or object that appears when you select a database or object in a tree view; can be used to view and change object properties; often contains multiple tabbed pages.
Oracle Tuning Pack provides the Reorg Wizard to help you maintain a well performing database by correcting space usage problems. The Reorg Wizard eliminates space problems by reorganizing database space usage and allows you to change an object's storage settings and location.
Enterprise Manager provides comprehensive reporting so that administrators can quickly access information about the status of all monitored systems in their enterprise. The reporting functionality allows reports to be generated automatically at specific times or at regular intervals.
A set of database tables used as a back-end store for the middle-tier Oracle Management Server(s), and that can be located in any Oracle database; is shared by administrators and stores the state and history of registered events and scheduled jobs; also contains accounts of all administrators, including information such as administrator passwords and privileges; contains the current view of the network including all system data, application data, and information about the state of managed nodes.
An Enterprise Manager repository is owned by a database user. During repository creation a repository's user name is entered that will be used to create this database user. The name of the repository user will also be the name of this repository, and this name will be used throughout the network to identify all the objects in this repository. The name of the repository must be a unique schema name across the entire managed network.
If the repository user name and encrypted password are saved during repository creation, the Management Server uses them to login to the repository; if they are not saved, the Management Server prompts the user for a user name and password before it starts up.
Oracle9i introduces a new feature called "resumable space allocation" which allows the system to suspend operations that encounter an "out of space condition," "MAX Extents Reached," or "User space quote exceeded failure." The system then fixes the problem and then automatically resumes execution from the point of interruption.
Enterprise Manager marks the sessions that have been suspended in Instance Management's Session List. For each suspended session you can view more details on the resumable state, such as start time, suspended time, Time Out, the last statement run, and the error encountered.
A set of database privileges granted to a database administrator or database user.
Functionality in the Console that helps administrators manage database schema objects; helps administrators to create, alter, or drop database clusters, indexes, snapshots, tables, and views.
Functionality in the Console that helps administrators make changes to security parameters for database objects, users, and other administrators quickly and efficiently.
An application integrated with Oracle Enterprise Manager that enables administrators to analyze and tune spatial indexes on database data.
A tool in Oracle Tuning pack that analyzes and tunes problematic SQL statements that are causing the greatest impact on database performance.
A tool with which administrators can execute SQL and PL/SQL commands and store them as files to reuse at a later time.
SQL Scratchpad is a low-overhead tool that simplifies SQL and PL/SQL development and general database querying. Along with the Console Navigator, SQL Scratchpad offers a complete SQL development environment.
An optional system management pack that is used with Oracle Enterprise Manager by administrators of smaller database enterprises who use the Oracle Workgroup Server or Oracle9i; combines several of the diagnostic, tuning, and change management features of Diagnostics Pack, Tuning Pack, and Change Management Pack into one application suitable for smaller enterprises.
Functionality in the Console that helps administrators manage database storage for optimum database performance, such as managing tablespaces, datafiles, redo logs, and rollback segments.
Default user/password. The first administrator to set up an administrator account in the repository; the head administrator to one or more middle-tier Oracle Management Servers; can create as well as disable other administrator accounts and set up all administrator credentials.
A tool in the Oracle Tuning Pack for monitoring tablespace usage. The Tablespace Map provides a complete picture of the characteristics of all tablespaces associated with a particular Oracle database. These characteristics include analysis status, segment type, segment name, number of extents, and the total size of the extent in blocks. You can display all segments for a tablespace or all segments for a datafile.
What a job is comprised of when scheduled to run on a managed database or other service; what an administrator selects to create a job when scheduling a job with the Job Scheduling System; is selected from a list of pre-defined tasks.
What an event is comprised of when registered against a managed database or other service; what an administrator selects to create an event when registering an event with the Event System; is selected from a list of pre-defined tests.
You can perform client operations with Enterprise Manager through a browser as a thin client. You use the browser when you do not have the Console software installed locally. A thin client requires the middle tier Management Server.
A tool in Oracle Diagnostics Pack that gives administrators the ability to pinpoint database sessions that are causing the greatest impact on performance.
An optional system management pack that is used with Oracle Enterprise Manager to help optimize performance in the database environment, including identifying and tuning major database and application bottlenecks such as inefficient SQL, poor database structures, and improper use of resources.
See Oracle Trace
A tool in Oracle Trace for administering Oracle Trace data collected from API-instrumented products.
A list of discovered and managed databases and other services and their objects that appears in a Console client when connected to the Oracle Management Server or single database; can appear in the Oracle Enterprise Manager Console, a system management pack, or, in certain circumstances, wizards.
Workspace Management allows you to version-enable tables and create, modify, refresh, and merge workspaces. Oracle Workspace Manager provides a long transaction framework, in which multiple data versions are stored in the database as different workspaces. Users can create new versions of data to update, while maintaining a copy of the old data.
Oracle9i introduced the Oracle XML Database, a high-performance system designed to store and retrieve XML documents both via relational and hierarchical access APIs. Oracle Enterprise Manager simplifies the configuration and on-going management of the XML database.