This chapter describes the management packs offered by Enterprise Manager in support of Oracle Database. The following management packs are included:
Oracle Data Masking and Subsetting Pack for Oracle and Non-Oracle Databases
Legacy: Provisioning and Patch Automation Pack for Oracle Database
Legacy: Oracle Data Masking Pack for Oracle and Non-Oracle Databases
Legacy: Oracle Test Data Management Pack for Oracle and Non-Oracle Databases
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 12c 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
The Oracle Diagnostics Pack provides automatic performance diagnostic and advanced system monitoring functionality. The following sections describe this management pack offered by Enterprise Manager:
The Oracle Diagnostics Pack includes the following features:
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 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 Diagnostics Pack functionality, whether through Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data, requires an Oracle Diagnostics Pack license.
To determine which links in Enterprise Manager are part of Oracle Diagnostics Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.
When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.
This will take you to the Management Pack Access page, which enables you to grant and remove access from all the management packs.
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.
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.
Oracle Diagnostic Pack features can also be accessed by way of the following database server APIs and command-line interfaces:
The DBMS_WORKLOAD_REPOSITORY package is part of this pack.
The DBMS_ADDM package is part of this pack.
The DBMS_ADVISOR package is part of this 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.
The DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT function is part of this pack.
The V$ACTIVE_SESSION_HISTORY dynamic performance view and its underlying table, X$ASH, are part of this pack.
The DBA_STREAMS_TP_PATH_BOTTLENECK view is part of this pack.
All views beginning with DBA_ADDM_ are part of this pack.
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';
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 or with the Standard Edition license.
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.
The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of the Oracle Diagnostic 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 |
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 provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. Oracle Diagnostics Pack is a prerequisite product to Oracle Tuning Pack. Therefore, to use Oracle Tuning Pack, you must also have Oracle Diagnostics Pack.
The following sections describe this management pack offered by Enterprise Manager:
Oracle Tuning Pack includes the following features:
In order to use the features listed above, you must purchase licenses for Oracle Tuning Pack, with two exceptions:
SQL Tuning Sets can be used if you have licensed either Oracle Tuning Pack or Oracle Real Application Testing.
Use of In-Memory Advisor for databases where Database In-Memory option has not yet been deployed does NOT require Oracle Tuning Pack license.
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, requires an Oracle Tuning Pack license.
To determine which links in Enterprise Manager are part of Oracle Tuning Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.
When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.
This will take you to the Management Pack Access page, which enables you to grant and remove access from all the management packs.
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.
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.
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.
DBMS_SQLTUNE
V$SQL_MONITOR
V$SQL_PLAN_MONITOR
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 Oracle Cloud Management Pack for Oracle Database. The following sections describe this management pack offered by Enterprise Manager:
Oracle Database Lifecycle Management Pack Licensed Parameters
Accessing Oracle Database Lifecycle Management Pack Licensed Links
Oracle Database Lifecycle Management Pack Licensed CLI Verbs
Oracle Database Lifecycle Management Pack Licensed Repository Views
The Database Lifecycle Management Pack for Oracle Database includes the following features, which you can use after purchasing a license:
| Feature | Definition |
|---|---|
| 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. |
| 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). |
| Enterprise Data Governance | 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. |
| Upgrade existing Oracle Database and/or Oracle Grid Infrastructure | Supports upgrade of databases 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. |
| Disaster Recovery through 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 either WebLogic Server Management Pack Enterprise Edition or 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. |
| 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.
See Feature Notes: Rapid Home Provisioning below for additional information. |
| 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. |
| Software Standardization Advisor | Recommends software configurations to become standardized. This feature helps to reduce the proliferation of the software variances based on patch levels across your existing Database fleet. |
| User Defined Deployment Procedures (UDDP) | Automate custom processes by creating a procedure from scratch by inserting the required phases, steps, and variables. |
| 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 | Create a clone of an existing PDB. |
| PDB Migrate | Migrate Non-Container Databases (CDB) database to a PDB. |
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
With the purchase of the Database Lifecycle Management Pack for Oracle Database, you also are entitled to the features listed 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.
Application Configuration Console
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 Database Lifecycle Management Pack for Oracle Database.)
Migrate to ASM
Self Update
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.
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. From the Oracle Container Database home page, click the Oracle Database menu, then 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 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 (includes Primary and Standby Databases), 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. |
| User Defined Deployment Procedures (UDDP) | From the Enterprise Manager home page, click the Enterprise menu, 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 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 Targets, 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 Database Lifecycle Management Pack.
If the Target Home Page is accessed directly or by other paths: 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 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 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 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:
|
| 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. |
| Change Activity Plans | From the Enterprise Manager home page, click the Enterprise menu, then Configuration. The Change Activity Plans and My Tasks items are licensable 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 Targets, 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 Database Lifecycle Management Pack.
If the Target Home Page is accessed directly or by other paths: 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 Database Lifecycle Management Pack. |
| Schema and Data Comparisons | From the Enterprise Manager home page, click Targets, 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 Database Lifecycle Management Pack.
If the Target Home Page is accessed directly or by other paths: 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 Database Lifecycle Management Pack. |
| Schema and Data Synchronization | From the Enterprise Manager home page, click Targets, 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 Database Lifecycle Management Pack.
If the Target Home Page is accessed directly or by other paths: 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 Database Lifecycle Management Pack. |
| Software Standardization Advisor | On the Enterprise Manager home page, click the Targets menu and select Databases (represents all Databases monitored within your Enterprise Manager environment). From the database home page, click the Maintenance menu and 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. |
| Copy Objects | From the Enterprise Manager home page, click Targets, 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 Database Lifecycle Management Pack.
If the Target Home Page is accessed directly or by other paths: 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 Database Lifecycle Management Pack. |
| Real-Time Schema Change Detection | From the Targets menu on the Enterprise Manager home page, select Databases. On the Databases page select a database from the Search List view or Database Load Map view. On the Database home page, select Administration, then 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 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. |
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
The following Enterprise Manager command line interface (CLI) verbs are licensed as part of the Database Lifecycle Management Pack:
associate_cs_targets config_compare config_db_service_target configure_log_archive_locations confirm_instance clone_database create_database create_dbprofile 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 update_and_retry_step update_procedure_input upgrade_database |
The following repository views are part of the Database Lifecycle Management Pack for Oracle Database:
| Compliance Views | |
|---|---|
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 |
| 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 |
| 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 |
| Oracle Home Patching Views | |
|---|---|
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 |
| 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_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 |
The 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 mask a portion of the original data. Subsetting can also be used without masking to extract a portion of the original data.
Oracle Data Masking and Subsetting Pack includes the following components and features:
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
The Oracle Data Masking and Subsetting Pack for non-Oracle Databases includes the following restricted use licenses:
Database Gateway for APPC
Database Gateway for DRDA
Database Gateway for Informix
Database Gateway for SQL Server
Database Gateway for Sybase
Database Gateway for Teradata
If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using the 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, that is, the databases from which the data originates.
The staging database server on which masking and subsetting operations are executed.
The following are the licensed pages and links for the Oracle Data Masking and Subsetting Pack within Oracle Enterprise Manager:
| Licensed Page/Link | How to Access |
|---|---|
| Application Data Modeling | On the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Application Data Modeling.
From the Oracle database or cluster database target home page, click the Security menu, then Application Data Modeling. 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 | On 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. However, the Clone and Mask option requires a Database Lifecycle Management Pack for Oracle Database license. |
| Data Masking Formats | On the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Masking Formats.
From the Oracle database or cluster database target home page, click the Security menu, 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 Subsetting Definitions | On the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Subsetting Definitions.
From the Oracle database or cluster database target home page, click the Security menu, then select Data Masking and Subsetting, then Data Subsetting Definitions. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.. |
Notes:
Oracle Data Masking and Subsetting Pack incorporates the previous Data Masking Pack and Test Data Management Pack.
Application Data Modeling was previously called as Data Discovery and Modeling.
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 sections:
Accessing Oracle Configuration Management Pack Licensed Links
Oracle Configuration Management Pack Licensed Repository Views
You are entitled to use the following features with a previously purchased Configuration Management Pack for Oracle Database License:
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. |
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 Targets, 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.
If the Target Home Page is accessed directly or by other paths: 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. |
| 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 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. If the Target Home Page is accessed directly or by other paths:
|
| 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. |
| Real-time Configuration Change Detection and 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. |
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
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 |
| Compliance Views | |
|---|---|
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 |
| Oracle Home Patching Views | |
|---|---|
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 |
| 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_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 |
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 sections:
You are entitled to use the following features with a Change Management Pack for Oracle Database License:
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.
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 Targets, 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.
If the Target Home Page is accessed directly or by other paths: 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 Enterprise Manager home page, click Targets, 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.
If the Target Home Page is accessed directly or by other paths: 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 Enterprise Manager home page, click Targets, 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.
If the Target Home Page is accessed directly or by other paths: 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 Enterprise Manager home page, click Targets, 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.
If the Target Home Page is accessed directly or by other paths: 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 Enterprise Manager home page, click Targets, 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.
If the Target Home Page is accessed directly or by other paths: 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. |
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
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.
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 sections:
Accessing Oracle Provisioning and Patch Automation Pack Licensed Links
Oracle Provisioning and Patch Automation Pack Licensed Reports
Oracle Provisioning and Patch Automation Pack Licensed CLI Verbs
Oracle Provisioning and Patch Automation Pack Licensed Repository Views
You are entitled to use the following features with a previously purchased Provisioning and Patch Automation Pack for Oracle Database license:
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
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. |
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
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 |
The following repository views are licensed as part a previously purchased Provisioning and Patch Automation Pack for Oracle Database license:
| 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 |
| Oracle Home Patching Views | |
|---|---|
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 |
| 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 |
Oracle Enterprise Manager Cloud Control no longer offers the Oracle Data Masking Pack. Customers who purchased the legacy Oracle Data Masking Pack are entitled to use the following components and features of Oracle Data Masking and Subsetting Pack:
Application Data Modeling
Data Masking Formats
Data Masking Definitions
Data Subsetting Definitions excluding the Table Rules and Rule Parameters tabs
Application Data Modeling and Data Masking 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
The Oracle Data Masking Pack for non-Oracle Databases includes the following restricted use licenses:
Database Gateway for APPC
Database Gateway for DRDA
Database Gateway for Informix
Database Gateway for SQL Server
Database Gateway for Sybase
If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using the Oracle Data Masking Pack for non-Oracle databases, the Oracle Database Gateways stage the data in a separately licensed Oracle database. Oracle Data Masking functionality cannot be executed directly against the non-Oracle database.
The following are the licensed pages and links for the Oracle Data Masking Pack within Oracle Enterprise Manager.
| Licensed Page/Link | How to Access |
|---|---|
| Application Data Modeling | From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Application Data Modeling.
From the Oracle database or cluster database target home page, click the Security menu, then Application Data Modeling. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking Pack. |
| Data Masking Definitions | On 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. However, the Clone and Mask option requires a Database Lifecycle Management Pack for Oracle Database license. |
| Data Masking Formats | On the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Masking Formats.
From the Oracle database or cluster database target home page, click the Security menu, 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 Subsetting Definitions | On the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Subsetting Definitions.
From the Oracle database or cluster database target home page, click the Security menu, then select Data Masking and Subsetting, then Data Subsetting Definitions. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.. |
Oracle Enterprise Manager Cloud Control no longer offers the Oracle Test Data Management Pack. Customers who purchased the Oracle Test Data Management Pack are entitled to use the following components and features of Oracle Data Masking and Subsetting Pack:
Application Data Modeling
Data Subsetting Definitions
Application Data Modeling and Data 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
The Oracle Test Data Management Pack for non-Oracle Databases includes the following restricted use licenses:
Database Gateway for APPC
Database Gateway for DRDA
Database Gateway for Informix
Database Gateway for SQL Server
Database Gateway for Sybase
If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Test Data Management Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using the Oracle Test Data Management Pack for non-Oracle databases, the Oracle Database Gateways stage the data in a separately licensed Oracle database. Oracle Test Data Management functionality cannot be executed directly against the non-Oracle database.
The following are the licensed pages and links for the Oracle Test Data Management Pack within Oracle Enterprise Manager:
| Licensed Page/Link | How to Access |
|---|---|
| Application Data Modeling | From the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Application Data Modeling.
From the Oracle database or cluster database target home page, click the Security menu, then Application Data Modeling. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Test Data Management Pack. |
| Data Subsetting Definitions | On the Enterprise Summary home page, click the Enterprise menu, then Quality Management, then Data Subsetting Definitions.
From the Oracle database or cluster database target home page, click the Security menu, then select Data Masking and Subsetting, then Data Subsetting Definitions. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack.. |