2 Enterprise Database Management

This chapter describes the management packs offered by Enterprise Manager in support of Oracle Database. 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 Database Control, Oracle Enterprise Manager Cloud Control, Oracle Enterprise Manager Database Express, and APIs provided with Oracle Database software.

Note:

Oracle Enterprise Manager Cloud Control 13c supports management of Oracle Database Standard Edition One, Oracle Database Standard Edition, and Oracle Database Enterprise Edition. Other editions of Oracle Database, such as Oracle Database Personal Edition, which provides single-user development and deployment environments, is not supported by Oracle Enterprise Manager. For more information about the Oracle Database product family, see:

http://docs.oracle.com/cd/E16655_01/license.121/e17614/editions.htm#DBLIC110

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.

  • 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.

  • 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.

  • 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.

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

  • Metric and Alert/Event History

  • User-Defined Metrics and Metric Extensions

  • Management Connectors

  • Dynamic metric baselines and Adaptive metric thresholds

  • Monitoring Templates and Template Collections

  • Bottleneck detection and Component top wait event analysis

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

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.

  • From the Setup menu, select Management Pack Access.

  • 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:

    For Enterprise Manager Database Control, click the Remove Access option for the Diagnostics Pack and click Apply.

    For Enterprise Manager Cloud Control, 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

Oracle Diagnostics Pack is a prerequisite product to Oracle Tuning Pack. Therefore, to use Oracle Tuning Pack, you must also have 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.

  • Click Setup (top right-hand corner), then Management Pack Access.

  • 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:

    For Enterprise Manager Database Control, click the Remove Access option for the Tuning Pack and click Apply.

    For Enterprise Manager Cloud Control, 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:

  • Discovery and inventory tracking: the ability to discover your assets and track them.

  • Initial provisioning: the ability to rollout databases in minutes.

  • Ongoing change management: end-to-end management of patches, upgrades, schema and data changes.

  • Configuration management: track inventory, configuration drift, and detailed configuration search.

  • Compliance management: reporting and management of industry and regulatory compliance standards.

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:

  • Change Activity Plans provide the ability to plan, track in real time, and execute data-centerwide change activities. Activities include: PSU patch rollouts, database consolidation to Exadata, and so on.

  • 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 Database and Real Application Cluster (RAC).

  • Database Provisioning of Oracle Database and Real Application Cluster (RAC).

  • Fleet Maintenance - a bulk deployment of patches on all configuration types of Oracle Database with minimal downtime

  • Applicable only for individual & group of Grid Infrastructure, Database targets & Not DBaaS Pool(s). Subscription to an Image along with Self-service update functionality requires Cloud Management for Database.

  • Upgrade existing Oracle Database and/or Oracle Grid Infrastructure across major release versions (for example, 11.2.0.x to 12.1.0.1, also 11.2.0.x to other 11.2.0.x 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.

  • 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.

  • Disaster Recovery through Site Guard to automate complete site failover of Oracle Fusion Middleware and Oracle Database and extend to include other data center components.

    Note: Usage of Site Guard requires licenses for the Database Lifecycle Management Pack for the database tier and WebLogic Server Management Pack Enterprise Edition for the middleware tier. For host or pure VM environments, Site Guard is licensed via the Configuration Management Pack for Applications.

  • 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

Compliance and Configuration 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 checks on Engineered systems, such as Exadata-specific compliance standards created by integrating the Exachk healthcheck tool.

    Note: Use of Exachk/Orachk compliance standards for more than a single engineered system (for example, Exadata) or which have been customized requires license of Database Lifecycle Management Pack.

  • 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 relations 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.

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

  • Real-time configuration change detection provides real-time configuration change detection and automation of compliance frameworks along with automated observation authorization using a Change Management Connector.

Database Lifecycle Management Pack for Oracle Database

Compliance and Configuration Features (continued)

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

  • Exadata patching offers complete stack patching of Exadata Database Machines including Storage Servers, InfiniBand Switches, and Database Servers.

  • Ongoing provisioning of Exadata VMs.

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 database.

  • 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 (PDB) Features

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

  • Pluggable Database (PDB) Create/Plug/Unplug

    Create PDB from seed, plug PDB from unplugged PDB, and unplug PDB (multiple targets operations or performed using a customized deployment procedure).

  • PDB Clone to create a clone of an existing PDB.

  • PDB Migrate to migrate Non-Container Databases (CDB) database to a PDB.

Database Lifecycle Management Pack for Oracle Database

Rapid Home Provisioning Features

The Database Lifecycle Management Pack for Oracle Database includes the following Rapid Home Provisioning features:

  • Rapid Home Provisioning

    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 Cloud Control, deployment procedures and patch plans are used on the Rapid Home Provisioning server to:

  • Provision

  • Patch clusters or Oracle homes

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

Provisioning and Patching 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 on 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 Procedures

  • 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, 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.

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.

Database Lifecycle Management Pack for Oracle Database

Provisioning and Patching Licensed Links (Continued)

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.

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

Configuration 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 on 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 Instance 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 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 Database Lifecycle Management Pack.

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 Database Lifecycle Management Pack.

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 Database Lifecycle Management Pack.

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 Database Lifecycle Management Pack.

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 Database Lifecycle Management Pack.

Database Lifecycle Management Pack for Oracle Database

Configuration Licensed Links (Continued)

Configuration Topology

  • From the Oracle Database menu, select Configuration, then Topology. In the View drop-down, Used By is licensed as part of the Database Lifecycle Management Pack.

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

Change Activity Plans

  • From the Enterprise menu, select Configuration. The Change Activity Plans and My Tasks items are licensable 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 on 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 on 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.

Software Standardization Advisor

  • From the Administration menu, select Database. On the Database Maintenance page, all features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.

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.

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, Real-time Observations, and Results pages are licensed as part of the Database Lifecycle Management Pack.

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 go to the Enterprise Manager home page, click the Reports, Information Publisher Reports or BI Publisher Enterprise Reports.

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 BI Publisher Enterprise Reports 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
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
switch_database
switch_gridinfrastructure
db_software_maintenance
update_and_retry_step
update_procedure_input
upgrade_database

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

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

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 creation of production like data for non-production environments by replacing production data with fictitious yet realistic values. Generation of the fictitious data can be performed during export or on a separate staging server. The Subsetting functionality provides the ability to subset a database by deleting or extraction a portion of data. Subsetting can optionally be used in line with masking functionality.

Features

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

  • Application Data Modeling

  • Data Masking Formats Library

  • Data Masking Definitions

  • 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 SQLServer

  • 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 licensed pages and links for Oracle Data Masking and Subsetting Pack within Oracle Enterprise Manager.

Licensed Page/Link How to Access

Application Data Models

From the Enterprise Summary home page, click the Enterprise menu, then Quality Management , then Application Data Models.

From the Oracle database or cluster database target home page, click the Security menu, then Application Data Models.

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

Data Masking Definitions

From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Masking Definitions.

From the Oracle database or cluster database target home page, click the Security menu, then Data Masking Definitions.

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

Data Masking Formats

From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Masking Formats.

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

Data Subset Definitions

From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Subset Definitions.

From the Oracle database or cluster database target home page, click the Schema menu, then 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:

  1. 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.

  2. Application Data Modeling was previously called Data Discovery and Modeling.

Legacy: Configuration Management Pack for Oracle Database

Enterprise Manager Cloud Control 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 Cloud Control 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 on 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 Dropdown, 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 can be used with an existing license for the Configuration Management Pack for Oracle Database. The following reports and associated features apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management on 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, click the Reports, Information Publisher Reports or BI Publisher Enterprise Reports.

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 BI Publisher Enterprise Reports 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

Enterprise Manager Cloud Control 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 Cloud Control 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 on 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 Oracle Database reports in each of these sections are licensed for this pack. To access the reports go to the Enterprise Manager home page, click the Reports, Information Publisher Reports or BI Publisher Enterprise Reports.

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 BI Publisher Enterprise Reports 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

Enterprise Manager Cloud Control 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 Automations features in Enterprise Manager Cloud Control 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. The following 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, click the Reports, Information Publisher Reports or BI Publisher Enterprise Reports.

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 BI Publisher Enterprise Reports 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_inpu
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