2 Enterprise Database Management

Enterprise Manager offers the following management packs for Oracle Database:

Diagnostics Pack for Oracle Database
Tuning Pack for Oracle Database
Database Lifecycle Management Pack for Oracle Database
Oracle Data Masking Pack for Oracle and non-Oracle Databases
Oracle Test Data Management Pack for Oracle and non-Oracle Databases
Legacy: Configuration Management Pack for Oracle Database
Legacy: Change Management Pack for Oracle Database
Legacy: Provisioning and Patch Automation Pack for Oracle Database

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

The following sections in this chapter describe the licensed features for these packs.

Diagnostics Pack for Oracle Database

The Diagnostics Pack for Oracle Database provides unique functionality (such as automatic identification of performance bottlenecks, guided problem resolution, and comprehensive system monitoring) for managing the performance of Oracle Database environments. You can access the Diagnostics Pack functionality through Enterprise Manager licensed links.

Beginning with Oracle Database 11g, the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter controls access to the Diagnostic Pack and Tuning Pack. You can set this parameter to one of the following values:

DIAGNOSTIC+TUNING — Diagnostic Pack and Tuning Pack functionally is enabled in the database server.
DIAGNOSTIC — Only Diagnostic Pack functionality is enabled in the server.
NONE — Diagnostic Pack and Tuning Pack functionally is disabled in the database server.

Features

The Diagnostics Pack includes the following features, which you can use after purchasing a license for the pack.

Feature	Description
Adaptive metric thresholds	Capture "baselines" of workload performance metrics during "normal" performance and compares against the same metrics during poor performance to diagnose the causes. Set adaptive thresholds using a pre-defined baseline to accurately detect alert conditions when a system has predictably varying workloads.
Automatic Database Diagnostic Monitor (ADDM)	Automatic performance analysis based on AWR data.
Automatic Workload Repository (AWR)	Capture statistics automatically, including snapshot data, active session history data, and workload reports.
Blackouts	Suspend monitoring on targets to support scheduled maintenance periods.
Exadata Cell Grid Administration	Provides the following information: IORM settings Disk Objective Trends Average throttle time for Disk I/Os: All and individual Databases Disk utilization by all databases
Exadata Cell Grid Performance	Provides the following trending information: IOPS, throughput, Cell Disk I/O load All CPU, memory, and Network utilization Flash cache usage Provides average response time information for all hard disks and flash disks. Provides Workload Distribution information across all databases.
Exadata Cell Group Health Overview Page	Provides an integrated health overview from the Database Instance performance page. Provides historical trend information of availability, including: ASM Diskgroup health Cell health Network health Cell Configuration health
Exadata Resource Utilization	Provides the following Compute node resource information Database CPU utilization Database placement Cluster placement Provides the following Storage Server resource information: Database I/O utilization Disk group space allocation
Management Connectors	Helpdesk (ticketing) connectors open helpdesk tickets for incidents raised in Enterprise Manager. Event connectors share event information with other management systems.
Memory access mode	Retrieve performance statistics directly from the Shared Global Area (SGA).
Metric and Alert/Event History	View metric and alert/event history and its associated details.
Monitoring Templates and Template Collections	Monitoring Templates encapsulate target monitoring settings and can later be applied against many targets. Template Collections (with administration groups) automate the deployment of management settings on targets as they join the group.
Notifications	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.
Performance monitoring and diagnostics	Measure performance and diagnose performance issues.
User-Defined Metrics and Metric Extensions	Create new metrics to monitor conditions specific to customer environments.

Note:

Generation of alerts (through Enterprise Manager or directly by the server in Oracle Database 12c) is not part of this pack; it is free with the database.

Licensed Links

To determine which links are part of the Diagnostics Pack:

Click Setup (upper right corner of the page), then Management Pack Access.
On the Management Pack Access page, you can grant and remove access for all management packs.
- For Enterprise Manager Database Control, remove access for the Database Diagnostics Pack and click Apply.
- For Enterprise Manager Cloud Control, remove access for the Database Diagnostics Pack and click Apply.

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

Command-Line APIs

Access Diagnostic Pack features through the following database server APIs and command-line interfaces:

Database Server API or CLI Interface	Comment
DBMS_WORKLOAD_REPOSITORY
DBMS_ADDM
DBMS_ADVISOR	Specify ADDM as the value of the `advisor_name` parameter, or specify for the value of the `task_name` parameter any value starting with the ADDM prefix.
DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT
V$ACTIVE_SESSION_HISTORY	Also includes the underlying table `X$ASH`
DBA_STREAMS_TP_PATH_BOTTLENECK
DBA_ADDM_*
Data dictionary views beginning with `DBA_ADDM_`
DBA_STREAMS_TP_COMPONENT_STAT	This filter clause to any query on this API shows Diagnostic-Pack-dependent data: where STATISTIC_UNIT = 'PERCENT' For example, the following query shows Diagnostic-Pack-dependent data only: SELECT * FROM DBA_STREAMS_TP_COMPONENT_STAT where STATISTIC_UNIT = 'PERCENT';
Data dictionary views beginning with `DBA_HIST_`	Includes the underlying tables, except for these views that you can use without the Diagnostic Pack license: - DBA_HIST_SNAPSHOT - DBA_HIST_DATABASE_INSTANCE - DBA_HIST_SNAP_ERROR - DBA_HIST_SEG_STAT - DBA_HIST_SEG_STAT_OBJ - DBA_HIST_UNDOSTAT.
Data dictionary views with the prefix `DBA_ADVISOR_`	Only 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`

Licensed Reports

The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of this 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

Licensed Repository Views

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

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

Monitoring Views

MGMT$BLACKOUT_HISTORY
MGMT$BLACKOUTS
MGMT$ALERT_ANNOTATIONS
MGMT$ALERT_NOTIF_LOG
MGMT$TARGET_METRIC_COLLECTIONS
MGMT$METRIC_COLLECTIONS
MGMT$TARGET_METRIC_SETTINGS
MGMT$AVAILABILITY_CURRENT

MGMT$AVAILABILITY_HISTORY
MGMT$ALERT_CURRENT
MGMT$ALERT_HISTORY
MGMT$METRIC_DETAILS
MGMT$METRIC_CURRENT
MGMT$METRIC_HOURLY
MGMT$METRIC_DAILY

Template Views
MGMT$TEMPLATES MGMT$TEMPLATE_POLICY_SETTINGS MGMT$TEMPLATE_METRIC_COLLECTION MGMT$TEMPLATE_METRIC_SETTINGS

Tuning Pack for Oracle Database

The Tuning Pack for Oracle Database gives administrators the ability to automate the application tuning process. You can access the Tuning Pack functionality through Enterprise Manager licensed links.

Note:

The Tuning Pack for Oracle Database requires a Diagnostics Pack for Oracle Database license. Therefore, you must license both of these packs.

Beginning with Oracle Database 11g, the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter controls access to the Diagnostic Pack and Tuning Pack. You can set this parameter to one of the following values:

DIAGNOSTIC+TUNING — Diagnostic Pack and Tuning Pack functionally is enabled in the database server.
DIAGNOSTIC — Only Diagnostic Pack functionality is enabled in the server.
NONE — Diagnostic Pack and Tuning Pack functionally is disabled in the database server.

Features

The Tuning Pack includes the following features, which you can use after purchasing a license for the pack.

Feature	Definition
Automatic Plan Evolution of SQL Plan Management	Automatically evolves unaccepted execution plans when or if a better plan exists.
Real-time SQL Monitoring	Monitor execution of long-running or parallel SQL statements in real-time.
Reorganize objects	Reorganizes database space usage for objects or tablespaces to improve performance.
SQL Access Advisor	Recommends schema changes needed to improve database performance.
SQL Tuning Advisor	Analyze SQL statements and make recommendations for better execution. Includes an automatic mode to run during system maintenance windows as a maintenance task.
SQL Tuning Sets	A database object that captures and manages SQL workloads.

DIAGNOSTIC+TUNING — Diagnostic Pack and Tuning Pack functionally is enabled in the database server.
DIAGNOSTIC — Only Diagnostic Pack functionality is enabled in the server.
NONE — Diagnostic Pack and Tuning Pack functionally is disabled in the database server.

Licensed Links

To determine which links are part of the Tuning Pack:

Click Setup (upper right corner of the page), then Management Packs, and then Management Pack Access.
On the Management Pack Access page, you can grant and remove access for all the management packs.
- For Enterprise Manager Database Control, remove access for the Database Tuning Pack and click Apply.
- For Enterprise Manager Cloud Control, remove access for the Database Tuning Pack and click Apply.

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

Command-Line APIs

You can access Tuning Pack features through the following database server APIs and command-line interfaces:

Database Server API or CLI Interface	Comment
DBMS_SQLTUNE
DBMS_ADVISOR	When the value of the `advisor_name` parameter is either SQL Tuning Advisor or SQL Access Advisor.
V$SQL_MONITOR
V$SQL_PLAN_MONITOR

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

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

Features

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

Feature	Definition
Client system analyzer	Enable your system administrators to collect and analyze configuration information and data from end-user systems. Using the pre-installed application enables you to collect end-user configuration information without setting up a separate Web server. The Management Agents collect, analyze, and upload the end-user configuration information to the Management Repository.
Compliance	Compliance Frameworks, Standards and extensibility to meet industry and regulatory compliance requirements.
Configuration Collection Extensibility	Create custom configuration collections and extend current collections.
Configuration Compare	Compare configurations, one-to-one, one-to-many.
Configuration History	Report and notify on configuration or relations changes during a specific time frame.
Configuration Instance Browser	View Configuration Items and associations associated with a target.
Configuration Save	Save configurations for reference, baselines or Gold Standards.
Configuration Search	Search for Configuration Items on a specific target or across relationships.
Configuration Topology	View topology for a specified target and its dependencies along with other targets that are dependent on it.
Copy Objects	Copy database objects with data, with a subset of data, or without data.
Database Patching	End-to-end patch automation for Oracle Database and Real Application Cluster (RAC).
Database Provisioning	Provision Oracle Database and Real Application Cluster (RAC).
Database Upgrade	Upgrade existing Oracle Database.
Disaster Recovery via Site Guard	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 both WebLogic Server Management Pack Enterprise Edition as well as Database Lifecycle Management Pack.
File Synchronization	Synchronize configuration file differences during a comparison.
Notifications	Notification on configuration changes or differences.
RAC Scale Back	Delete or scale back a single instance database from RAC.
RAC Scale Out	Extend single instance databases to RAC.
Real-time configuration change detection	Provide real-time configuration change detection and automation of compliance frameworks along with automated observation authorization using a Change Management Connector.
Real-time schema change detection	Track schema changes in real time to identify unwanted or unplanned changes.
Schema and Data Comparisons	Automate the comparison of database schema and data across Databases or saved baselines.
Schema and Data Synchronization	Propagate database objects and schemas with or without data, and update database object definitions.
Schema Change Plans	Allows developers to add changes to the schema in a plan that can be applied to multiple database.
Schema Comparisons	Compare database objects in two databases or baselines in Enterprise Manager or SQL developer.

Licensed Parameters

The init.ora parameter ENABLE_DDL_LOGGING is licensed as part of the 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.

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:

Licensed Page/Link	How to Access
Database Provisioning Procedures	From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that Clone and Provision a Database are licensed with the Database Lifecycle Management Pack. From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. 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 Database Lifecycle Management Pack.
Database Upgrade	From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that Upgrade a Database are licensed with the Database Lifecycle Management Pack. 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 Database Lifecycle Management Pack.
RAC Scale Out and Scale Back	From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Procedure Library. All Procedures that Extend or Scale a database or RAC are licensed with the Database Lifecycle Management Pack. From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching, then Database Provisioning. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. 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 Database Lifecycle Management Pack.
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 Database Lifecycle Management Pack.
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 Database Lifecycle Management Pack.
Configuration Instance Browser	From the Enterprise Manager home page, click on Targets, Databases, and select a Database. From the database home page, click on Oracle Database, Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Oracle Database, 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 Manager home page, click the Enterprise menu, then 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 Manager home page, click the Enterprise menu, then 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 Manager home page, click the Enterprise menu, then 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 Manager home page, click the Enterprise menu, then 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 Topology	From the Target Home Page, click on Oracle Database, Configuration, Topology. In the View Dropdown, Used By is licensed as part of the Database Lifecycle Management Pack. From the Target Home Page, click on Oracle Database, Configuration, Topology, Customization. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the Target Home Page, click on Oracle Database, Configuration, Topology. In the View drop-down, Used By is licensed as part of the Database Lifecycle Management Pack. From the Target Home Page, click on Oracle Database, Configuration, Topology, Customization. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack
Configuration Collection Extensibility	From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Custom. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.
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.
Schema Comparison	From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Schema, 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 Comparisons	From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Schema, 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 Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Schema, 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 Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.
Real-Time Schema Change Detection	From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.
Compliance	From the Enterprise Manager home page, click the Enterprise menu and 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.
Real-time Configuration Change Detection	From the Enterprise Manager home page, click the Enterprise menu and Compliance. All features, functions, links, buttons, and drill-downs associated Library, Results and Real-Time Observations pages are licensed as part of the Database Lifecycle Management Pack.

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

Additional Licensed Features

With the purchase of the Database Lifecycle 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.

Licensed Feature	Description
Application Configuration Console	Provides IT infrastructure teams with an automated “gold master” approach to application 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.
The oplan Utility	A tool that operates with OPatch to provide advanced capability for patching Oracle software. If oplan is utilized in any non-Oracle application, tool, or procedure a Database Lifecycle Management Pack License must be purchased for all CPUs the tool, application, or procedure is being applied to.
Migrate to ASM	From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Administration, Migrate to ASM. All features, functions, links, buttons and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Administration, Migrate to ASM. All features, functions, links, buttons and drill-downs on this page are licensed as part of the Database Lifecycle Management Pack.
Self Update	From the Enterprise Manager home page, click the Setup menu, Extensibility, and then Self Update. The downloading and applying any updates associated with Patching, Provisioning, and Compliance are licensed as part of the Database Lifecycle Management Pack.

Licensed Command Line Interface Verbs

The following Enterprise Manager Command Line Interface (CLI) verbs are licensed as part of the Database Lifecycle Management Pack:

confirm_instance
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
create_database
clone_database
upgrade_database

Licensed Parameters

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

Licensed Repository Views

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

Compliance Views
MGMT$COMPLIANCE_STANDARD_RULE MGMT$COMPLIANCE_STANDARD MGMT$COMPLIANCE_STANDARD_GROUP MGMT$CS_EVAL_SUMMARY 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_FEATURE_USAGE MGMT$CS_HA_INFO MGMT$CS_GROUP_EVAL_SUMMARY MGMT$CS_RULE_EVAL_SUMMARY MGMT$CS_TARGET_ASSOC MGMT$CCC_ALL_OBSERVATIONS MGMT$CCC_ALL_OBS_BUNDLES MGMT$CCC_DIAG_ANALYTICS MGMT$CCC_DIAG_QUEUEBACKLOG

Compliance Views

MGMT$COMPLIANCE_STANDARD_RULE
MGMT$COMPLIANCE_STANDARD
MGMT$COMPLIANCE_STANDARD_GROUP
MGMT$CS_EVAL_SUMMARY
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_FEATURE_USAGE
MGMT$CS_HA_INFO
MGMT$CS_GROUP_EVAL_SUMMARY
MGMT$CS_RULE_EVAL_SUMMARY
MGMT$CS_TARGET_ASSOC
MGMT$CCC_ALL_OBSERVATIONS
MGMT$CCC_ALL_OBS_BUNDLES
MGMT$CCC_DIAG_ANALYTICS
MGMT$CCC_DIAG_QUEUEBACKLOG

Provisioning Views	Patch Recommendation
EM$PROV_APPTYPES EM$PROVAPP_METADATA_VERSION EM$PROVAPP_METADATA EM$PROVAPP_TAGS EM$PROVAPP_TAG_PROPERTIES	MGMT$PA_RECOM_METRIC_SOURCE

Patching Views
MGMT$ARU_PRODUCTS MGMT$ARU_PLATFORMS MGMT$ARU_RELEASES MGMT$ARU_TARGETS MGMT$ARU_LANGUAGES MGMT$ARU_PRODUCT_RELEASE_MAP MGMT$ARU_FAMILY_PRODUCT_MAP MGMT$ARU_PATCH_RECOMMENDATIONS MGMT$PR_APPL_PATCHES_TO_OH_TGT MGMT$PR_HOMES_AFFECTED_COUNT MGMT$PA_TARGET_MAPPING GC_PC_PLAN_ANALYSIS_RS gc_pc_plan_remedy gc_pc_plan_remedy_details gc_pc_plan_users	MGMT$PA_FINAL_PATCH_LIST mgmt$pa_target_mapping MGMT$RECOM_METRIC_SOURCE gc_pc_targets GC_PC_EXECUTION_INSTANCES MGMT$PA_AFFTED_TARGETS MGMT$PA_AFFTED_HOST_OH MGMT$PA_AFFTED_HOST_GUID_OH MGMT$PR_APPL_PATCHES_TO_OH MGMT$PR_HOME_INFO MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS GC$EM_PC_PLANS GC$EM_PC_PLAN_PATCHES GC$EM_PC_PLAN_TARGETS

Patching Views

MGMT$ARU_PRODUCTS
MGMT$ARU_PLATFORMS
MGMT$ARU_RELEASES
MGMT$ARU_TARGETS
MGMT$ARU_LANGUAGES
MGMT$ARU_PRODUCT_RELEASE_MAP
MGMT$ARU_FAMILY_PRODUCT_MAP
MGMT$ARU_PATCH_RECOMMENDATIONS
MGMT$PR_APPL_PATCHES_TO_OH_TGT
MGMT$PR_HOMES_AFFECTED_COUNT
MGMT$PA_TARGET_MAPPING
GC_PC_PLAN_ANALYSIS_RS
gc_pc_plan_remedy
gc_pc_plan_remedy_details
gc_pc_plan_users

MGMT$PA_FINAL_PATCH_LIST
mgmt$pa_target_mapping
MGMT$RECOM_METRIC_SOURCE
gc_pc_targets
GC_PC_EXECUTION_INSTANCES
MGMT$PA_AFFTED_TARGETS
MGMT$PA_AFFTED_HOST_OH
MGMT$PA_AFFTED_HOST_GUID_OH
MGMT$PR_APPL_PATCHES_TO_OH
MGMT$PR_HOME_INFO
MGMT$APPLIED_PATCHES
MGMT$APPLIED_PATCHSETS
GC$EM_PC_PLANS
GC$EM_PC_PLAN_PATCHES
GC$EM_PC_PLAN_TARGETS

Configuration Views
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_CURRENT_SNAPSHOTS MGMT$ECM_VISIBLE_SNAPSHOTS MGMT$SERVICETAG_INSTANCES MGMT$SERVICETAG_REGISTRY MGMT$UNPATCHABLE_DB_TARGETS

Configuration Views

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_CURRENT_SNAPSHOTS
MGMT$ECM_VISIBLE_SNAPSHOTS
MGMT$SERVICETAG_INSTANCES
MGMT$SERVICETAG_REGISTRY
MGMT$UNPATCHABLE_DB_TARGETS

Oracle Home Patching Views
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$CPF_ADVISORY_INFO MGMT$CPF_HOMES_INFO MGMT$CPF_PATCH_INFO MGMT$EM_HOMES_PLATFORM MGMT$HOMES_AFFECTED MGMT$PATCH_ADVISORIES MGMT$APPL_PATCH_AND_PATCHSET MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS

Oracle Home Patching Views

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$CPF_ADVISORY_INFO
MGMT$CPF_HOMES_INFO
MGMT$CPF_PATCH_INFO
MGMT$EM_HOMES_PLATFORM
MGMT$HOMES_AFFECTED
MGMT$PATCH_ADVISORIES
MGMT$APPL_PATCH_AND_PATCHSET
MGMT$APPLIED_PATCHES
MGMT$APPLIED_PATCHSETS

Security Views
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

Security Views

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

Client Configuration Views
MGMT$CSA_COLLECTIONS MGMT$CSA_FAILED MGMT$CSA_HOST_OS_COMPONENTS MGMT$CSA_HOST_SW MGMT$CSA_HOST_COOKIES MGMT$CSA_HOST_CUSTOM MGMT$CSA_HOST_RULES	MGMT$CSA_HOST_CPUS MGMT$CSA_HOST_IOCARDS MGMT$CSA_HOST_NICS MGMT$CSA_HOST_OS_PROPERTIES MGMT$CSA_HOST_OS_FILESYSEMS MGMT$ECM_CONFIG_HISTORY

Client Configuration Views

MGMT$CSA_COLLECTIONS
MGMT$CSA_FAILED
MGMT$CSA_HOST_OS_COMPONENTS
MGMT$CSA_HOST_SW
MGMT$CSA_HOST_COOKIES
MGMT$CSA_HOST_CUSTOM
MGMT$CSA_HOST_RULES

MGMT$CSA_HOST_CPUS
MGMT$CSA_HOST_IOCARDS
MGMT$CSA_HOST_NICS
MGMT$CSA_HOST_OS_PROPERTIES
MGMT$CSA_HOST_OS_FILESYSEMS
MGMT$ECM_CONFIG_HISTORY

Oracle Data Masking Pack for Oracle and non-Oracle Databases

The Oracle Data Masking Pack for Oracle and non-Oracle Databases offers the ability to mask regulated or confidential data on test or development systems.

Note:

The Oracle Data Masking Pack must be licensed for database servers from which the sensitive data originates, as well as database servers where the sensitive data is masked.

Features

The Oracle Data Masking Pack includes the following features you can use after purchasing a license for the pack.

Feature	Definition
Application Accelerators	This feature covers application templates needed to support Data Discovery and modeling and Data Masking. The Application Accelerators support the following applications: E-Business Suite Fusion Applications Fusion Applications Templates for Masking
Data Discovery and Modeling	Discover and design application data models that serve as a knowledge base for creating Data Masking and Data Subsetting definitions.
Data Masking	Mask regulated or confidential data on test and development systems.
Export or import format libraries	Provide a ready-to-use definition for common sensitive data that database administrators can reference when specifying a mask definition.
Sensitive Column Types and Sensitive Data Discovery	Allows the specifications of search patterns for various types of sensitive data and discovery of sensitive columns based on running the search on the database.

Licensed Links

The list that follows itemizes the links that require licensing of the Oracle Data Masking Pack for Oracle and non-Oracle Databases.

Licensed Page/Link	How to Access
Masking Definition page	From the Enterprise Summary home page, click the Targets menu, then Databases. Select a database name to display the Database Instance home page. Click the Schema menu, then Definitions in the Data Masking section. All links, buttons, and drilldowns on this page are licensed
Format Library page	From the Enterprise Summary home page, click the Targets menu, then Databases. Select a database name to display the Database Instance home page. Click the Schema menu, then Format Library in the Data Masking section. All links, buttons, and drilldowns on this page are licensed
Data Discovery and Modeling	From the Enterprise Summary home page, click the Grid menu, then Quality Management.
Data Masking	From the Enterprise Summary home page, click the Grid menu, then Quality Management.
Data Masking formats	From the Enterprise Summary home page, click the Grid menu, then Quality Management.

Licensed Command Line Interface (CLI) Verbs

The following Enterprise Manager CLI verbs are licensed as part of the Oracle Secure Test Data Management Pack for Oracle Database.

export_masking_definition
generate_masking_script
import_masking_definition
list_masking_definitions

reassoc_masking_definition
save_masking_script
submit_masking_job

Oracle Test Data Management Pack for Oracle and non-Oracle Databases

The Oracle Test Data Management Pack for Oracle and non-Oracle Databases offers the ability to shrink production data into a smaller size database for the purpose s of application development or testing based on rules.

Note:

The Oracle Test Data Management Pack must be licensed for database servers from which the production data originates, as well as database servers where the production data is reduced.

Features

The Oracle Test Data Management Pack includes the following features you can use after purchasing a license for the pack.

Feature	Definition
Application Accelerators	This feature covers application templates needed to support Data Discovery and modeling and Data Subsetting. The Application Accelerators support the following applications: E-Business Suite Fusion Applications
Data Discovery and Modeling	Discover and design application data models that serve as a knowledge base for creating Data Masking and Data Subsetting definitions.
Data Subset Definitions	Defines the rules for the subset operation and executes the subset job on the database to reduce its size.

Licensed Links

The list that follows itemizes the links that require licensing of the Oracle Test Data Management Pack for Oracle and non-Oracle Databases:

Licensed Page/Link	How to Access
Data Discovery and Modeling	From the Enterprise Summary home page, click the Grid menu, then Quality Management.
Data Subset Definitions	From the Enterprise Summary home page, click the Grid menu, then Quality Management.

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 utilize the following Configuration Management features in Enterprise Manager Cloud Control.

Features

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

Feature	Definition
Compliance	Compliance Frameworks, Standards and extensibility to meet industry and regulatory compliance requirements.
Configuration Collection Extensibility	Create custom configuration collections and extend current collections.
Configuration Compare	Compare configurations, one-to-one, one-to-many, file sync.
Configuration History	Report on configuration or relations changes during a specific time frame.
Configuration Instance Browser	View Configuration Items and associations associated with a target.
Configuration Save	Save configurations for reference, baselines or Gold Standards.
Configuration Search	Search for Configuration Items on a specific target or across relationships.
Configuration Topology	View topology for a specified target and its dependencies along with other targets that are dependent on it.
Exadata Database Machine Configuration	Provide 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	Synchronize configuration file differences during a comparison.
Real-time configuration change detection	Provide real-time configuration change detection and automation of compliance frameworks.

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:

Licensed Page/Link	How to Access
Configuration Instance Browser	From the Enterprise Manager home page, click on Targets, Databases, and select a Database. From the database home page, click on 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. If the Target Home Page is accessed directly or by other paths: From the database home page, click on 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 Manager home page, click the Enterprise menu, then 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 Manager home page, click the Enterprise menu, then 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 Manager home page, click the Enterprise menu, then 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.
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 Manager home page, click the Enterprise menu, then 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 Topology	From the Target Home Page, click on 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 on 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. If the Target Home Page is accessed directly or by other paths: From the Target Home Page, click on 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 on 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 Collection Extensibility	From the Enterprise Manager home page, click the Enterprise menu, then 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.
Compliance	From the Enterprise Manager home page, click the Enterprise menu and 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.
Real-time Configuration Change Detection	From the Enterprise Manager home page, click the Enterprise menu and 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.

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

Additional Licensed Features

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.

Licensed Feature	Description
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	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.

Licensed Repository Views

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

Configuration Views
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 Views

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

Compliance Views
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 MGMT$COMPLIANCE_STANDARD_RULE MGMT$COMPLIANCE_STANDARD MGMT$COMPLIANCE_STANDARD_GROUP MGMT$CS_EVAL_SUMMARY MGMT$COMPOSITE_CS_EVAL_SUMMARY MGMT$CS_RULE_EVAL_SUMMARY MGMT$CS_GROUP_EVAL_SUMMARY MGMT$CS_TARGET_ASSOC MGMT$CCC_ALL_OBSERVATIONS MGMT$CCC_ALL_OBS_BUNDLES MGMT$CCC_DIAG_ANALYTICS MGMT$CCC_DIAG_QUEUEBACKLOG

Compliance Views

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
MGMT$COMPLIANCE_STANDARD_RULE
MGMT$COMPLIANCE_STANDARD
MGMT$COMPLIANCE_STANDARD_GROUP
MGMT$CS_EVAL_SUMMARY
MGMT$COMPOSITE_CS_EVAL_SUMMARY
MGMT$CS_RULE_EVAL_SUMMARY
MGMT$CS_GROUP_EVAL_SUMMARY
MGMT$CS_TARGET_ASSOC
MGMT$CCC_ALL_OBSERVATIONS
MGMT$CCC_ALL_OBS_BUNDLES
MGMT$CCC_DIAG_ANALYTICS
MGMT$CCC_DIAG_QUEUEBACKLOG

Oracle Home Patching Views
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$CPF_ADVISORY_INFO MGMT$CPF_HOMES_INFO MGMT$CPF_PATCH_INFO MGMT$EM_HOMES_PLATFORM MGMT$HOMES_AFFECTED MGMT$PATCH_ADVISORIES MGMT$APPL_PATCH_AND_PATCHSET MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS

Oracle Home Patching Views

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$CPF_ADVISORY_INFO
MGMT$CPF_HOMES_INFO
MGMT$CPF_PATCH_INFO
MGMT$EM_HOMES_PLATFORM
MGMT$HOMES_AFFECTED MGMT$PATCH_ADVISORIES
MGMT$APPL_PATCH_AND_PATCHSET
MGMT$APPLIED_PATCHES
MGMT$APPLIED_PATCHSETS

Security Views
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

Security Views

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

Client Configuration Views
MGMT$CSA_COLLECTIONS MGMT$CSA_FAILED MGMT$CSA_HOST_OS_COMPONENTS MGMT$CSA_HOST_SW MGMT$CSA_HOST_COOKIES MGMT$CSA_HOST_CUSTOM MGMT$CSA_HOST_RULES MGMT$CSA_HOST_CPUS MGMT$CSA_HOST_IOCARDS MGMT$CSA_HOST_NICS MGMT$CSA_HOST_OS_PROPERTIES MGMT$CSA_HOST_OS_FILESYSEMS 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_COMP_PATCHSET MGMT$SOFTWARE_COMPONENT_ONEOFF MGMT$SOFTWARE_COMPONENTS MGMT$SOFTWARE_DEPENDENCIES MGMT$SOFTWARE_HOMES MGMT$SOFTWARE_ONEOFF_PATCHES MGMT$SOFTWARE_OTHERS MGMT$SOFTWARE_PATCHES_IN_HOMES MGMT$SOFTWARE_PATCHSETS

Client Configuration Views

MGMT$CSA_COLLECTIONS
MGMT$CSA_FAILED
MGMT$CSA_HOST_OS_COMPONENTS
MGMT$CSA_HOST_SW
MGMT$CSA_HOST_COOKIES
MGMT$CSA_HOST_CUSTOM
MGMT$CSA_HOST_RULES
MGMT$CSA_HOST_CPUS
MGMT$CSA_HOST_IOCARDS
MGMT$CSA_HOST_NICS
MGMT$CSA_HOST_OS_PROPERTIES
MGMT$CSA_HOST_OS_FILESYSEMS
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_COMP_PATCHSET
MGMT$SOFTWARE_COMPONENT_ONEOFF
MGMT$SOFTWARE_COMPONENTS
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 utilize the following Change Management features in Enterprise Manager Cloud Control.

Features

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

Feature	Description
Schema Comparisons	Compare database objects in two databases or baselines in Enterprise Manager or SQL developer.
Schema and Data Comparisons	Automate the comparison of database schema and data across Databases or saved baselines.
Schema and Data Synchronization	Propagate database objects and schemas with or without data, and update database object definitions.
Copy Objects	Copy database objects with data, with a subset of data, or without data.
Real-time schema change detection	Track schema changes in real time to identify unwanted or unplanned changes.

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 setting is FALSE.

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:

Licensed Page/Link	How to Access
Schema Comparison	From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on 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. If the Target Home Page is accessed directly or by other paths: From the database home page, click on 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 Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on 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. If the Target Home Page is accessed directly or by other paths: From the database home page, click on 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 Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on 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. If the Target Home Page is accessed directly or by other paths: From the database home page, click on 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 Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on 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. If the Target Home Page is accessed directly or by other paths: From the database home page, click on 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 Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on 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. If the Target Home Page is accessed directly or by other paths: From the database home page, click on 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.

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

Additional Licensed Features

With the previous purchase of the Change 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.

Licensed Feature	Description
Self Update	From the Enterprise Manager home page, click the Setup menu, then 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.

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 utilize the following Provisioning and Patch Automations features in Enterprise Manager Cloud Control.

Features

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

Feature	Description
Database Patching	End-to-end patch automation for Oracle Database and RAC.
Database Provisioning	Provision databases and Oracle Homes.
Database Upgrade	Upgrade existing Oracle Database.
Patch Recommendation	My Oracle Support Critical Patch Recommendations.
Patching Planning	My Oracle Support Patching Plans, patch Validation and Download.
Provisioning Procedures	Deploy operating system and Oracle Database and Real Application Clusters.
RAC Scale Out and Scale Back	Extend single instance databases to RAC.

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:

Licensed Page/Link	How to Access
Provisioning Procedures	From the Enterprise Manager home page, click the Enterprise menu, 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 Manager home page, click the Enterprise menu, 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 Manager home page, click the Enterprise menu, 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 Manager home page, click the Enterprise menu, 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 Provisioning and Cloning	From the Enterprise Manager home page, click the Enterprise menu, 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 Manager home page, click the Enterprise menu, 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 Manager home page, click the Enterprise menu, 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 Manager home page, click the Enterprise menu, 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.

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

Additional Licensed Features

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.

Licensed Feature	Description
The oplan Utility	A tool that operates with Opatch to provide advanced capability for patching Oracle software. If oplan is used in any non-Oracle application, tool, or procedure, a Provisioning and Patch Automation Pack for Oracle Database must be purchased for all CPUs the tool, application or procedure is being applied to.
Migrate to ASM	From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Administration, Migrate to ASM. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database. If the Target Home Page is accessed directly or by other paths: From the database home page, click on Administration, Migrate to ASM. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.
Self Update	From the Enterprise Manager home page, click the Setup menu, then Extensibility and Self Update. The downloading and applying any updates associated with Patching, Provisioning, Cloning, and Upgrade are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

Licensed Feature

Description

The oplan Utility

A tool that operates with Opatch to provide advanced capability for patching Oracle software. If oplan is used in any non-Oracle application, tool, or procedure, a Provisioning and Patch Automation Pack for Oracle Database must be purchased for all CPUs the tool, application or procedure is being applied to.

Migrate to ASM

From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on Administration, Migrate to ASM. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

If the Target Home Page is accessed directly or by other paths:

From the database home page, click on Administration, Migrate to ASM. All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

Self Update

From the Enterprise Manager home page, click the Setup menu, then Extensibility and Self Update. The downloading and applying any updates associated with Patching, Provisioning, Cloning, and Upgrade are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.

Licensed Command Line Interface Verbs

The following Enterprise Manager Command Line Interface (CLI) verbs are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:

confirm_instance
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
create_database
clone_database
upgrade_database

Licensed Repository Views

The following repository views are licensed as part a previously purchased Provisioning and Patch Automation Pack for Oracle Database license:

Provisioning Views	Patch Recommendation
EM$PROV_APPTYPES EM$PROVAPP_METADATA_VERSION EM$PROVAPP_METADATA EM$PROVAPP_TAGS EM$PROVAPP_TAG_PROPERTIES	MGMT$PA_RECOM_METRIC_SOURCE

Oracle Home Patching Views
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$CPF_ADVISORY_INFO MGMT$CPF_HOMES_INFO MGMT$CPF_PATCH_INFO MGMT$EM_HOMES_PLATFORM MGMT$HOMES_AFFECTED MGMT$PATCH_ADVISORIES MGMT$APPL_PATCH_AND_PATCHSET MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS

Oracle Home Patching Views

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$CPF_ADVISORY_INFO
MGMT$CPF_HOMES_INFO
MGMT$CPF_PATCH_INFO
MGMT$EM_HOMES_PLATFORM
MGMT$HOMES_AFFECTED
MGMT$PATCH_ADVISORIES
MGMT$APPL_PATCH_AND_PATCHSET
MGMT$APPLIED_PATCHES
MGMT$APPLIED_PATCHSETS

Patching Views
MGMT$ARU_PRODUCTS MGMT$ARU_PLATFORMS MGMT$ARU_RELEASES MGMT$ARU_TARGETS MGMT$ARU_LANGUAGES MGMT$ARU_PRODUCT_RELEASE_MAP MGMT$ARU_FAMILY_PRODUCT_MAP MGMT$ARU_PATCH_RECOMMENDATIONS MGMT$PR_APPL_PATCHES_TO_OH_TGT MGMT$PR_HOMES_AFFECTED_COUNT MGMT$PA_TARGET_MAPPING GC_PC_PLAN_ANALYSIS_RS gc_pc_plan_remedy gc_pc_plan_remedy_details gc_pc_plan_users	MGMT$PA_FINAL_PATCH_LIST mgmt$pa_target_mapping MGMT$RECOM_METRIC_SOURCE gc_pc_targets GC_PC_EXECUTION_INSTANCES MGMT$PA_AFFTED_TARGETS MGMT$PA_AFFTED_HOST_OH MGMT$PA_AFFTED_HOST_GUID_OH MGMT$PR_APPL_PATCHES_TO_OH MGMT$PR_HOME_INFO MGMT$APPLIED_PATCHES MGMT$APPLIED_PATCHSETS GC$EM_PC_PLANS GC$EM_PC_PLAN_PATCHES GC$EM_PC_PLAN_TARGETS

Patching Views

MGMT$ARU_PRODUCTS
MGMT$ARU_PLATFORMS
MGMT$ARU_RELEASES
MGMT$ARU_TARGETS
MGMT$ARU_LANGUAGES
MGMT$ARU_PRODUCT_RELEASE_MAP
MGMT$ARU_FAMILY_PRODUCT_MAP
MGMT$ARU_PATCH_RECOMMENDATIONS
MGMT$PR_APPL_PATCHES_TO_OH_TGT
MGMT$PR_HOMES_AFFECTED_COUNT
MGMT$PA_TARGET_MAPPING
GC_PC_PLAN_ANALYSIS_RS
gc_pc_plan_remedy
gc_pc_plan_remedy_details
gc_pc_plan_users

MGMT$PA_FINAL_PATCH_LIST
mgmt$pa_target_mapping
MGMT$RECOM_METRIC_SOURCE
gc_pc_targets 
GC_PC_EXECUTION_INSTANCES
MGMT$PA_AFFTED_TARGETS
MGMT$PA_AFFTED_HOST_OH
MGMT$PA_AFFTED_HOST_GUID_OH
MGMT$PR_APPL_PATCHES_TO_OH
MGMT$PR_HOME_INFO
MGMT$APPLIED_PATCHES
MGMT$APPLIED_PATCHSETS
GC$EM_PC_PLANS
GC$EM_PC_PLAN_PATCHES
GC$EM_PC_PLAN_TARGETS