|Oracle Enterprise Manager Concepts Guide
Part Number A88770-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 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.
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.
The Cube Viewer is a tool within OLAP Management that enables you to browse the data associated with OLAP metadata. A cube is a logical organization of multidimensional data.
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 system through which events are registered from the Events detail view in the Oracle Enterprise Manager Console; provides proactive alert notification.
See Oracle Expert.
A data management wizard that aids in transferring data from an Oracle database to an Oracle binary operating system file.
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.
Oracle OLAP Services is an Oracle9i database installation option that provides tools for developing and deploying internet-based business intelligence applications. OLAP (Online Analytical Processing) products provide services that support complex statistical, mathematical, and financial calculations within a multidimensional data model.
Oracle9i JVM is the name of the Java engine embedded in Oracle database. CORBA and EJB components implemented in Java can be stored and executed inside the database. Client applications access these components through a name service.
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.
Oracle Real Clusters Management enables the administration of databases that use the Oracle Real Clusters option. Once discovered, Real Clusters Databases appear in the Databases folder of the Console's navigator panel alongside single-instance databases. Real Clusters behave similarly to single-instance databases, allowing the full power of the Schema, Security and Storage applications to be applied to Real Cluster databases. The database administrator can start up, shut down, or check the status of Real Cluster databases, as well as see the status of Real Clusters and the progress of Real Cluster operations by node and target.
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.
A functionality of Oracle Enterprise Manager that enables an administrator to quickly set up, configure, and manage an Oracle Replication environment.
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.
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.
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.
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.