Enterprise Manager offers the following management packs for Oracle Database:
Diagnostics Pack for Oracle Database
Tuning Pack for Oracle Database
Change Management Pack for Oracle Database
Configuration Management Pack for Oracle Database
Provisioning and Patch Automation Pack for Oracle Database
Data Masking 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 Grid Control, and APIs provided with Oracle Database software.
The following sections in this chapter describe the licensed features for these packs.
The Diagnostics Pack for Oracle Database offers a complete, cost-effective, and easy-to- use solution for managing the performance of Oracle Database environments by providing unique functionality such as automatic identification of performance bottlenecks, guided problem resolution, and comprehensive system monitoring. You can access the Diagnostics Pack functionality through Enterprise Manager licensed links.
Note:
Any and all methods of accessing pack functionality — whether through the Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data — require the Pack license.Note:
System Monitoring Plug-in for Hosts is included with the Diagnostics Pack for Oracle Middleware license.The Diagnostics Pack includes the following features, which you can use after purchasing a license for the pack.
Table 2-1 Features of Diagnostics Pack for Oracle Database
Feature | Benefit |
---|---|
Automatic Workload Repository (AWR) |
Provide Oracle Database 10g and Database 11g built-in, automatic capture of statistics data to be used for real-time and historical performance analysis. Snapshot data, active session history data, and workload reports are part of AWR. |
Performance monitoring and diagnostics |
Measure performance and diagnoses poor performance with associated drill-downs on the Performance page. This includes historical analysis and alert threshold integration. |
Automatic Database Diagnostic Monitor (ADDM) |
Provide Oracle Database 10g and Database 11g built-in functionality for out-of-the-box automatic performance analysis based on AWR data. |
Operating system monitoring |
Monitor the operating system and hardware in the drill-downs from Grid Control host monitoring pages. |
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. |
Advanced alert management |
Include notification methods, rules, and schedules, metric history and associated drill-downs, ability to set blackouts, associate corrective actions with an alert, user-defined metrics, metric snapshots, monitoring templates, adaptive metric thresholds, setting metric baselines, and Memory Access Mode. |
Memory access mode |
For slow or hung systems, retrieve performance statistics directly from the Shared Global Area (SGA), which avoids the computation associated with parsing and executing SQL statements. This remediates severe cases of library cache contention that can prevent the instance from being monitored in SQL Mode. |
Advanced alert management: notification methods, rules and schedules |
Define different mechanisms for sending notifications, including e-mail, SNMP traps, or running custom scripts. You can then use these methods with Notification Rules for sending notifications to administrators as a result of alert occurrences. You can set up schedules so that various administrators are notified at the appropriate times. |
Advanced alert management: event and metric history |
Analyze past performance and issues that have affected your database and host. |
Blackouts |
Allow Enterprise Manager administrators to suspend any data collection activity on one or more monitored targets, thereby allowing Enterprise Manager administrators to perform scheduled maintenance on targets. |
Monitoring templates |
Simplify the task of setting up monitoring for large numbers of targets by enabling administrators to specify the monitoring settings once, then apply them as often as needed. |
Note:
Generation of alerts (through Enterprise Manager or directly by the server in Oracle Database 10g or Database 11g) is not part of this pack; it is free with the database.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.
To determine which links in Oracle Enterprise Manager Database Control and Grid Control are part of the Diagnostics Pack, do the following from the Enterprise Manager Home page:
Click the Setup link on the upper right corner of the Enterprise Manager Home page.
Click the Management Pack Access link. The Management Pack Access page appears, which enables you to grant and remove access for all the management packs.
For Enterprise Manager Database Control, remove access for the Database Diagnostics Pack and click Apply.
For Enterprise Manager Grid Control, remove access for the Database Diagnostics Pack and click Apply.
This disables all the links and tabs associated with the Diagnostics Pack in Enterprise Manager. All the disabled links and tabs are part of the Diagnostics Pack and therefore require a pack license.
You can access Diagnostic Pack features through 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 this pack. The following filter clause to any query on DBA_STREAMS_TP_COMPONENT_STAT 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';
All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their 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, and DBA_HIST_UNDOSTAT.
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 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.
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
Template Views
MGMT$TEMPLATES
MGMT$TEMPLATE_POLICY_SETTINGS
MGMT$TEMPLATE_METRIC_COLLECTION
MGMT$TEMPLATE_METRIC_SETTINGS
The Tuning Pack for Oracle Database offers a set of ground-breaking technologies that automate the application tuning process, thereby significantly lowering database management costs while enhancing performance and reliability. This significantly improves resource utilization and ensures best application performance without manual intervention.
The Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. 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, customers interested in using any of the Tuning Pack functionality must license both of these packs.Any and all methods of accessing pack functionality — whether through the Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data — require the Pack license.
The Tuning Pack includes the following features, which you can use after purchasing a license for the pack.
Table 2-2 Features of Tuning Pack for Oracle Database
Feature | Benefit |
---|---|
SQL Tuning Advisor |
Include the ability to analyze SQL statements and make recommendations for better execution, such as applying SQL Profiles or recommending rewriting of the SQL. |
SQL Access Advisor |
Recommend schema changes needed to improve database performance; for example, creation of new indexes and materialized views. |
Reorganize objects |
Provide the Schema Object Reorganization wizard to reorganize database objects. |
SQL Tuning Sets |
A SQL Tuning Set (STS) is a database object that captures and manages SQL workloads. It includes one or more SQL statements along with associated execution context (that is, user schema, list of bind values, and so forth) and execution statistics (that is, elapsed time, CPU time, and so forth). |
Real-time SQL Monitoring |
Monitor execution of long-running or parallel SQL statements in real-time without any performance overhead. |
Automatic SQL Tuning Advisor |
Utilize automatic mode of SQL Tuning Advisor, in which the advisor runs automatically during system maintenance windows as a maintenance task. During each run, the advisor selects high-load SQL queries in the system, and generates recommendations on how to tune them. |
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.
To determine which links in Oracle Enterprise Manager Database Control and Grid Control are part of the Tuning Pack, do the following from the Enterprise Manager Home page:
Click the Setup link on the upper right corner of the Enterprise Manager Home page.
Click the Management Pack Access link. The Management Pack Access page appears, which enables you to 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 Grid Control, remove access for the Database Tuning Pack and click Apply.
This disables all the links and tabs associated with the Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of the Tuning Pack and therefore require a pack license.
You can access Tuning Pack features through the following database server APIs and command-line interfaces:
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
The sqltrpt.sql report in the /rdbms/admin/ directory of the Oracle home directory is part of this pack.
The Change Management Pack for Oracle Database enables administrators to identify and implement planned database schema changes to support new application requirements without errors and data loss, as well as track unplanned schema changes that may be causing downtime. Using the Change Management Pack, administrators can investigate and track complex changes, compare and synchronize objects and schemas, modify schema objects, evaluate the change impact, and if required, undo previous changes. The Change Management Pack makes applying schema changes simple and efficient, and minimizes potential errors, thereby reducing the opportunity for data loss and system down-time.
The Change Management Pack includes the following features, which you can use after purchasing a license for the pack.
Table 2-3 Features of Change Management Pack for Oracle Database
Feature | Benefit |
---|---|
Baselines |
Capture and version baselines. Capture database and schema definitions. |
Baseline import and export |
Transfer a baseline from one Grid Control environment to another by exporting and importing the baseline to an external file. |
Comparisons |
Compare baseline with database, or database with database, schema with schema. |
Synchronization |
Propagate database objects and schemas with or without data, and update database object definitions. |
Reverse engineering |
Reverse-engineer database and schema definitions. |
Copying objects |
Copy database objects with data, with a subset of the data, or without data. |
Object definition updates |
Update database objects definitions (ALTER_TABLE). |
Change evaluation |
Evaluate the impact of changes. |
Cloning and propagation |
Clone or propagate application schemas. |
Real-time schema change detection |
Track schema changes in real time to identify unwanted or unplanned changes. |
The use of the following init.ora parameter is licensed as part of the Oracle Change Management Pack when set to TRUE:
ENABLE_DDL_LOGGING
The default is FALSE.
The following licensed pages and links of this pack apply to change management for Oracle Databases.
From the Grid Control Home page, select the Databases sub-tab. In the Related Links section, the following links and associated pages are licensed as part of the pack:
Dictionary Baselines
Dictionary Comparisons
Dictionary Synchronizations
The Configuration Management Pack for Oracle Database automates the time-consuming, costly, and often error-prone process of software configuration, software and hardware inventory tracking, patching, policy management, and compliance, ensuring consistency across deployments. You can access the Configuration Management Pack for Oracle Database functionality through Enterprise Manager licensed links and by installing the Configuration Change Console and Application Configuration Console. All three of these components comprise the features provided by the Configuration Management Pack for Oracle Database.
Note:
To obtain all features of the Configuration Management Pack for Oracle Database, you need to enable the Configuration Management Pack for Non-Oracle Systems in Grid Control for the host on which you have the licensed Configuration Management Pack for Oracle Database. If you already have the licensed Configuration Management Pack, you are entitled to the Configuration Management Pack for Non-Oracle Systems for the host on which you have the Configuration Management Pack.Any and all methods of accessing pack functionality — whether through the Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data — require the Pack license.
The Configuration Management Pack for Oracle Database includes the following features you can use after purchasing a license for the pack.
Table 2-4 Features of Configuration Management Pack for Oracle Database
Feature | Benefit |
---|---|
Database and host configuration management |
Provide hardware and software configuration data collection, search, comparison, real-time change detection, and analytical reporting. |
Patching |
Include Critical Patch Advisories, which alert you to critical patches that need to be applied. |
Policy and security management |
|
Policy groups |
Provide structured collection of security configuration rules against which targets can be measured or judged. This release provides the following out-of-box policy groups:
Create your own policy groups to specifically address your operational processes and best practice needs. Choose from the library of out-of-box or user-defined policies to group policies to meet your specific needs. This capability enables you to create, edit, and delete policy groups. This feature is accessible from the Policy Group sub-tab under the Compliance tab. |
Deployments/installations, including patch-level |
Understand what you have by utilizing the Configuration Management Pack for Oracle Database for discovery, asset tracking of all hardware and software configurations, configuration change tracking, and maintenance of relationships. |
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. |
Security at a glance |
From a single view, monitor and standardize compliance to security standards across your enterprise. View compliance scores and track trends over time to understand improvements in compliance or deviations. Drill down into individual targets to understand policy violations and closed loop remediation. |
Real-time configuration change detection |
Provide real-time configuration change detection and automation of compliance frameworks, such as Sarbanes-Oxley (SOX), Information Technology Infrastructure Library (ITIL), and Payment Card Industry (PCI) data security standards. Oracle Configuration Management Pack for Oracle Database solves this need with a centralized Configuration Change Console that includes out-of-box and user-defined policies and controls. |
Application configuration management |
Provide a comprehensive solution for managing the application infrastructure underlying mission-critical applications. The Application Configuration Console provides an automated “gold master” methodology to application infrastructure management providing IT infrastructure personnel the ability to:
|
The following licensed pages and links of this pack apply to configuration management for Oracle Databases.
Grid Control Home page:
All links in the All Targets Policy Violations section
Database, Hardware, and Operating System related information in the Deployments Summary section
All links in the Security Policy Violations section
All links in the Critical Patch Advisories for Oracle Homes section
From the Grid Control Home page, click the Targets tab, then the Databases sub-tab. On the Databases page, the Policy Violations links are licensed as part of the pack.
From the Grid Control Home page, click the Deployments tab. On the Deployments page, the following items are licensed as part of the pack:
All links in the Configuration and Client Configurations sections
From the Grid Control Home page, select the Compliance tab to display the Policy Violations page, which is grouped in the Violations sub-tab. All links, sub-navigation tabs, and features available on or linked to from the Grid Control Policies Violations page for policies related to databases and hosts are licensed as part of this pack.
From the Grid Control Home page, select the Compliance tab, then the Policy Groups sub-tab. On the Grid Control Policy Group Evaluation Results page, all links and features are licensed as a part of this pack.
From the Grid Control Home page, select the Compliance tab, then the Security at a Glance sub-tab. On the Grid Control Security at a Glance page, all links and features are licensed as a part of this pack.
From the Grid Control Hosts page, click a specific host to display the Host Home page. The following links are licensed as part of the pack:
All links in the Security section
Under Related Links, the following links are licensed:
Deployments
Metric and Policy Settings
From the Host Home page, click the Targets tab. The following links and columns are licensed:
Policy Violations and associated links
Compliance Score (%)
From the Host Home page, click the Configuration tab. The following buttons are licensed:
Save
History
Compare Configuration
Compare to Multiple Configurations
From the Grid Control Home page, click the Targets tab, then select the Systems sub-tab. On the Systems page, the following items are licensed as part of the pack:
Policy Violations links
From the Systems page, click any system Name. On the System Home page, everything is licensed as part of the pack except for the Status and Alerts sections.
From the Grid Control Home page, click the Targets tab, then select the Groups sub-tab. On the Groups page, the following items are licensed as part of the pack:
Policy Violations links
From the Groups page, click any group Name. On the Group Home page, everything is licensed as part of the pack except for the Status and Alerts sections.
From the Groups Home page, click the Administration tab. The following links and features are licensed features of the pack:
Hardware and Operating Systems related information in the Deployments Summary section
Host Operating System and Hardware Summaries selection for the Configuration Searches section
Click the Setup link on the upper right corner of the Enterprise Manager console, then click the Monitoring Templates link. On the Monitoring Templates page, click any Name. The Policies sub-tab on the View Monitoring Template page is a licensed feature of the pack.
The following reports are part of the Configuration Management Pack for Oracle Database. All reports in each of these sections are licensed for this pack. To display the Report Definitions page, click the Reports tab on the Grid Control Home page.
All reports under Deployment and Configuration
Monitoring reports
Alerts and Policy Violations
Disabled Policies
Security reports
Security Policy Overview
With the 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.
The Configuration Change Console offers real-time change detection and integration capabilities as described below.
The Configuration Change Console is a policy-based system designed to help organizations and administrators support their IT compliance goals and help deliver the level of service expected by their users. The console includes a set of predefined frameworks created by industry experts to meet common compliance requirements. This enables IT departments to quickly and easily demonstrate compliance with government regulations and industry standards such as SOX, PCI, and ITIL.
The frameworks provide predefined controls mapped to application, device, and user event detection rules. These mappings empower the enterprise to monitor adherence for best practices from a centralized dashboard and provide concrete evidence in the form of reports for internal and external audits, reducing both the risk and cost of compliance. The console also provides an easy-to-use interface enabling administrators to define their own specific frameworks, policies, and controls and map them to the devices across their environment that they decide to monitor.
The Configuration Change Console automates the detection and capture of user and application actions that result in changes to the infrastructure without requesting or requiring user input. This automates the compliance audit trail and minimizes the time required to uncover compliance breaches.
Examples of components monitored for configuration change include:
Files and directories
Processes
User accounts
Server resources
Databases
Middleware
Network devices
The Configuration Change Console complements many existing IT infrastructure and service management systems through the following integration approaches:
Change management system integration — The Configuration Change Console integrates with popular change management systems (such as Remedy) to create a closed-loop change management solution. Integration is achieved through an adapter that enables communication between the change management system and Configuration Change Console. This integration enables the Configuration Change Console to determine if a change was authorized or unauthorized through an open request for change in the change management system.
Simple Network Management Protocol traps — The Configuration Change Console can send an alert whenever a specific change is detected to any third-party system.
Standards-based APIs — The Configuration Change Console is based on industry standards such as Java Platform, Enterprise Edition (J2EE), and Extensible Markup Language (XML), and can integrate with similar standards-based interfaces.
Configuration Change Console Restricted-use Licensing
The Configuration Change Console Server includes restricted-use licenses for Oracle Database (Enterprise Edition), Oracle BEA WebLogic, and Oracle Business Intelligence solely for the purpose of running the Configuration Change Console Release Server.
Restricted-use License for Oracle Database (Enterprise Edition)
Oracle includes restricted-use licenses for Oracle Database (Enterprise Edition) with the Configuration Change Console Release. If you want to use the Oracle Database (Enterprise Edition) not solely for the purpose of running the Configuration Change Console Server, you must purchase full-use licenses for Oracle Database (Enterprise Edition).
Restricted-use License for Oracle BEA WebLogic
Oracle includes restricted-use licenses for Oracle BEA WebLogic with the Configuration Change Console Release. If you want to use the Oracle BEA WebLogic not solely for the purpose of running the Configuration Change Console Release Server, you must purchase full-use licenses for Oracle BEA WebLogic.
Restricted-use License for Oracle Business Intelligence
Oracle includes restricted-use licenses for Oracle Business Intelligence with the Configuration Change Console. If you want to use Oracle Business Intelligence not solely for the purpose of reporting on the data within the Configuration Change Console Server, you must purchase full-use licenses for Oracle Business Intelligence. You can use the restricted-use license to:
Utilize out-of-box reports shipped with the Configuration Change Console.
Modify out-of-box report visualization and layouts.
Add additional data to reports with the Configuration Change Console repository as the sole source of additional data.
Create new reports with the Configuration Change Console repository as the sole source of data.
Enterprises today require a comprehensive solution for managing their application infrastructure underlying their mission-critical applications. The Application Configuration Console provides IT infrastructure teams with an automated “gold master” approach to application infrastructure configuration management that enables smooth delivery and support of mission-critical business applications. IT infrastructure personnel can capture the current state of configuration settings for IT assets, monitor them for changes, and automate processes for provisioning changes as well as set up new environments throughout the application life-cycle — from development, testing, and through production.
The Application Configuration Console provides:
Management of database and IT infrastructure configuration data at individual property levels
System-level configuration comparisons
Template-based configuration collections
Policy enforcement at individual configuration property levels
Intelligent parameter-setting for configuration properties
Change tracking and alerts for individual configuration property changes
Blueprints for configuration collection of 100+ software assets
Role-based views of configuration data
Agentless collections
Application Configuration Console Restricted Use Licensing
Application Configuration Console includes a restricted-use license for Oracle Database (Enterprise Edition) solely for the purpose of running the Application Configuration Console Server.
Restricted-use License for Oracle Database (Enterprise Edition)
Oracle includes restricted-use licenses for Oracle Database (Enterprise Edition) with the Application Configuration Console. If you want to use the Oracle Database (Enterprise Edition) not solely for the purpose of running the Application Configuration Console Server, you must purchase full-use licenses for Oracle Database (Enterprise Edition).
The following repository views are part of the Configuration Management Pack for Oracle Database:
Policy Definition Views
MGMT$POLICIES
MGMT$POLICY_PARAMETERS
MGMT$POLICY_VIOLATION_CTXT
MGMT$POLICY_VIOL_ANNOTATIONS
MGMT$POLICY_VIOL_NOTIF_LOG
Policy Association Views
MGMT$TARGET_POLICIES
MGMT$TARGET_POLICY_SETTINGS
MGMT$TARGET_POLICY_EVAL_SUM
MGMT$TARGET_COMPLIANCE_SCORE
Policy Violation Views
MGMT$POLICY_VIOLATION_CURRENT
MGMT$POLICY_VIOLATION_HISTORY
MGMT$POLICY_VIOLATION_CONTEXT
Configuration Views
MGMT$DB_CONTROLFILES
MGMT$DB_DATAFILES
MGMT$DB_DBINSTANCEINFO
MGMT$DB_FEATUREUSAGE
MGMT$DB_LICENSE
MGMT$DB_TABLESPACES
Oracle Home Patching
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
Linux Patching
MGMT$HOSTPATCH_HOSTS
MGMT$HOSTPATCH_GROUPS
MGMT$HOSTPATCH_GRP_COMPL_HIST
MGMT$HOSTPATCH_HOST_COMPL
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
The Provisioning and Patch Automation Pack for Oracle Database automates the deployment of servers, software, and patches. Functionality is provided for "bare-metal" provisioning of operating systems and software images, cloning of existing installations and software images (such as Oracle Clusterware, Oracle Real Application Clusters, and Oracle Automatic Storage Management), and patching. Critical data center operations become easy and scalable, resulting in lower operational risk and cost of ownership.
The Provisioning and Patch Automation Pack includes the following features you can use after purchasing a license for the pack.
Table 2-5 Features of Provisioning and Patch Automation Pack for Oracle Database
Feature | Benefit |
---|---|
Patching |
|
Provisioning and Cloning |
|
Security management |
|
Standby database creation |
|
The list that follows itemizes the links that require licensing of the Provisioning and Patch Automation Pack for Oracle Database. You can navigate to these features in several ways. The instructions below assume that you begin from the main Grid Control Home page.
From the Enterprise Manager Home page:
Select any of the links in the Security Violations section. On the resulting Violations page, the Security At a Glance tab is a licensed feature of the standalone Provisioning and Patch Automation Pack.
Under the section Critical Patch Advisories for Oracle Homes, any Patch button is a licensed feature of the pack.
From the Deployments page linked from the Enterprise Manager Home page:
Under the section Critical Patch Advisories for Oracle Homes, any Patch button is a licensed feature of the pack.
Under the Patching section, the links Patching through Deployment Procedures, View/Upload Patch, and Patch Linux Hosts are all licensed under the Provisioning and Patch Automation Pack for Oracle Database.
Under the Cloning section, the links Clone Database and Clone Oracle Home are both part of the Provisioning feature.
Under the Deployment Procedure Manager section, the general link Deployment Procedures and specific functionality procedures links, such as RAC Provisioning Procedures, Patch Procedures, and Extend Cluster Database are all licensed under the Provisioning and Patch Automation Pack for Oracle Database.
Only Deployment Procedures associated with the Operating System and Database are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database. All other Deployment Procedures are associated with the other Provisioning and Patch Automations packs.
The sub-navigation tab Provisioning and the tabs under the page are all licensed under the Provisioning and Patch Automation Pack for Oracle Database.
The sub-navigation tab Patches & Updates, the following links, and associated features are licensed under the Provisioning and Patch Automation Pack.
Patch via Deployment Procedures
Linux Patching
Patch Cache
From the My Oracle Support page linked from the Enterprise Manager Home page::
Under the section Patches & Updates, the following links are licensed features of the Provisioning and Patch Automation Pack:
The link Patch via Deployment Procedures and all tabs and links under that page are all licensed under the Provisioning and Patch Automation Pack.
The link Linux Patching and all tabs and links under that page are licensed under the Provisioning and Patch Automation Pack.
The link Patch Cache and all tabs and links under that page are licensed under the Provisioning and Patch Automation Pack.
Under the section Patch Recommendations, all features and links are licensed features of the Provisioning and Patch Automation Pack.
Under the section Patch Plans, all features associated with PLANs, such as Create/Add to Plans and Validation and Merge Request process, along with integration with Deployment Procedures, are licensed features of the Provisioning and Patch Automation Pack.
On the Database Home page Software and Support tab, the following links are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:
Apply Patch, View Patch Cache, and Patch Prerequisites under the Database Software Patching section
All of the links under the Deployment Procedure Manager section
On the Database Home page Data Movement tab, the Clone Database link in the Move Database Files section is licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.
On the Database Home page Server tab, the following links under the Change Database section are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:
Convert to Cluster Database link
Add Instance (only for RAC database)
Delete Instance (only for RAC database)
On the Database Home page Server tab, the Migrate to ASM link under the Storage section is licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.
On each of the following target tabs, the Security At a Glance link is licensed as part of the Provisioning and Patch Automation Pack for Oracle Database:
Host Targets tab, navigate to the Host Home page, then select the Enterprise Security At a Glance link.
Groups tab, navigate to the Group Home page, then select the Security At a Glance link.
Systems tab, navigate to the Systems Home page, then select the Security At a Glance link.
Web Applications tab, navigate to the Web Applications Home page. From there, select the System link, then the System (Topology) link, and then select the Security At a Glance link.
Services tab, navigate to the Service Home page. From there, select the System link, then the System (Topology) link, and then select the Security At a Glance link.
From the Grid Control Home page, click the Setup link in the upper right corner of the page. On the Overview of Setup page, click the Agents sub-tab. From the Agents page, click an agent to display the Agent Home page. The Dell Change Automation selection from the Add drop-down menu under the Monitored Targets section is a licensed feature of the Provisioning and Patch Automation Pack for Oracle Database.
From the Grid Control Home page, click the Targets tab, then All Targets. On the All Targets page, click the Dell Change Automation link. All links and features available on or linked to from the Dell Change Automation page are licensed as part of the Provisioning and Patch Automation Pack for Oracle Database.
The oplan utility is an independent tool that operates with Opatch to provide advanced capability for patching Oracle Software. oplan currently generates context-sensitive patch installation instructions based on the customer's environment, which simplifies the Oracle software patching experience for Oracle customers. The oplan-generated installation instructions are computed based on the automation scheme chosen by the user in relation to the specific environment and configuration where the tool is invoked.
oplan is provided under the My Oracle Support Terms of Use, your agreement with Oracle, and the terms of Oracle's applicable Technical Support Policies. Any use of oplan not specifically authorized in the My Oracle Support Terms of Use, your agreement with Oracle, and the terms of Oracle's applicable Technical Support Policies is strictly prohibited. Any usage directly or indirectly with a third party of commercial interest requires an Oracle Provisioning and Patch Automation for Database pack license.
The Data Masking Pack for Oracle Database 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 where the masked data originates, as well as database servers containing the masked data.The Data Masking Pack includes the following features you can use after purchasing a license for the pack.
Table 2-6 Features of Data Masking Pack for Oracle Database
Feature | Benefit |
---|---|
Define format libraries |
Define and use standard mask formats for sensitive data across databases. |
Create or use masking definitions |
Specify which tables and columns are to be masked as well as the formats used to mask columns. |
Export or import application masking templates |
Allows application developers or application providers to provide database administrators with a ready-to-use mask definition in a portable XML format. |
Export or import format libraries |
Allows application developers or information security analysts to provide a ready-to-use definition for common sensitive data that database administrators can reference when specifying a mask definition. |
The list that follows itemizes the links that require licensing of the Data Masking Pack for Oracle Database. You can navigate to these features in several ways. The instructions below assume that you begin from the main Grid Control Home page.
From the Enterprise Manager Home page:
Click the Targets tab, then the Databases sub-tab.
Select a database name from the table. The Database Instance Home page appears.
Click the Schema sub-tab. From the Database Instance Schema page that appears, click Definitions in the Data Masking section. All links, buttons, and drilldowns on the Masking Definition page are licensed features of this pack.
From the Database Instance Schema page, click Format Library in the Data Masking section. All links, buttons, and drilldowns on the Format Library page are licensed features of this pack.
The following Enterprise Manager CLI verbs are licensed as part of the The Data Masking 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