|Oracle Enterprise Manager Concepts Guide
Part Number A85250-01
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. Preferences, such as preferred credentials, login password, and email and paging notification schedules, must be set for each administrator. Generally each person has a single administrative user account through which he administers several to many targets.
Administrative user accounts are created by the super administrator. Oracle Enterprise Manager is installed with a default 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.
Administrator user accounts are specific to Oracle Enterprise Manager and are different than Oracle database users.
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 Management System.
An application integrated with Oracle Enterprise Manager that provides administrative and diagnostic capabilities for concurrent processing in Oracle Applications; provides a single point of administration for concurrent managers and requests on multiple Oracle Applications instances.
A feature which can be set up to prevent administrators from being flooded with emails and pages if a managed service is brought down; deactivates enhanced notification (paging/email) while the service 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 interface for the Navigator, Group, Jobs, and Events panes, which are the four areas from which different administrative tasks can be performed.
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.
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.
An administrator of a managed database and a user of Oracle Enterprise Manager whose database administrator account and privileges are granted and managed by a Super Administrator.
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.
Database administration functionality that is integrated into Oracle Enterprise Manager; also can be accessed with DBA Studio.
An interface from which all DBA Management Pack features can be accessed (with the exception of SQL*Plus Worksheet); allows administrators to manage database security, schemas, instances, and storage from a unified tree view without launching features separately; can be used to manage databases with or without a connection to an Oracle Management Server.
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 application integrated with Oracle Enterprise Manager that allows administrators to control and monitor Forms Listener, Forms Server, Load Balancer Server, and Load Balancer Client.
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.
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.
An application integrated with Oracle Enterprise Manager used for monitoring and administering Oracle's heterogeneous distributed environments.
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 Management 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 system through which events are registered from the Events pane in the Oracle Enterprise Manager Console; provides proactive alert notification.
See Oracle Expert.
A data management tool in DBA Management Pack that aids in transferring data from an Oracle database to an Oracle binary operating system file.
Filtering (see Notification Filtering)
A tool in Change Management Pack that helps administrators locate database objects based on naming characteristics.
A job that can be scheduled to run when a particular event occurs to automatically correct the problem.
A logical administrative collection of objects which are grouped together in the Group pane of the Oracle Enterprise Manager Console for more efficient management and administration.
A data management tool in DBA Management Pack 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 DBA Management Pack that helps administrators manage database instances and sessions.
A set of one or more administrative tasks scheduled with the Oracle Enterprise Manager Job Scheduling System; runs on managed databases or other services.
The system through which jobs are scheduled from the Jobs pane of the Oracle Enterprise Manager Console.
A data management tool in DBA Management Pack that aids in transferring data from operating system files, such as text files, to an Oracle 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 pane 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.
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.
A feature which allows you to filter e-mail and pages sent to administrators based on job status or event severity level.
An application integrated with Oracle Enterprise Manager; a text-search system for managing and searching for text in the Oracle database.
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.
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.
One of four partitions in the Oracle Enterprise Manager Console representing either Groups, Jobs, Events, or the Navigator tree view through which administrators manage the database environment.
An application integrated with Oracle Enterprise Manager that enables the administration of databases using the Oracle Parallel Server option.
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.
Oracle Change Management Pack's general-purpose interface that gives administrators access to all Change Management Pack features; allows experienced administrators to accomplish everything that Change Management Pack can do from a single interface, while the other tools in the pack provide step-by-step guidance for specific features.
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.
An application integrated with Oracle Enterprise Manager that enables an administrator to quickly set up, configure, and manage an Oracle Replication environment.
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.
A set of database privileges granted to a database administrator or database user.
Functionality in the DBA Management Pack that helps administrators manage database schema objects; helps administrators to create, alter, or drop database clusters, indexes, snapshots, tables, and views.
Functionality in the DBA Management Pack that helps administrators make changes to security parameters for database objects, users, and other administrators quickly and efficiently.
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 services to manage. The Intelligent Agent records the service 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 services.
Service 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 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 in the DBA Management Pack with which administrators can execute SQL and PL/SQL commands and store them as files to reuse at a later time.
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 Oracle 8i; 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 DBA Management Pack that helps administrators manage database storage for optimum database performance, such as managing tablespaces, datafiles, redo logs, and rollback segments.
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 Oracle Tuning Pack for monitoring and managing tablespace usage to achieve optimum database performance.
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 Management System; is selected from a list of pre-defined tests.
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 that sorts and processes large collections of Oracle Trace data, extracting and aggregating key metrics, and presenting the information in pre-defined data views selected by the user, who can then perform analyses on the data.
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 DBA Management Pack application, a system management pack, or, in certain circumstances, wizards.