2 Database and Engineered Systems Management

This chapter describes the management packs offered by Enterprise Manager in support of Oracle Database and Engineered Systems. The following management packs are included:

These management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager, Oracle Enterprise Manager Database Express, and APIs provided with Oracle Database software.

For information on the Oracle Databases certified for use with Oracle Enterprise Manager:

  1. Sign in to My Oracle Support and click the Certifications tab.
  2. In the Certification Search region:
    • Select Enterprise Manager Base Platform - OMS from the Product list.
    • Select the release you are interested in from the Release list.
  3. Click Search.

The certified databases and versions are displayed. For more information, go to the Oracle Database Documentation page and see the Oracle Database Licensing Information User Manual for the Oracle Database version you are interested in.

Oracle Diagnostics Pack

The Oracle Diagnostics Pack provides automatic performance diagnostic and advanced system monitoring functionality. The following table describes this management pack offered by Enterprise Manager:

Management Pack Type of Licensing Information Licensing Information

Oracle Diagnostics Pack

Features

The Oracle Diagnostics Pack includes the following features:

  • Performance monitoring and diagnostics.

  • Automatic Workload Repository (AWR) that captures statistics automatically, including snapshot data, active session history data, and workload reports.

  • AWR Warehouse to seamlessly retain AWR data beyond the default retention period and perform historical performance analysis tasks using Active Session History (ASH) Analytics, AWR, and Compare Period Reports.

  • AWR Warehouse Diagnosability is a part of AWR warehouse and it proactively identifies the points of failure after the AWR warehouse is configured and the ETL process has started running between the source database and warehouse, by running a number of tests on the AWR warehouse or selecting a set of sources and determining the health of the AWR warehouse configuration.

  • Automatic Database Diagnostic Monitor (ADDM) for performance analysis based on AWR data.

  • Real Time ADDM to allow analysis of transient performance issues and hung databases.

  • ADDM Spotlight provides insights on workload tuning recommendations by analyzing ADDM data over an extended period of time. This enables administrators to confidently implement recommendations by identifying ones that have significant impact on database performance.

  • Active Session History (ASH) providing an "Always-On" capture of database performance activity using one-second samples of the session state.

  • ASH analytics provides insight to the database workload profile across various performance dimensions using ASH data.

  • Performance Hub provides a single view of database performance with access to ADDM, SQL Tuning, Real-Time SQL Monitoring, and ASH Analytics under the same hood.

  • Top Activity Lite is a simplified yet highly efficient mode of Performance Hub that supports real-time performance monitoring of database activity in a single view for easy visualization of issues.

  • Replay Compare Period Report provides accurate performance analysis using the ASH infrastructure for capture/replay sessions.

  • Exadata Cell Grid Administration

  • Exadata Cell Grid Performance

  • Exadata Cell Group Health Overview Page

  • Exadata Resource Utilization

  • Blackouts to suspend monitoring on targets to support scheduled maintenance periods. This includes the use of Blackouts in the Enterprise Manager console, EMCLI and REST APIs.

  • Notifications that define and use different notification methods including e-mail, OS scripts, PL/SQL procedures, SNMP traps, Webhooks and Slack. Also includes repeat notifications, use of notification-related actions in incident rule sets, and administrator notification schedules.

  • Metric and Alert/Event History. This includes the use of metrics in the Enterprise Manager console, EMCLI and REST APIs.

  • Metric Extensions to create new metrics to monitor conditions specific to customer environments.

  • Management Connectors, such as ticketing connectors and event connectors, integrate Enterprise Manager with other management systems. Ticketing connectors open help desk tickets for incidents raised in Enterprise Manager. Event connectors share event information with other event management systems.

  • Dynamic metric baselines and Adaptive metric thresholds

  • Monitoring Templates encapsulate target monitoring settings and can later be applied against many targets for standardization. This includes the use of Monitoring Templates in the Enterprise Manager console and EMCLI.

  • Template Collections (with Administration Groups) automate the deployment of management settings on targets as they join the group. This includes the use of Template Collections in the Enterprise Manager console and EMCLI.

  • Dynamic Runbooks enable subject matter experts to encapsulate best practice steps for diagnosing and resolving issues into a runbook that can be executed directly inside Enterprise Manager.

  • Event Compression reduces incidents by correlating and combining related events into a smaller set of incidents.

  • Bottleneck detection and Component top wait event analysis

  • Memory access mode to retrieve performance statistics directly from the Shared Global Area (SGA).

  • Automatic Workload Repository (AWR) Hub consolidates AWR snapshots from one or more Autonomous Databases and also provides the ability to generate AWR Reports for any database uploading snapshots to the AWR Hub.

Oracle Diagnostics Pack

Feature Requirements

In order to use the features listed above, you must purchase licenses for Oracle Diagnostics Pack. The CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter controls access to Oracle Diagnostics Pack and Oracle Tuning Pack. This parameter can be set to one of three values:

  • DIAGNOSTIC+TUNING: Oracle Diagnostics Pack and Oracle Tuning Pack functionality is enabled in the database server.

  • DIAGNOSTIC: Only Oracle Diagnostics Pack functionality is enabled in the database server.

  • NONE: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is disabled in the database server.

Any and all methods of accessing Oracle Diagnostics Pack functionality, whether through Enterprise Manager console, desktop widgets, command-line APIs, or direct access to the underlying data, require an Oracle Diagnostics Pack license.

Oracle Diagnostics Pack

Access Features via API

Oracle Diagnostics Pack features can also be accessed by way of the following database server APIs and command-line interfaces:

  • DBMS_WORKLOAD_REPOSITORY

    This API is part of the Oracle Diagnostics Pack.

  • DBMS_ADDM

    This API is part of the Oracle Diagnostics Pack.

  • DBMS_ADVISOR

    This API package is part of the Oracle Diagnostics Pack if you specify ADDM as the value of the advisor_name parameter or if you specify for the value of the task_name parameter any value starting with the ADDM prefix.

  • DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT

    This API function is part of the Oracle Diagnostics Pack.

  • V$ACTIVE_SESSION_HISTORY

    This dynamic performance view and its underlying table, X$ASH, are part of the Oracle Diagnostics Pack.

  • DBA_STREAMS_TP_PATH_BOTTLENECK

    This API is part of the Oracle Diagnostics Pack.

  • DBA_ADDM_

    All views beginning with DBA_ADDM_ are part of the Oracle Diagnostics Pack.

  • DBA_STREAMS_TP_COMPONENT_STAT

    Some data in DBA_STREAMS_TP_COMPONENT_STAT requires Oracle Diagnostics Pack. The following filter clause to any query on DBA_STREAMS_TP_COMPONENT_STAT shows Diagnostics-Pack-dependent data: 

    where STATISTIC_UNIT = 'PERCENT'

    For example, the following query shows Diagnostics-Pack-dependent data only:

    SELECT * FROM DBA_STREAMS_TP_COMPONENT_STAT where STATISTIC_UNIT = 'PERCENT';

  • DBA_HIST_

    All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables. The only exception are the views: DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ, and DBA_HIST_UNDOSTAT.

    They can be used without the Oracle Diagnostics Pack license.

  • DBA_ADVISOR_

    All data dictionary views with the prefix DBA_ADVISOR_ are part of this pack if queries to these views return rows with the value ADDM in the ADVISOR_NAME column or a value of ADDM* in the TASK_NAME column or the corresponding TASK_ID.

Oracle Diagnostics Pack

Disabling Licensed Links

This procedure disables all the links and tabs associated with Oracle Diagnostics Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Diagnostics Pack and therefore require a pack license.

  1. From the Setup menu, select Management Packs and then select Management Pack Access.

  2. On the Management Pack Access page, you can grant and remove access from all the management packs. By default, access is granted. To disable access, click the appropriate check box for the Diagnostics Pack and click Apply.

Oracle Diagnostics Pack

Licensed Reports

The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of the Oracle Diagnostics Pack: 

awrrpt.sql awrrpti.sql awrgrpt.sql awrgrpti.sql awrgdrpt.sql awrgdrpi.sql addmrpt.sql addmrpti.sql ashrpt.sql ashrpti.sql awrddrpt.sql awrddrpi.sql awrsqrpi.sql awrsqrpt.sql awrextr.sql awrload.sql awrinfo.sql spawrrac.sql

Oracle Diagnostics Pack

Licensed Repository Views

The following repository views are part of the Diagnostics Pack for Oracle Database:

Monitoring Views

MGMT$ALERT_ANNOTATIONS MGMT$ALERT_CURRENT MGMT$ALERT_HISTORY MGMT$ALERT_NOTIF_LOG MGMT$AVAILABILITY_CURRENT MGMT$AVAILABILITY_HISTORY MGMT$BLACKOUT_HISTORY MGMT$BLACKOUTS MGMT$METRIC_COLLECTIONS MGMT$METRIC_CURRENT MGMT$METRIC_DAILY MGMT$METRIC_DETAILS MGMT$METRIC_HOURLY MGMT$TARGET_METRIC_COLLECTIONS MGMT$TARGET_METRIC_SETTINGS

Template Views

MGMT$TEMPLATES MGMT$TEMPLATE_METRIC_COLLECTION MGMT$TEMPLATE_METRIC_SETTINGS MGMT$TEMPLATE_POLICY_SETTINGS

Oracle Tuning Pack

Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. The following table describes this management pack offered by Enterprise Manager:

Management Pack Type of Licensing Information Licensing Information

Oracle Tuning Pack

Prerequisites

The Oracle Tuning Pack requires the Oracle Diagnostics Pack.

Oracle Tuning Pack

Feature Summary

  • In-Memory Advisor analyzes database workload and makes recommendations on which database objects to place in the Database In-Memory Store for optimal database performance.

  • SQL Access Advisor recommends schema changes needed to improve database performance.

  • SQL Tuning Advisor analyzes SQL statements and makes recommendations for better execution. Includes an automatic mode to run during system maintenance windows as a maintenance task.

  • Automatic SQL Tuning selects high-load SQL queries in the system and generates recommendations on how to tune them. Executes during the system maintenance window.

  • SQL Profiles enables transparent tuning of queries without requiring any application changes.

  • Real-time Database Operations Monitoring provides live visual displays to track the progress of SQL and PL/SQL queries associated with a business operation.

  • Real-time SQL and PL/SQL Monitoring monitors execution of long-running or parallel SQL statements in real-time.

  • Reorganize objects reorganizes database space usage for objects or tablespaces to improve performance.

In order to use the features listed above, you must purchase licenses for Oracle Tuning Pack, with one exception:

  1. Use of In-Memory Advisor for databases where Database In-Memory option has not yet been deployed does NOT require Oracle Tuning Pack license.

Oracle Tuning Pack

Feature Summary (Continued)

A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS, is introduced to control access to Oracle Diagnostics Pack and Oracle Tuning Pack in the database server. This parameter can be set to one of three values:

  • DIAGNOSTIC+TUNING: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is enabled in the database server.

  • DIAGNOSTIC: Only Oracle Diagnostics Pack functionality is enabled in the server.

  • NONE: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is disabled in the database server.

Any and all methods of accessing Oracle Tuning Pack functionality, whether through Enterprise Manager Console, desktop widgets, command-line APIs, or direct access to the underlying data, require an Oracle Tuning Pack license.

Oracle Tuning Pack

Disabling Licensed Links

This procedure disables all the links and tabs associated with Oracle Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Tuning Pack and therefore require a pack license.

  1. From the Setup menu, select Management Packs and then select Management Pack Access.

  2. On the Management Pack Access page, you can grant and remove access from all the management packs. By default, access is granted. To disable access, click the appropriate check box for the Tuning Pack and click Apply.

Oracle Tuning Pack

Accessing Features through Command-Line APIs

Oracle Tuning Pack features can also be accessed by way of the following database server APIs and command-line interfaces:

  • DBMS_ADVISOR

    When the value of the advisor_name parameter is either SQL Tuning Advisor or SQL Access Advisor, this API package is part of the Oracle Tuning Pack.

  • DBMS_SQLTUNE

    This API is part of the Oracle Tuning Pack.

  • V$SQL_MONITOR

    This API is part of the Oracle Tuning Pack.

  • V$SQL_PLAN_MONITOR

    This API is part of the Oracle Tuning Pack.

Oracle Tuning Pack

Licensed Reports

The sqltrpt.sql report in the /rdbms/admin/ directory of the Oracle home directory is part of this pack.

Database Lifecycle Management Pack for Oracle Database

The Database Lifecycle Management Pack is a comprehensive solution that helps database, system, and application administrators automate the processes required to manage the Oracle Database Lifecycle. It eliminates manual and time consuming tasks related to discovery, initial provisioning, patching, configuration management and ongoing change management. In addition the Database Lifecycle Management pack provides compliance frameworks for reporting and management of industry and regulatory compliance standards.

The following table describes this management pack offered by Enterprise Manager:

Management Pack Type of Licensing Information Licensing Information

Database Lifecycle Management Pack for Oracle Database

Database Lifecycle Types

The Database Lifecycle Management covers the entire lifecycle of the databases, including:

  • Compliance management: Secure target configurations and achieve compliance with industry and regulatory standards like Center for Internet Security (CIS), Security Technical Implementation Guide (STIG), Payment Card Industry Security Standards Council (PCI DSS), and Health Insurance Portability and Accountability Act (HIPAA).

  • Configuration management: Deploy standardized configurations, reduce sprawl, monitor for vulnerabilities, remediate to comply and analyze configuration change history and search.

  • Fleet Maintenance: End-to-end upgrade and patching solution with the primary intent to apply recommended security patches to databases and associated grid infrastructure at scale. Supports patching databases in on-premises, Exadata Cloud, public clouds like Oracle Cloud Infrastructure, AWS, and so on.

  • Fleet Maintenance Hub: Administrator-centric solution to obtain insight into vulnerabilities for database assets and apply patches to affected targets. Using this feature, administrators can identify database assets that are not subscribed to a gold image, review patch recommendations for images, and once gold images are refreshed, subscribe targets to a newer version of gold images and perform update and upgrade operations.

  • Fleet Provisioning and Patching: Integration with Oracle Fleet Patching and Provisioning (FPP), which enables FPP users to leverage Enterprise Manager capabilities such as security patch recommendations and proactive patching using Fleet Maintenance.
  • Exadata Engineered System Compliance with AHF EXAchk: Set of compliance standards and associated controls for overall health monitoring, automated risk identifications and proactive notification of issues for each Exadata System component and database instances.

  • Oracle Database Security Assessment Tool (DBSAT) Compliance Standards

    • DBSAT compliance standard for fleet-level assessment of database configuration: Assess database security posture, including user privileges, and get recommendations for elevating security posture.

    • DBSAT compliance standard for fleet-level discovery of sensitive data: Assess to identify the amount and location of sensitive data in a system, and analyze potential exposure to determine data protection requirements.

  • Provisioning: Ability to provision single instance, RAC, and Multitenant databases.

  • Cloning: Clone to create a copy of an existing single instance, RAC, and Multitenant database.

  • Database Change Management: End-to-end management of schemas and data changes.

  • Inventory tracking: Ability to track inventory utilization and growth over a period of time.

Database Lifecycle Management Pack for Oracle Database

Prerequisites

The Database Lifecycle Management Pack is a prerequisite for the Oracle Cloud Management Pack for Oracle Database.

Database Lifecycle Management Pack for Oracle Database

General Feature Summary

The Database Lifecycle Management Pack for Oracle Database includes the following features, which you can use after purchasing a license:

  • Provision all database target types: Single Instance Database, Real Application Clusters (RAC), and Multitenant databases including Container Database (CDB) and Pluggable Database (PDB).

  • Copy objects to copy database objects with data, with a subset of data, or without data.

  • Database Patching: An end-to-end patch automation for Oracle Databases and RAC databases. A bulk deployment of patches on all configuration types of Oracle Database with minimal downtime.

  • Upgrade existing Oracle Database and/or Oracle Grid Infrastructure across major release versions (for example, 19c to 21c versions).

    Upgrade Standalone Databases, RAC (including Grid Infrastructure and RAC Database) and Dataguard Databases. Dataguard Databases both Primary and Standby are upgraded in rolling method using Transient Logical Standby method.

    Note: The rolling upgrade using the Transient Logical Standby method requires a license for the Oracle Active Data Guard option. For more information, see Oracle Database Options and Their Permitted Features in Oracle Database Licensing Information User Manual.

  • Configuration management to monitor the drift of configuration properties of managed targets, customize templates for drift comparison, augment configuration properties to collect, track/review change history and search.

  • Compliance management to automate the hardening of secure configuration of managed targets, monitor for compliance with industry and regulatory standards like CIS, STIG, PCI DSS, HIPAA, and other out-of-the-box standards.

  • Compliance management of Exadata Engineered Systems: Secure and monitor the health of each Exadata component based on Autonomous Health Framework EXAchk.

  • Hybrid Cloud Management for a single pane of glass view to monitor and manage both on-premises and Oracle Cloud (public cloud) deployments, all from the same management console.

  • Enterprise Data Governance to automatically discover, scan, and identify databases of sensitive nature in the enterprise. Allows administrators to run deep scans in flagged databases for sensitive artifacts, pin-pointing its location within the database.

  • File Synchronization of configuration file differences during a comparison.

  • Notifications on configuration changes or differences.

  • RAC Scale Back to delete or scale back a single instance database from RAC.

  • RAC Scale Out to extend single instance databases to RAC.

Database Lifecycle Management Pack for Oracle Database

Provisioning Features

  • Software Library for preserving profiles, templates and software bits.

  • Provision Oracle Databases, RAC databases, RAC One Node, and PDBs.

  • Create Oracle Databases, RAC databases, and PDBs.

  • Extend or scale up RAC databases.

  • Delete or scale down RAC databases.

  • Create Database Provisioning Profiles for automating mass deployment.

  • Create standby databases.

  • User Defined Deployment Procedures (UDDP) to automate custom processes by creating a procedure from scratch by inserting the required phases, steps, and variables.

  • Ongoing provisioning of Exadata VMs.

Database Lifecycle Management Pack for Oracle Database

Cloning Features

  • Create a full clone database using:

    • Clone Wizard

    • EMCLI

    • Classic Cloning Wizard, which enables you to clone databases using RMAN backup, staging areas, or an existing backup.

  • Refresh a cloned database.

  • Create a full clone pluggable database using:

    • Clone Wizard

    • EMCLI

Database Lifecycle Management Pack for Oracle Database

Patching and Upgrade Features

Fleet Maintenance allows administrators to patch and upgrade database software with minimal downtime. The subscription-based model enables updates across your entire database estate, significantly reducing the time required for maintenance activities. Database fleet maintenance can be used for:

  • Single Instance Oracle Homes and associated databases
  • RAC Oracle Homes and associated databases
  • Grid Infrastructure Homes and associated Grid Instances
  • Oracle Restart Homes and associated databases
  • Standby databases (single instance and RAC)

Fleet Maintenance Hub includes the following features:

  • Subscription option: For databases and grids that are not subscribed, Fleet Maintenance Hub provides the option to subscribe them to an image, once an image is identified.
  • Automatic patch recommendations: Fleet Maintenance Hub provides patch recommendations for gold images.
  • Compliance with images: Fleet Maintenance Hub provides information on the targets that are missing required security patch recommendations.

Database Lifecycle Management Pack for Oracle Database

Configuration and Compliance Features

The Database Lifecycle Management Pack for Oracle Database includes the following compliance and configuration features:

  • Compliance frameworks, standards, and extensibility to meet industry and regulatory compliance requirements.

  • Compliance management of Exadata Engineered Systems. Secure and monitor the health of each Exadata component based on the Autonomous Health Framework EXAchk.

  • Configuration drift management to continually monitor any number of targets for drift from a live or saved reference target.

  • Configuration Collection Extensibility to create custom configuration collections and extend current collections.

  • Configuration Compare, one-to-one and one-to-many.

  • Configuration History to report and notify on configuration or relationship changes during a specific time frame.

  • Configuration Instance Browser of items and associations associated with a target.

  • Configuration Save for reference, baselines or Gold Standards.

  • Configuration Search on a specific target or across relationships.

  • Configuration Topology for a specified target and its dependencies along with other targets that are dependent on it.

Database Lifecycle Management Pack for Oracle Database

Schema Features

The Database Lifecycle Management Pack for Oracle Database includes the following schema features:

  • Schema and Data Comparisons automate the comparison of database schema and data across Databases or saved baselines.

  • Schema and Data Synchronization to propagate database objects and schemas with or without data, and update database object definitions.

  • Schema Change Plans allow developers to add changes to the schema in a plan that can be applied to multiple databases.

  • Schema Comparisons to compare database objects in two databases or baselines in Enterprise Manager or SQL developer.

  • Real-time schema change detection to track schema changes in real time to identify unwanted or unplanned changes.

Database Lifecycle Management Pack for Oracle Database

Pluggable Database Management

The Database Lifecycle Management Pack for Oracle Database includes the following PDB features:

  • Manage the entire PDB lifecycle, including the provisioning of CDBs

  • Create a new PDB using seed

  • Plug in an unplugged PDB

  • Clone a PDB

  • Migrate a Non-CDB as a PDB

  • Unplug and drop a PDB

  • Relocate PDBs between CDBs

Database Lifecycle Management Pack for Oracle Database

Oracle Fleet Patching & Provisioning (formerly known as Oracle Rapid Home Provisioning) Features

In addition to Fleet Maintenance, the Database Lifecycle Management Pack for Oracle Database includes the features from Oracle Fleet Patching & Provisioning (FPP).

  • Deploy software homes to nodes in a cloud computing environment from a single cluster where you create, store, and manage templates of Oracle homes as images of Oracle software, such as databases, middleware, and applications.

    When deployed across multiple clusters or access to the home server to provision on a remote cluster, this feature requires the Database Lifecycle Management license for the remote clusters.

    Note: A remote cluster is considered as the server where the clients are installed pointing to a different cluster as a home server.

    When using Enterprise Manager, deployment procedures and patch plans are used on the Oracle Fleet Patching & Provisioning server to:

  • Provision

  • Patch clusters or Oracle homes

Database Lifecycle Management Pack for Oracle Database

Provisioning Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database:

Database Provisioning

  • From the Enterprise menu, select Provisioning and Patching, then select Procedure Library. All procedures that Clone and Provision a Database are licensed with the Database Lifecycle Management Pack.

  • From the Enterprise menu, select Provisioning and Patching, then select Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

  • On the Oracle Database or cluster database target home page, select the Oracle Database menu, then select Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

  • On the Oracle Container Database home page, select the Oracle Database menu, Provisioning, and then select Provision Pluggable Databases. On the Provision Pluggable Databases page, all operations are licensed except for those explicitly mentioned in the Base Database Management Features section.

RAC Scale Out and Scale Back

  • From the Enterprise menu, select Provisioning and Patching, then select Procedure Library. All procedures that Extend or Scale a database or RAC are licensed with the Database Lifecycle Management Pack.

  • From the Enterprise menu, select Provisioning and Patching, then select Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

  • On the Oracle cluster database target home page, select the Oracle Database menu, then select Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Cloning Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database:

Full Clone Database

  • From the Database home page, select the Database target menu, Cloning, and then select Create Full Clone. On the Create Full Clone Database page, all features, functions, links, buttons, and drill-downs are licensed as part of the Database Lifecycle Management Pack.

Classic Clone Wizard

  • From the Database home page, select the Database target menu, Cloning, and then select Clone Management. On the Clone Management page, click Switch to Classic Clone. In the Classic Clone wizard, all features, functions, links, buttons, and drill-downs are licensed as part of the Database Lifecycle Management Pack.

Refresh Cloned Database

  • From the Database home page, select the Database target menu, Cloning, and then select Clone Management. On the Clone Management page, highlight the cloned database to be refreshed, and then click Refresh.

Full Clone PDB

  • From the PDB home page, select the PDB target menu, Cloning, and then select Create Full Clone. On the Create Full Clone Pluggable Database page, all features, functions, links, buttons, and drill-downs are licensed as part of the Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Patching and Upgrade Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database:

Database Update and Upgrade using Fleet Maintenance UI

  • From the Targets menu, select Databases, and in the Administration menu, select Standardization Advisor. This menu is licensed with the Database Lifecycle Management Pack.
  • From the Targets menu, select Databases, and in the Administration menu, select Fleet Maintenance. All update (patching) and upgrade actions are licensed with the Database Lifecycle Management Pack.
  • From the Targets menu, select Databases, and in the Administration menu, select Fleet Maintenance Hub. All update (patching) and upgrade actions are licensed with the Database Lifecycle Management Pack.

Database Upgrade

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. All procedures that Upgrade a Database are licensed with the Database Lifecycle Management Pack.

  • On the Oracle Database or cluster database target home page (includes Primary and Standby Databases), select the Oracle Database menu, then select Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

Database Patching

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. All Procedures that patch a database, Clusterware or Real Application Clusters are licensed with the Database Lifecycle Management Pack.

Offline Patching

  • From the Setup menu, select Provisioning and Patching, then Offline Patching. From the Online and Offline Setting tab, the Connection, Offline setting is licensed with the Database Lifecycle Management Pack.

User Defined Deployment Procedures (UDDP)

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. On the Provisioning Library page, from the list of actions, the Create New option is licensed as part of the Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Configuration Management Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database:

Configuration Compare

  • From the Enterprise menu, select Configuration, then select Comparison and Drift Management. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Configuration Drift

  • From the Enterprise menu, select Configuration, then select Comparison & Drift Management. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Configuration Consistency

  • From the Enterprise menu, select Configuration, then select Comparison & Drift Management. Locate the Consistency Overview section of the Dashboard Overview page. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Configuration Search

  • From the Enterprise menu, select Configuration, then select Search. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Configuration Browser

  • From the Oracle Database menu, select Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of the Database Lifecycle Management Pack.

Configuration History

  • From the Enterprise menu, select Configuration, then select History. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Configuration Save

  • From the Enterprise menu, select Configuration, then select Saved. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Configuration Topology

  • From the Enterprise menu, select Configuration, then select Comparison & Drift Management. Then click the Templates tab.

Configuration Template Management

  • To access comparison templates, from the Enterprise menu, select Configuration, then select Comparison & Drift Management. Then click the Templates tab.

Configuration Extensions and Collections

  • From the Enterprise menu, select Configuration, then select Configuration Extensions.

Configuration Results Dashboard

  • From the Enterprise menu, select Configuration, then click Comparison & Drift Management.

Database Lifecycle Management Pack for Oracle Database

Compliance Management Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database:

Compliance Dashboard

  • From the Enterprise menu, select Compliance, then select Dashboard.

Compliance Results

  • From the Enterprise menu, select Compliance, then select Results or from the Database home page, select the Database target menu, Compliance, then select Results. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Compliance Library

  • From the Enterprise menu, select Compliance, then select Library. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

Standard Associations

  • On the Oracle Database home page, select the Oracle Database menu, Compliance, and then select Standard Associations. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

Self Update

  • From the Setup menu, select Extensibility, then click Self Update. The downloading and applying of any updates associated with Compliance for database targets are licensed as part of the Database Lifecycle Management Pack.

Compliance Management of Exadata Engineered Systems

  • Select Compliance, then select Results. On the Results page, all features, functions, tabs, links, buttons, and drill-downs are licensed as part of the Database Lifecycle Management Pack.

  • Select Compliance, then select Standard Associations. On the Standard Associations page, all features, functions, links, buttons, and drill-downs are licensed as part of the Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Schema Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database. Starting from the Database target home page:

Schema Comparison

  • From the Schema menu, select Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

Schema and Data Synchronization

  • From the Schema menu, select Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

Copy Objects

  • From the Schema menu, select Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Other Licensed Links

The following licensed links, features and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages and links for the Database Lifecycle Management Pack for Oracle Database. Starting from the Database target home page:

File Synchronization

  • When viewing comparison results differences as described in the Configuration Compare feature, select the configuration specification in the tree on the left. Select Enable File Synchronization. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack for Oracle Database.

Real-Time Schema Change Detection

  • From the Administration menu, select Initialization Parameters. On the Initialization Parameters page, change the enable_ddl_logging option to TRUE to enable this feature, which is licensed as part of the Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Licensed Parameters

The init.ora parameter ENABLE_DDL_LOGGING is licensed as part of the Oracle Database Lifecycle Management Pack when set to TRUE. When set to TRUE, the database reports schema changes in real time into the database alert log under the message group schema_ddl. The default setting is FALSE.

Database Lifecycle Management Pack for Oracle Database

Licensed Reports

The following reports are part of the Database Lifecycle Management Pack for Oracle Database.

All reports in each of these sections are licensed as part of this pack. To access the reports, from the Enterprise menu, select Reports, and then select Information Publisher Reports. If you have Oracle Analytics Server installed and configured with Oracle Enterprise Manager along with the out-of-the-box reports, go to Oracle Analytics Server.

The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of the Database Lifecycle Management Pack:

  • Compliance

  • Deployment and Configuration

  • Sample Host reports, Configuration Reports

  • Security

The following reporting areas, reports, and sub-reports under your independently configured Oracle Analytics Server installation are licensed as part of the Database Lifecycle Management Pack:

  • Compliance

  • Deployment and Configuration

  • Sample Host reports, Configuration Reports

  • Security

Database Lifecycle Management Pack for Oracle Database

Licensed CLI Verbs

The following Enterprise Manager command line interface (CLI) verbs are licensed as part of the Database Lifecycle Management Pack:

associate_cs_targets config_compare config_db_service_target configure_log_archive_locations confirm_instance clone_database create_database create_standby_database describe_instance describe_procedure_input disable_config_history enable_config_history export_compliance_group export_compliance_standard_rule export_facet export_standard fix_compliance_state get_config_searches get_config_templates get_executions get_instance_data get_instance_status get_instances get_oms_config_property get_procedure_types get_procedure_xml get_procedures get_retry_argument get_saved_configs ignore_instance import_compliance_object list_oms_config_properties remove_cs_target_association reschedule_instance resume_instance run_config_search save_procedure set_config_history_retention_period stop_instance submit_procedure suspend_instance db_software_maintenance update_and_retry_step update_procedure_input upgrade_database

Database Lifecycle Management Pack for Oracle Database

Licensed REST APIs

The following Enterprise Manager REST APIs are licensed as part of the Database Lifecycle Management Pack:

Database Lifecycle Management Pack for Oracle Database

Licensed Compliance Repository Views

The following compliance repository views are part of the Database Lifecycle Management Pack for Oracle Database:

MGMT$CCC_ALL_OBS_BUNDLES MGMT$CCC_ALL_OBSERVATIONS MGMT$CCC_DIAG_ANALYTICS MGMT$CCC_DIAG_QUEUEBACKLOG MGMT$COMPLIANCE_STANDARD MGMT$COMPLIANCE_STANDARD_GROUP MGMT$COMPLIANCE_STANDARD_RULE MGMT$COMPOSITE_CS_EVAL_SUMMARY MGMT$CS_ASM_DISKGRP_SETTINGS MGMT$CS_DB_CONTROL_FILE_COUNT MGMT$CS_DB_INIT_PARAMS MGMT$CS_DB_RBS_IN_SYSTEM MGMT$CS_DB_REC_SEG_SETTINGS MGMT$CS_DB_REC_TS_SETTINGS MGMT$CS_DB_REC_USER_SETTINGS MGMT$CS_DB_REDO_LOG_COUNT MGMT$CS_DB_REDO_LOGS MGMT$CS_DB_TABLESPACES MGMT$CS_DB_TBSP_SEGSPACE_MGMT MGMT$CS_EVAL_SUMMARY MGMT$CS_FEATURE_USAGE MGMT$CS_GROUP_EVAL_SUMMARY MGMT$CS_GROUP_KEYWORD MGMT$CS_HA_INFO MGMT$CS_HIERARCHY MGMT$CS_KEYWORD MGMT$CS_RQS_HIERARCHY MGMT$CS_RULE_ATTRS MGMT$CS_RULEFOLDER MGMT$CS_RULE_EVAL_SUMMARY MGMT$CS_TARGET_ASSOC MGMT$CS_TGT_ASSOC_TXF_REQ MGMT$CSG_HIERARCHY MGMT$CSG_SUBGROUP MGMT$CSR_CURRENT_VIOLATION MGMT$CSR_TARGET_ASSOC MGMT$CSR_VIOLATION_CONTEXT MGMT$CSRF_TARGET_ASSOC MGMT$EM_CS_RULE_EVENT_ERROR MGMT$EM_RULE_VIOL_CTXT_DEF MGMT$ICS_TARGET_ASSOC MGMT$REPOSITORY_RULE_PARAMS MGMT$REPOSITORY_RULE_BIND_VARS MGMT$REPO_RULE_CHK_DETAILS MGMT$RULE_KEYWORD MGMT$RULES_EVALUATED_PER_DAY

Database Lifecycle Management Pack for Oracle Database

Licensed Provisioning and Patching Repository Views

The following provisioning and patching repository views are part of the Database Lifecycle Management Pack for Oracle Database:

Provisioning and Patching Views

EM$PROV_APPTYPES EM$PROVAPP_METADATA EM$PROVAPP_METADATA_VERSION EM$PROVAPP_TAGS EM$PROVAPP_TAG_PROPERTIES MGMT$PA_RECOM_METRIC_SOURCE

Patching Views

GC$EM_PC_PLAN_PATCHES GC$EM_PC_PLANS GC$EM_PC_PLAN_TARGETS GC_PC_EXECUTION_INSTANCES GC_PC_PLAN_ANALYSIS_RS GC_PC_PLAN_REMEDY GC_PC_PLAN_REMEDY_DETAILS GC_PC_PLAN_USERS GC_PC_TARGETS MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS MGMT$ARU_FAMILY_PRODUCT_MAP MGMT$ARU_LANGUAGES MGMT$ARU_PATCH_RECOMMENDATIONS MGMT$ARU_PLATFORMS MGMT$ARU_PRODUCT_RELEASE_MAP MGMT$ARU_PRODUCTS MGMT$ARU_RELEASES MGMT$ARU_TARGETS MGMT$PA_AFFTED_HOST_GUID_OH MGMT$PA_AFFTED_HOST_OH MGMT$PA_AFFTED_TARGETS MGMT$PA_FINAL_PATCH_LIST MGMT$PA_TARGET_MAPPING MGMT$PR_APPL_PATCHES_TO_OH MGMT$PR_APPL_PATCHES_TO_OH_TGT MGMT$PR_HOME_INFO MGMT$PR_HOMES_AFFECTED_COUNT MGMT$RECOM_METRIC_SOURCE

Database Lifecycle Management Pack for Oracle Database

Licensed Oracle Home Patching Repository Views

The following Oracle home patching repository views are part of the Database Lifecycle Management Pack for Oracle Database:

MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS MGMT$APPL_PATCH_AND_PATCHSET MGMT$CPF_ADVISORY_INFO MGMT$CPF_HOMES_INFO MGMT$CPF_PATCH_INFO MGMT$EM_HOMES_PLATFORM MGMT$HOMES_AFFECTED MGMT$OH_CLONE_PROPERTIES MGMT$OH_COMP_DEP_RULE MGMT$OH_COMP_INST_TYPE MGMT$OH_COMPONENT MGMT$OH_CRS_NODES MGMT$OH_DEP_HOMES MGMT$OH_FILE MGMT$OH_HOME_INFO MGMT$OH_INSTALLED_TARGETS MGMT$OH_INV_SUMMARY MGMT$OH_PATCH MGMT$OH_PATCHED_COMPONENT MGMT$OH_PATCHED_FILE MGMT$OH_PATCH_FIXED_BUG MGMT$OH_PATCHSET MGMT$OH_VERSIONED_PATCHV MGMT$PATCH_ADVISORIES

Database Lifecycle Management Pack for Oracle Database

Licensed Configuration Repository Views

The following configuration repository views are part of the Database Lifecycle Management Pack for Oracle Database:

Configuration Views

GC$ECM_CONFIG_SUMMARY GC$ECM_COMP_PROPERTIES GC$ECM_CURR_CONFIG GC$ECM_CURR_CONFIG_FLAT_MEMS GC$ECM_CURR_CONFIG_SNAPSHOTS GC$ECM_CURR_TARGET_SNAPSHOTS GC$ECM_DATA_RETENTION_TIME GC$ECM_GEN_SNAPSHOT GC$ECM_SAVED_CONFIG GC$ECM_SAVED_CONFIG_FLAT_MEMS GC$ECM_SAVED_CONFIG_SNAPSHOTS GC$ECM_SAVED_CONFIG_TARGETS GC$ECM_SAVED_TARGET_SNAPSHOTS MGMT$CCS_DATA MGMT$CCS_DATA_SOURCE MGMT$CCS_DATA_SOURCE_VISIBLE MGMT$CCS_DATA_VISIBLE MGMT$DB_CONTROLFILES MGMT$DB_DATAFILES MGMT$DB_DBNINSTANCEINFO MGMT$DB_FEATUREUSAGE MGMT$DB_INIT_PARAMS MGMT$DB_LICENSE MGMT$DB_OPTIONS MGMT$DB_REDOLOGS MGMT$DB_ROLLBACK_SEGS MGMT$DB_SGA MGMT$DB_TABLESPACES MGMT$DB_TABLESPACES_ALL MGMT$ECM_CMP_JOB_LAST_RESULTS MGMT$ECM_CMP_JOBS MGMT$ECM_CMP_RPT_CCS_DS MGMT$ECM_CMP_RPT_CCS_DS_DTLS MGMT$ECM_CMP_RPT_CCS_PD_ALL MGMT$ECM_CMP_RPT_CCS_PD_DIFFS MGMT$ECM_CMP_RPT_CI_DIFFS MGMT$ECM_CMP_VISIBLE_CONFIGS MGMT$ECM_CURRENT_SNAPSHOTS MGMT$ECM_VISIBLE_SNAPSHOTS MGMT$SERVICETAG_INSTANCES MGMT$SERVICETAG_REGISTRY MGMT$UNPATCHABLE_DB_TARGETS

Database Lifecycle Management Pack for Oracle Database

Licensed Configuration Repository Views (Continued)

Client Configuration Views

MGMT$CSA_COLLECTIONS MGMT$CSA_FAILED MGMT$CSA_HOST_COOKIES MGMT$CSA_HOST_CPUS MGMT$CSA_HOST_CUSTOM MGMT$CSA_HOST_IOCARDS MGMT$CSA_HOST_NICS MGMT$CSA_HOST_OS_COMPONENTS MGMT$CSA_HOST_OS_FILESYSEMS MGMT$CSA_HOST_OS_PROPERTIES MGMT$CSA_HOST_RULES MGMT$CSA_HOST_SW MGMT$ECM_CONFIG_HISTORY MGMT$CHANGES_PER_SNAPSHOT

Database Lifecycle Management Pack for Oracle Database

Licensed Security Repository Views

The following Security repository views are part of the Database Lifecycle Management Pack for Oracle Database:

MGMT$ESA_ALL_PRIVS_REPORT MGMT$ESA_ANY_DICT_REPORT MGMT$ESA_ANY_PRIV_REPORT MGMT$ESA_AUDIT_SYSTEM_REPORT MGMT$ESA_BECOME_USER_REPORT MGMT$ESA_CATALOG_REPORT MGMT$ESA_CONN_PRIV_REPORT MGMT$ESA_CREATE_PRIV_REPORT MGMT$ESA_DBA_GROUP_REPORT MGMT$ESA_DBA_ROLE_REPORT MGMT$ESA_DIRECT_PRIV_REPORT MGMT$ESA_EXMPT_ACCESS_REPORT MGMT$ESA_KEY_OBJECTS_REPORT MGMT$ESA_OH_OWNERSHIP_REPORT MGMT$ESA_OH_PERMISSION_REPORT MGMT$ESA_POWER_PRIV_REPORT MGMT$ESA_PUB_PRIV_REPORT MGMT$ESA_SYS_PUB_PKG_REPORT MGMT$ESA_TABSP_OWNERS_REPORT MGMT$ESA_TRC_AUD_PERM_REPORT MGMT$ESA_WITH_ADMIN_REPORT MGMT$ESA_WITH_GRANT_REPORT

Oracle Data Masking and Subsetting Pack

Oracle Data Masking and Subsetting Pack facilitates the discovery of sensitive data, masking the data with fictitious yet realistic looking data, and subsetting the data based on specific conditions; thereby ensuring secure and efficient use in non-production environments.

Features

Here is the list of features in this management pack:

  • Application Data Modeling

  • Sensitive Types Library

  • Data Masking Definitions

  • Data Masking Formats Library

  • Data Subsetting Definitions

  • Application Data Modeling, Data Masking and Subsetting Enterprise Manager Command Line Interface (CLI) verbs

  • Application Data Modeling accelerator for select versions of Oracle E-Business Suite

  • Application Data Modeling accelerator for select versions of Oracle Fusion Applications

  • Data Masking templates for select versions of Oracle Fusion Applications

  • Data Masking templates for select versions of Oracle E-Business Suite

Oracle Data Masking and Subsetting Pack also includes the following restricted-use licenses:

  • Database Gateway for APPC

  • Database Gateway for DRDA

  • Database Gateway for Informix

  • Database Gateway for SQL Server

  • Database Gateway for Sybase

  • Database Gateway for Teradata

If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using Oracle Data Masking and Subsetting Pack for non-Oracle databases, the Oracle Database Gateways stage the data in a separately licensed Oracle Database. Oracle Data Masking and Subsetting functionality cannot be executed directly against the non-Oracle database.

Oracle Data Masking and Subsetting Pack must be licensed for the source database server, i.e., the database from which the data originates. There is no requirement to license the pack for the staging database server on which masking and subsetting operations are executed, or for copies made of the masked database.

Licensed Links

The following are the Oracle Data Masking and Subsetting Pack licensed pages and links in Oracle Enterprise Manager for the Oracle Database instance, Cluster Database, Pluggable Database, and Autonomous Database targets.

Licensed Page/Link How to Access

Data Discovery

From the Database home page, select Security, Data Masking and Subsetting, and then select Data Discovery.

All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Oracle Data Masking and Subsetting Pack.

Data Masking

From the Database home page, select Security, Data Masking and Subsetting, and then select Data Masking.

All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Oracle Data Masking and Subsetting Pack.

Data Subsetting

From the Database home page, select Security, Data Masking and Subsetting, and then select Data Subsetting.

All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.

Note:

Oracle Data Masking and Subsetting Pack incorporates the previous Oracle Data Masking Pack, Oracle Test Data Management Pack, and Oracle Data Masking and Subsetting Pack for non-Oracle Databases.

Oracle Real Application Testing

Oracle Real Application Testing includes the following features:

  • Database Replay
  • SQL Performance Analyzer (SPA)
  • Workload Analysis
  • Database Migration Planner
  • Database Migration Workbench
Management Pack Type of Licensing Information Licensing Information

Oracle Real Application Testing

Database Replay
  • The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.
  • Use of Capture and Replay ASH Analytics Reports, Compare Period ADDM Reports, and Replay Compare Period Reports also requires an Oracle Diagnostics Pack license.
  • An Oracle Real Application Testing license permits you to access Database Replay functionality through Oracle Enterprise Manager, as well as through the following database server command-line APIs: DBMS_WORKLOAD_CAPTURE package and DBMS_WORKLOAD_REPLAY package. The use of the DBMS_WORKLOAD_REPLAY. COMPARE_PERIOD_REPORT() function also requires a license for Oracle Diagnostics Pack.

Oracle Real Application Testing

SQL Performance Analyzer (SPA)

An Oracle Real Application Testing license permits you to access SQL Performance Analyzer functionality through Oracle Enterprise Manager, as well as through the following database server command-line API: DBMS_SQLPA package, which is part of the Oracle Real Application Testing option.

Oracle Real Application Testing

Workload Analysis

An Oracle Real Application Testing license permits you to access Workload Analysis functionality through Oracle Enterprise Manager, as well as through the following database server command-line API: DBMS_SQLPA package, which is part of the Oracle Real Application Testing option.

Oracle Real Application Testing

Database Migration Planner
  • Database Migration Planner provides a comprehensive end-to-end solution for managing database consolidation with a risk-free and accurate approach to consolidate by eliminating guess work by analyzing historical workload (DB, Host metrics).
  • Provides a heatmap of predicted usage for the new configuration, both Oracle Cloud and on-premises environments.
  • Use of the consolidation planning feature of Database Migration Planner requires an Oracle Diagnostics Pack license.
  • An Oracle Real Application Testing license permits you to access the Database Migration Planner page in Oracle Enterprise Manager.

    To access Database Migration Planner:

    From the Enterprise menu, select Migration and Consolidation, then select Database Migration Planner.

    All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Planner.

Oracle Real Application Testing

Database Migration Workbench
  • Database Migration Workbench provides a data-driven and systematic approach to consolidate by eliminating guess work and human errors. Database Migration Workbench has three key capabilities: consolidation planning, database migration, and performance validation.
  • Use of the consolidation planning feature of Database Migration Workbench requires an Oracle Diagnostics Pack license.
  • An Oracle Real Application Testing license permits you to access the following links on the Database Migration Workbench page in Oracle Enterprise Manager.

    To access Database Migration Workbench, you can use one of the following options:

    • From the Enterprise menu, select Migration and Consolidation, then select Database Migration Workbench.
    • On the database target home page, select the Administration menu, then select Database Migration Workbench.

    All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Workbench.

Exadata Management Pack

The Exadata Management Pack provides advanced monitoring, management, and diagnostics features for mixed fleets of on-premises and Cloud-based Exadata systems, as well as the databases running on these systems.

The following table describes this management pack offered by Enterprise Manager:

Management Pack Type of Licensing Information Licensing Information

Exadata Management Pack

Prerequisites

The Exadata Management Pack requires the Oracle Diagnostics Pack.

Exadata Management Pack

Features

The Exadata Management Pack includes the following features:

  • Engineered System Autonomous Health Framework (AHF) Administration: Provides comprehensive monitoring and management of AHF and EXAChk across the Engineered System fleet.

  • Database Impact Advisor: Performs system-wide database CPU usage noisy-neighbor analysis to identify databases whose performance is potentially impacted by other databases or other operating system processes.

  • I/O Resource Management Advisor: Provides interactive visualizations that facilitate the analysis of flash I/O utilization across databases (non-CDB, CDB, and PDB) on an Exadata system in order to identify databases that might be impacted by system I/O limits and I/O usage by other databases, and to determine if the system has capacity for additional I/O load.

  • Exadata Fleet Dashboards: Filters and visualizes Exadata component hardware and software metric data for individual Exadata (on premises and cloud-based) and Recovery Appliance systems.

  • Exascale Advanced Monitoring: Provides advanced IOPS monitoring through the IOPS tab using an interactive Sankey-based diagram of IOPS allocations across Vaults, Storage Pools, and Databases.

  • Exadata Cloud Advanced Monitoring: Provides advanced database inventory monitoring using a Sankey-based topology diagram and a tabular listing of database inventory on the system.

  • Exadata Infrastructure Patching: Leverages Fleet Maintenance to centrally patch Database servers (Bare Metal), Xen DomU, KVM Guests, Storage Servers, and Switches at scale. Also, schedules and performs rollback of patches seamlessly, all from a single platform.

  • Metrics Dashboard: Provides customizable visualization capability for key Engineered System hardware and software metrics, as well as curated visualization of metrics pertinent to resource planning.

Exadata Management Pack

Engineered System AHF Administration Licensed Links

The following are the licensed pages and links for Engineered System AHF Administration in the Exadata Management Pack:

  • From the Enterprise menu, select Compliance, and then select Engineered System Autonomous Health Framework Administration.

  • From the Targets menu, select Exadata, Actions, and then select Engineered System Autonomous Health Framework Administration.

Exadata Management Pack

Database Impact Advisor Licensed Links

The Database Impact Advisor is available for individual Database Machine targets for which the Exadata Management Pack has been enabled. The following is the licensed page and link for Database Impact Advisor in the Exadata Management Pack:

  • For individual Database Machine targets, in the main Database Machine target menu, select Database Impact Advisor.

Exadata Management Pack

I/O Resource Management Advisor Licensed Links

The I/O Resource Management Advisor is available for individual Database Machine and Exadata Infrastructure targets for which the Exadata Management Pack has been enabled. The following is the licensed page and link for I/O Resource Management Advisor in the Exadata Management Pack:

  • For individual Database Machine or Exadata Infrastructure targets, in the main target menu, select I/O Resource Management Advisor.

Exadata Management Pack

 Exadata Fleet Dashboards Licensed Links

The following are the licensed pages and links for Exadata Fleet Dashboards in the Exadata Management Pack:

  • From the Enterprise menu, select Dashboards, and then select Exadata Fleet Configuration.

  • From the Enterprise menu, select Dashboards, and then select Exadata Fleet Aggregated Capacity.

  • From the Enterprise menu, select Dashboards, and then select Exadata Fleet Capacity.

  • From the Enterprise menu, select Dashboards, and then select Exadata Fleet Component Capacity.

Exadata Management Pack

Exascale Advanced Monitoring Licensed Links

The Exascale Advanced Monitoring is available for individual Exascale targets that are associated with a Database Machine target for which the Exadata Management Pack has been enabled. The following is the licensed page and link for Exascale Advanced Monitoring in the Exadata Management Pack:

  • On the Exascale home page, select Performance.

Note that only specific content in the Performance tab on the Exascale home page is a part of the Exadata Management Pack.

Exadata Management Pack

Exadata Cloud Advanced Monitoring Licensed Links

The Exadata Cloud Advanced Monitoring is available for individual Exadata Infrastructure targets for which the Exadata Management Pack has been enabled. The following are the licensed pages and links for Exadata Cloud Advanced Monitoring in the Exadata Management Pack:

  • On the Exadata Infrastructure home page, select the Resource Usage tab.

  • On the VM Cluster home page, select the Databases tab.

Note that only specific content in the Exadata Infrastructure Resource Usage tab and the VM Cluster Databases tab is a part of the Exadata Management Pack.

Exadata Management Pack

Exadata Infrastructure Patching Licensed Links

The following is the licensed page and link for Exadata Infrastructure Patching in the Exadata Management Pack:

  • From the Targets menu, select Exadata, and then click Fleet Maintenance.

Exadata Management Pack

Metrics Dashboard Licensed Links

The following is the licensed page and link for Metrics Dashboard in the Exadata Management Pack:

  • From the Database Machine or the appropriate Engineered System target menu, select Metrics Dashboard.

Exadata Management Pack

 Exadata Infrastructure Patching Licensed CLI Verbs

The following Enterprise Manager command line interface (CLI) verb is licensed as part of Exadata Infrastructure Patching in the Exadata Management Pack:

db_software_maintenance

You can use this CLI verb with the following commands:

  • -registerFPPServer: Registers FPP servers

  • -registerFPPClient: Registers FPP client to FPP server

  • -optInFPPSeries: Stores the image series information in Enterprise Manager

  • -updateVersionStatus: Updates the version status of the image to current

  • -createSoftwareImage: Creates a new Exapatch gold image

  • -subscribeTarget: Subscribes targets to the selected image

  • -performOperation: Deploys, updates, or rolls back Exapatch image

Exadata Management Pack

Exadata Infrastructure Patching Licensed REST APIs

The following Enterprise Manager REST APIs are licensed as part of Exadata Infrastructure Patching in the Exadata Management Pack:

  • /em/api/fppServers (POST)

  • /em/api/fppClients (POST)

  • /em/api/goldImages/actions/fppSeriesOptIn (POST)

  • /em/api/goldImages (GET and POST)

  • /em/api/goldImages/{imageID}/versions (POST)

  • /em/api/goldImages/{ImageID}/actions/subscribeTargets (POST)

  • /em/api/fleetOperations (GET and POST)

  • /em/api/goldImages/{goldImageId}/versions/{versionId} (PATCH)

Zero Data Loss Recovery Appliance Management Pack

The Zero Data Loss Recovery Appliance Management Pack provides advanced features for managing database fleet backup to one or more Recovery Appliances, and for monitoring and managing a fleet of Recovery Appliances.

The following table describes this management pack offered by Enterprise Manager:

Management Pack Type of Licensing Information Licensing Information

Zero Data Loss Recovery Appliance Management Pack

Features

The Zero Data Loss Recovery Appliance Management Pack includes the following features:

  • Configure Database Fleet Backup to Recovery Appliance: Provides the ability to configure a mixed fleet of databases (versions, types, roles) to send backups and redo to a Recovery Appliance, that is, configure them for Recovery Appliance protection.

  • Schedule Database Fleet Backup to Recovery Appliance: Provides the ability to schedule the standardized Oracle-suggested Recovery Appliance backup strategy for a fleet of databases that have already been configured for Recovery Appliance protection.

  • Recovery Appliance Protected Database Fleet Archival Backup Management: Performs and manages archival backups of certain databases in the fleet to meet regulatory requirements.

  • Database Fleet Advanced Backup Configuration for Recovery Appliance Using EMCLI: Supports the configuration of advanced backup topologies involving databases in an Oracle Data Guard configuration and multiple Recovery Appliances.

Zero Data Loss Recovery Appliance Management Pack

Configure Database Fleet Backup to Recovery Appliance Licensed Links

The following are the licensed pages and links for Configure Database Fleet Backup to Recovery Appliance in the Zero Data Loss Recovery Appliance Management Pack:

  • From the Targets menu, select Databases, Availability, and then select Configure Fleet Backup to Recovery Appliance.

  • From the Targets menu, select Recovery Appliances, Actions, and then select Configure Fleet Backup to Recovery Appliance.

Zero Data Loss Recovery Appliance Management Pack

Schedule Database Fleet Backup to Recovery Appliance Licensed Links

The following are the licensed pages and links for Schedule Database Fleet Backup to Recovery Appliance in the Zero Data Loss Recovery Appliance Management Pack:

  • From the Targets menu, select Databases, Availability, and then select Schedule Oracle-Suggested Fleet Backup to Recovery Appliance.

  • From the Targets menu, select Recovery Appliances, Actions, and then select Schedule Oracle-Suggested Fleet Backup to Recovery Appliance.

Zero Data Loss Recovery Appliance Management Pack

Recovery Appliance Protected Database Fleet Archival Backup Management Licensed Links

The following are the licensed pages and links to Recovery Appliance Protected Database Fleet Archival Backup Management in the Zero Data Loss Recovery Appliance Management Pack:

  • From the Targets menu, select Recovery Appliances, Archival Backups, and then click Create Archival Backup.

  • From the Targets menu, select Recovery Appliances, Protected Databases, and then click Create Archival Backup.

In the Create Archival Backup dialog box, click Databases in protection policy.

Zero Data Loss Recovery Appliance Management Pack

Licensed CLI Verbs

The following parameters in the configure_db_ha -configureBackupToRA Enterprise Manager Command Line Interface (CLI) verb are licensed as part of the Zero Data Loss Recovery Appliance Management Pack:

  • -backup_config parameter with values:

    • GOLD

    • GOLD_WITH_REP

  • br_continuity parameter and associated parameters:

    • alternate_ra_target_name

    • ra_local_vpc_username

    • alternate_ra_override_connect_desc

    • br_continuity_override_connect_desc

    • ship_redo_from_standby

Zero Data Loss Recovery Appliance Management Pack

Licensed REST APIs

The following Enterprise Manager REST APIs are licensed as part of the Zero Data Loss Recovery Appliance Management Pack:

  • /databases/{databaseId}/actions/configureBackup

  • /databases/actions/bulkConfigureBackup

  • /databases/actions/bulkSubmitBackup

  • /zdlra/{raTargetId}/archivalBackups/protectionPolicy/{protectionPolicyName}

Legacy: Configuration Management Pack for Oracle Database

Oracle Enterprise Manager no longer offers the Configuration Management Pack for Oracle Database. Enterprise Manager 10g and 11g customers who purchased the Configuration Management Pack for Oracle Database can use the Configuration Management Pack features in Enterprise Manager as described in the following table:

Management Pack Type of Licensing Information Licensing Information

Configuration Management Pack for Oracle Database

Feature Summary

You are entitled to use the following features with a previously purchased Configuration Management Pack for Oracle Database License:

  • Compliance Frameworks, Standards and extensibility to meet industry and regulatory compliance requirements.

  • Configuration Collection Extensibility to create custom configuration collections and extend current collections.

  • Configuration Compare: one-to-one, one-to-many, file sync.

  • Configuration History to report on configuration or relations changes during a specific time frame.

  • Configuration Instance Browser to view Configuration Items and associations associated with a target.

  • Configuration Save of configurations for reference, baselines or Gold Standards.

  • Configuration Search for Configuration Items on a specific target or across relationships.

  • Configuration Topology to view topology for a specified target and its dependencies along with other targets that are dependent on it.

  • Exadata Database Machine Configuration provides Configuration Information for all components of the DB Machine including, Storage Cells, Database and InfiniBand Switches.

  • Exadata Database Machine Configuration Actions provides the ability to compare and search. Provides history and compliance information.

  • File Synchronization of configuration file differences during a comparison.

  • Real-time configuration change detection and automation of compliance frameworks.

Configuration Management Pack for Oracle Database

Feature Summary (Continued)

With the previous purchase of the Configuration Management Pack for Oracle Database, you also are entitled to the features described in the following sections. These features are restricted to the Oracle Database targets in the Oracle Database Home and the Platform (hardware and operating system) for the CPUs you have licensed.

  • Application Configuration Console provides IT infrastructure teams with an automated "gold master" approach to infrastructure configuration management.

    Application Configuration Console includes a restricted-use license for Oracle Database (Enterprise Edition) solely for the purpose of running the Application Configuration Console Server.

  • Self Update is accessed from the Enterprise Manager home page, click the Setup menu, then Extensibility and Self Update. The downloading and applying any updates associated with Configuration and Compliance are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Management Pack for Oracle Database

Licensed Links

The following licensed links, features, and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

You are entitled to use the following features with a previously purchased Configuration Management Pack for Oracle Database License:

Configuration Instance Browser

  • From the Targets menu, select Databases, and select a Database. From the database home page, click Oracle Database, Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of the Configuration Management Pack for Oracle Database.

  • From the database home page, select Oracle Database, Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Search

  • From the Enterprise menu, select Configuration and Search. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration History

  • From the Enterprise menu, select Configuration and History. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Compare

  • From the Enterprise menu, select Configuration and Compare. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Management Pack for Oracle Database

Licensed Links (continued)

File Synchronization

  • When viewing comparison results differences as described in the Configuration Compare feature, select the configuration specification in the tree on the left. Select Enable File Synchronization. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Save

  • From the Enterprise menu, select Configuration and Save. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Collection Extensibility

  • From the Enterprise menu, select Configuration and Custom. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Configuration Management Pack for Oracle Database.

Real-time Configuration Change Detection and Compliance

  • From the Enterprise menu, select Compliance. All features, functions, links, buttons, and drill-downs associated with the Library, Results, and Real-Time Observations pages are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Topology

  • From the Target Home Page, click Oracle Database, Configuration, Topology. In the View drop-down, Used By is licensed as part of the Configuration Management Pack for Oracle Database.

  • From the Target Home Page, click Oracle Database, Configuration, Topology, Customization. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Configuration Management Pack for Oracle Database.

Configuration Management Pack for Oracle Database

Licensed Reports

The following reports are part of the Configuration Management Pack for Oracle Database. These reports and associated features apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

All database reports in each of these sections are licensed for this pack. To access the reports, go to the Enterprise Manager home page, and from the Enterprise menu, select Reports, and then select Information Publisher Reports. If you have Oracle Analytics Server installed and configured with Oracle Enterprise Manager along with the out-of-the-box reports, go to Oracle Analytics Server.

The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of the Configuration Management Pack for Oracle Database:

  • Compliance

  • Configuration

The following reporting areas, reports, and sub-reports under your independently configured Oracle Analytics Server installation are licensed as part of the Configuration Management Pack for Oracle Database:

  • Compliance

  • Configuration

Configuration Management Pack for Oracle Database

Licensed Configuration Views

The following Configuration repository views are part of the Configuration Management Pack for Oracle Database:

MGMT$CCS_DATA MGMT$CCS_DATA_SOURCE MGMT$CCS_DATA_SOURCE_VISIBLE MGMT$CCS_DATA_VISIBLE MGMT$CS_ASM_DISKGRP_SETTINGS MGMT$CS_DB_CONTROL_FILE_COUNT MGMT$CS_DB_INIT_PARAMS MGMT$CS_DB_RBS_IN_SYSTEM MGMT$CS_DB_REC_SEG_SETTINGS MGMT$CS_DB_REC_TS_SETTINGS MGMT$CS_DB_REC_USER_SETTINGS MGMT$CS_DB_REDO_LOG_COUNT MGMT$CS_DB_REDO_LOGS MGMT$CS_DB_TABLESPACES MGMT$CS_DB_TBSP_SEGSPACE_MGMT MGMT$CS_FEATURE_USAGE MGMT$CS_HA_INFO MGMT$DB_CONTROLFILES MGMT$DB_DATAFILES MGMT$DB_DBNINSTANCEINFO MGMT$DB_FEATUREUSAGE MGMT$DB_INIT_PARAMS MGMT$DB_LICENSE MGMT$DB_OPTIONS MGMT$DB_REDOLOGS MGMT$DB_ROLLBACK_SEGS MGMT$DB_SGA MGMT$DB_TABLESPACES MGMT$DB_TABLESPACES_ALL MGMT$ECM_CURRENT_SNAPSHOTS MGMT$ECM_VISIBLE_SNAPSHOTS MGMT$HW_CPU_DETAILS MGMT$HW_IO_DEVICES MGMT$HW_NIC_BONDS MGMT$J2EE_APPLICATION MGMT$J2EEAPP_EJBCOMPONENT MGMT$J2EEAPP_JRFWS MGMT$J2EEAPP_JRFWSOPER MGMT$J2EEAPP_JRFWSPOLICY MGMT$J2EEAPP_JRFWSPORT MGMT$J2EEAPP_WEBAPPCOMPONENT MGMT$J2EEAPP_WSCONFIG

Configuration Management Pack for Oracle Database

Licensed Compliance Views

The following Configuration repository views are part of the Configuration Management Pack for Oracle Database:

MGMT$CCC_ALL_OBS_BUNDLES MGMT$CCC_ALL_OBSERVATIONS MGMT$CCC_DIAG_ANALYTICS MGMT$CCC_DIAG_QUEUEBACKLOG MGMT$COMPLIANCE_STANDARD MGMT$COMPLIANCE_STANDARD_GROUP MGMT$COMPLIANCE_STANDARD_RULE MGMT$COMPOSITE_CS_EVAL_SUMMARY MGMT$CS_EVAL_SUMMARY MGMT$CS_GROUP_EVAL_SUMMARY MGMT$CS_RULE_EVAL_SUMMARY MGMT$CS_TARGET_ASSOC MGMT$J2EEAPP_WSPORTCONFIG MGMT$OS_INIT_SERVICES MGMT$OS_KERNEL_PARAMS MGMT$OS_LIMITS MGMT$OS_MODULES MGMT$OS_PROPERTIES MGMT$SERVICETAG_INSTANCES MGMT$SERVICETAG_REGISTRY MGMT$UNPATCHABLE_DB_TARGETS MGMT$WEBLOGIC_APPLICATIONS MGMT$WEBLOGIC_CLUSTER MGMT$WEBLOGIC_DOMAIN MGMT$WEBLOGIC_EJBCOMPONENT MGMT$WEBLOGIC_JDBCDATASOURCE MGMT$WEBLOGIC_JDBCMULTIDS MGMT$WEBLOGIC_JMSCONNFACTORY MGMT$WEBLOGIC_JMSQUEUE MGMT$WEBLOGIC_JMSTOPIC MGMT$WEBLOGIC_JOLTCONNPOOL MGMT$WEBLOGIC_MACHINE MGMT$WEBLOGIC_NETWORK_CHANNELS MGMT$WEBLOGIC_NODEMANAGER MGMT$WEBLOGIC_RACONFIG MGMT$WEBLOGIC_RAOUTBOUNDCONFIG MGMT$WEBLOGIC_RESOURCECONFIG MGMT$WEBLOGIC_SERVER MGMT$WEBLOGIC_STARTSHUTCLASSES MGMT$WEBLOGIC_VIRTUALHOST MGMT$WEBLOGIC_WEBAPPCOMPONENT MGMT$WEBLOGIC_WORKMANAGER MGMT$WEBLOGIC_WSCONFIG

Configuration Management Pack for Oracle Database

Licensed Oracle Home Patching Views

The following Oracle Home Patching repository views are part of the Configuration Management Pack for Oracle Database:

MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS MGMT$APPL_PATCH_AND_PATCHSET MGMT$CPF_ADVISORY_INFO MGMT$CPF_HOMES_INFO MGMT$CPF_PATCH_INFO MGMT$EM_HOMES_PLATFORM MGMT$HOMES_AFFECTED MGMT$OH_CLONE_PROPERTIES MGMT$OH_COMP_DEP_RULE MGMT$OH_COMP_INST_TYPE MGMT$OH_COMPONENT MGMT$OH_CRS_NODES MGMT$OH_DEP_HOMES MGMT$OH_FILE MGMT$OH_HOME_INFO MGMT$OH_INSTALLED_TARGETS MGMT$OH_INV_SUMMARY MGMT$OH_PATCH MGMT$OH_PATCHED_COMPONENT MGMT$OH_PATCHED_FILE MGMT$OH_PATCHSET MGMT$OH_PATCH_FIXED_BUG MGMT$OH_VERSIONED_PATCHV MGMT$PATCH_ADVISORIES

Configuration Management Pack for Oracle Database

Licensed Security Views

The following Security repository views are part of the Configuration Management Pack for Oracle Database:

MGMT$ESA_ALL_PRIVS_REPORT MGMT$ESA_ANY_DICT_REPORT MGMT$ESA_ANY_PRIV_REPORT MGMT$ESA_AUDIT_SYSTEM_REPORT MGMT$ESA_BECOME_USER_REPORT MGMT$ESA_CATALOG_REPORT MGMT$ESA_CONN_PRIV_REPORT MGMT$ESA_CREATE_PRIV_REPORT MGMT$ESA_DBA_GROUP_REPORT MGMT$ESA_DBA_ROLE_REPORT MGMT$ESA_DIRECT_PRIV_REPORT MGMT$ESA_EXMPT_ACCESS_REPORT MGMT$ESA_KEY_OBJECTS_REPORT MGMT$ESA_OH_OWNERSHIP_REPORT MGMT$ESA_OH_PERMISSION_REPORT MGMT$ESA_POWER_PRIV_REPORT MGMT$ESA_PUB_PRIV_REPORT MGMT$ESA_SYS_PUB_PKG_REPORT MGMT$ESA_TABSP_OWNERS_REPORT MGMT$ESA_TRC_AUD_PERM_REPORT MGMT$ESA_WITH_ADMIN_REPORT MGMT$ESA_WITH_GRANT_REPORT

Configuration Management Pack for Oracle Database

Licensed Client Configuration Views

The following Client Configuration repository views are part of the Configuration Management Pack for Oracle Database:

MGMT$CSA_COLLECTIONS MGMT$CSA_FAILED MGMT$CSA_HOST_COOKIES MGMT$CSA_HOST_CPUS MGMT$CSA_HOST_CUSTOM MGMT$CSA_HOST_IOCARDS MGMT$CSA_HOST_NICS MGMT$CSA_HOST_OS_COMPONENTS MGMT$CSA_HOST_OS_PROPERTIES MGMT$CSA_HOST_OS_FILESYSEMS MGMT$CSA_HOST_RULES MGMT$CSA_HOST_SW MGMT$ECM_CONFIG_HISTORY MGMT$ECM_CONFIG_HISTORY_KEY1 MGMT$ECM_CONFIG_HISTORY_KEY2 MGMT$ECM_CONFIG_HISTORY_KEY3 MGMT$ECM_CONFIG_HISTORY_KEY4 MGMT$ECM_CONFIG_HISTORY_KEY5 MGMT$ECM_CONFIG_HISTORY_KEY6 MGMT$HW_NIC MGMT$OS_COMPONENTS MGMT$OS_FS_MOUNT MGMT$OS_HW_SUMMARY MGMT$OS_HW_SUMMARY MGMT$OS_PATCHES MGMT$OS_SUMMARY MGMT$SOFTWARE_COMPONENT_ONEOFF MGMT$SOFTWARE_COMPONENTS MGMT$SOFTWARE_COMP_PATCHSET MGMT$SOFTWARE_DEPENDENCIES MGMT$SOFTWARE_HOMES MGMT$SOFTWARE_ONEOFF_PATCHES MGMT$SOFTWARE_OTHERS MGMT$SOFTWARE_PATCHES_IN_HOMES MGMT$SOFTWARE_PATCHSETS

Legacy: Change Management Pack for Oracle Database

Oracle Enterprise Manager no longer offers the Change Management Pack for Oracle Database. Enterprise Manager 10g and 11g Customers who purchased the Change Management Pack for Oracle Database can use the Change Management features in Enterprise Manager as described in the following table:

Management Pack Type of Licensing Information Licensing Information

Change Management Pack for Oracle Database

Feature Summary

You are entitled to use the following features with a Change Management Pack for Oracle Database License:

  • Schema Comparisons of database objects in two databases or baselines in Enterprise Manager or SQL developer.

  • Schema and Data Comparisons to automate the comparison of database schema and data across Databases or saved baselines.

  • Schema and Data Synchronization to propagate database objects and schemas with or without data, and update database object definitions.

  • Copy Database Objects with data, with a subset of data, or without data.

  • Real-time schema change detection to track schema changes in real time to identify unwanted or unplanned changes.

With the previous purchase of the Change Management Pack for Oracle Database, you also are entitled to the features described below. These features are restricted to the Oracle Database targets in the Oracle Database Home and the Platform (hardware and operating system) for the CPUs you have licensed.

  • Self Update is accessed from the Setup menu, select Extensibility and Self Update. The downloading and applying any updates associated with Database Change Management are licensed as part of the Change Management Pack for Oracle Database.

Change Management Pack for Oracle Database

Licensed Links

The following Licensed Links, features, and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

The following are the licensed pages, links, features, and functions that can be use with an existing Change Management Pack for Oracle Database License:

Schema Comparison

  • From the Targets menu, select Databases, and then select a Database. From the database home page, click Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Change Management Pack for Oracle Database.

Schema and Data Comparisons

  • From the Targets menu, select Databases, and then select a Database. From the database home page, click Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Change Management Pack for Oracle Database.

Schema and Data Synchronization

  • From the Targets menu, select Databases, and then select a Database. From the database home page, click Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Change Management Pack for Oracle Database.

Copy Objects

  • From the Targets menu, select Databases, and then select a Database. From the database home page, click Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Change Management Pack for Oracle Database.

Real-Time Schema Change Detection

  • From the Targets menu, select Databases, and then select a Database. From the database home page, click Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Change Management Pack for Oracle Database.

Change Management Pack for Oracle Database

Licensed Reports

The following reports are part of the Change Management Pack for Oracle Database.

All the Oracle Database reports in each of these sections are licensed for this pack. To access the reports, go to the Enterprise Manager home page, and from the Enterprise menu, select Reports, and then select Information Publisher Reports. If you have Oracle Analytics Server installed and configured with Oracle Enterprise Manager along with the out-of-the-box reports, go to Oracle Analytics Server.

The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of the Change Management Pack for Oracle Database:

  • Database Change Management

The following reporting areas, reports, and sub-reports under your independently configured Oracle Analytics Server installation are licensed as part of the Change Management Pack for Oracle Database:

  • Database Change Management

Change Management Pack for Oracle Database

Licensed Parameters

The init.ora parameter ENABLE_DDL_LOGGING is licensed as part of the Change Management Pack for Oracle Database when set to TRUE. The default is FALSE.

Legacy: Provisioning and Patch Automation Pack for Oracle Database

Oracle Enterprise Manager no longer offers the Provisioning and Patch Automation Pack for Oracle Database. Enterprise Manager 10g and 11g customers who purchased the Provisioning and Patch Automation Pack for Oracle Database can use the Provisioning and Patch Automation features in Enterprise Manager as described in the following table:

Management Pack Type of Licensing Information Licensing Information

Provisioning and Patch Automation Pack for Oracle Database

Feature Summary

You are entitled to use the following features with a previously purchased Provisioning and Patch Automation Pack for Oracle Database license:

  • Database Patching for end-to-end patch automation for Oracle Database and RAC.

  • Database Provisioning to provision databases and Oracle homes.

  • Database Upgrade existing Oracle Database.

  • Patch Recommendations of My Oracle Support Critical Patch Recommendations.

  • Patching Planning of My Oracle Support Patching Plans, patch Validation and Download.

  • Provisioning Procedures to deploy operating system and Oracle Database and Real Application Clusters.

  • RAC Scale Out and Scale Back to extend single instance databases to RAC.

With the previous purchase of the Provisioning and Patch Automation Pack for Oracle Database, you also are entitled to the features described in the following sections. These features are restricted to the Oracle Database targets in the Oracle Database Home and the Platform (hardware and operating system) for the CPUs you have licensed.

  • The oplan Utility (The basic OPlan feature is free for everyone that has an Oracle Support contract. Use of OPlan metadata to drive orchestration logic from either Enterprise Manager or custom/third-party scripts is part of the Provisioning and Patch Automation Pack for Oracle Database.)

  • Migrate to ASM

  • Self Update

Provisioning and Patch Automation Pack for Oracle Database

Licensed Links

The following licensed links, features, and functions apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack:

Provisioning Procedures

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. All Procedures that Clone, Provision, Patch, and Upgrade a Database are licensed with the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Enterprise menu, select Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

Database Upgrade

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. All procedures that upgrade a Database are licensed with the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Enterprise menu, select Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

Provisioning and Patch Automation Pack for Oracle Database

Licensed Links (continued)

Database Provisioning and Cloning

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. All procedures that Clone and Provision a Database are licensed with the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Enterprise menu, select Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

RAC Scale Out and Scale Back

  • From the Enterprise menu, select Provisioning and Patching, then Procedure Library. All Procedures that Extend or Scale a database or RAC are licensed with the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Enterprise menu, select Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

  • From the Oracle cluster database target home page, click the Oracle Database menu, then Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

Database Patching

  • From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that patch a database, Clusterware or Real Application Clusters are licensed with the Provisioning and Patch Automation Pack for Oracle Database.

Offline Patching

  • From the Enterprise Manager home page, click the Setup menu, Provisioning and Patching, then Offline Patching. From the Online and Offline Setting tab, the Connection, Offline setting is licensed with the Provisioning and Patch Automation Pack for Oracle Database.

Provisioning and Patch Automation Pack for Oracle Database

Licensed Reports

The following reports are part of the Provisioning and Patch Automation Pack for Oracle Database. These reports and associated features apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management of non-Oracle Database targets, you must purchase the appropriate management pack.

All reports in each of these sections are licensed for this pack. To access the reports, go to the Enterprise Manager home page, and from the Enterprise menu, select Reports, and then select Information Publisher Reports. If you have Oracle Analytics Server installed and configured with Oracle Enterprise Manager along with the out-of-the-box reports, go to Oracle Analytics Server.

The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:

  • Deployment and Configuration

The following reporting areas, reports, and sub-reports under your independently configured Oracle Analytics Server installation are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:

  • Deployment and Configuration

Provisioning and Patch Automation Pack for Oracle Database

Licensed CLI Verbs

The following Enterprise Manager command line interface (CLI) verbs are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:

clone_database confirm_instance create_database describe_instance describe_procedure_input get_executions get_instance_data get_instance_status get_instances get_procedure_types get_procedure_xml get_procedures get_retry_argument ignore_instance reschedule_instance resume_instance save_procedure stop_instance submit_procedure suspend_instance update_and_retry_step update_procedure_input upgrade_database

Provisioning and Patch Automation Pack for Oracle Database

Licensed Provisioning and Patching Views

The following Provisioning and Patching repository views are part of the Provisioning and Patch Automation Pack for Oracle Database:

Provisioning and Patching Views

EM$PROV_APPTYPES EM$PROVAPP_METADATA EM$PROVAPP_METADATA_VERSION EM$PROVAPP_TAG_PROPERTIES EM$PROVAPP_TAGS MGMT$PA_RECOM_METRIC_SOURCE

Patching Views

GC$EM_PC_PLAN_PATCHES GC$EM_PC_PLAN_TARGETS GC$EM_PC_PLANS GC_PC_EXECUTION_INSTANCES GC_PC_PLAN_ANALYSIS_RS GC_PC_PLAN_REMEDY GC_PC_PLAN_REMEDY_DETAILS GC_PC_PLAN_USERS GC_PC_TARGETS MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS MGMT$ARU_FAMILY_PRODUCT_MAP MGMT$ARU_LANGUAGES MGMT$ARU_PATCH_RECOMMENDATIONS MGMT$ARU_PLATFORMS MGMT$ARU_PRODUCTS MGMT$ARU_PRODUCT_RELEASE_MAP MGMT$ARU_RELEASES MGMT$ARU_TARGETS MGMT$PA_AFFTED_HOST_GUID_OH MGMT$PA_AFFTED_HOST_OH MGMT$PA_AFFTED_TARGETS MGMT$PA_FINAL_PATCH_LIST MGMT$PA_TARGET_MAPPING MGMT$PR_APPL_PATCHES_TO_OH MGMT$PR_APPL_PATCHES_TO_OH_TGT MGMT$PR_HOMES_AFFECTED_COUNT MGMT$PR_HOME_INFO MGMT$RECOM_METRIC_SOURCE

Provisioning and Patch Automation Pack for Oracle Database

Licensed Oracle Home Patching Views

The following Oracle Home Patching repository views are part of the Provisioning and Patch Automation Pack for Oracle Database:

MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS MGMT$APPL_PATCH_AND_PATCHSET MGMT$CPF_ADVISORY_INFO MGMT$CPF_HOMES_INFO MGMT$CPF_PATCH_INFO MGMT$EM_HOMES_PLATFORM MGMT$HOMES_AFFECTED MGMT$OH_CLONE_PROPERTIES MGMT$OH_COMPONENT MGMT$OH_COMP_DEP_RULE MGMT$OH_COMP_INST_TYPE MGMT$OH_CRS_NODES MGMT$OH_DEP_HOMES MGMT$OH_FILE MGMT$OH_HOME_INFO MGMT$OH_INSTALLED_TARGETS MGMT$OH_INV_SUMMARY MGMT$OH_PATCH MGMT$OH_PATCHED_COMPONENT MGMT$OH_PATCHED_FILE MGMT$OH_PATCHSET MGMT$OH_PATCH_FIXED_BUG MGMT$OH_VERSIONED_PATCHV MGMT$PATCH_ADVISORIES