2 Enterprise Database Management

Enterprise Manager offers the following management packs 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.

Diagnostics Pack for Oracle Database

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.

Features

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.

Licensed Links

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.

Command-Line APIs

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.

Licensed Repository Views

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

  • Monitoring Views

    • MGMT$BLACKOUT_HISTORY

    • MGMT$BLACKOUTS

    • MGMT$ALERT_ANNOTATIONS

    • MGMT$ALERT_NOTIF_LOG

    • MGMT$TARGET_METRIC_COLLECTIONS

    • MGMT$METRIC_COLLECTIONS

    • MGMT$TARGET_METRIC_SETTINGS

    • MGMT$AVAILABILITY_CURRENT

    • MGMT$AVAILABILITY_HISTORY

    • MGMT$ALERT_CURRENT

    • MGMT$ALERT_HISTORY

    • MGMT$METRIC_DETAILS

    • MGMT$METRIC_CURRENT

    • MGMT$METRIC_HOURLY

    • MGMT$METRIC_DAILY

  • Template Views

    • MGMT$TEMPLATES

    • MGMT$TEMPLATE_POLICY_SETTINGS

    • MGMT$TEMPLATE_METRIC_COLLECTION

    • MGMT$TEMPLATE_METRIC_SETTINGS

Tuning Pack for Oracle Database

The Tuning Pack for Oracle Database 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.

Features

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.

Licensed Links

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.

Command-Line APIs

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.

Change Management Pack for Oracle Database

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.

Features

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.


Licensed Parameters

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.

Licensed Links

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

Configuration Management Pack for Oracle Database

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.

Features

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

  • Ensure consistency of deployments, system security checks and scoring, and adherence to operation standards.

  • Include policy violation notifications and Enterprise Security Advisor.

  • Utilize out-of-box policies or generate user-defined policies to meet your specific operational best practices, industry, or regulatory compliance requirements.

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:

  • Secure configuration for the Oracle Database

  • Secure configuration for the Oracle Listener

  • Secure configuration for Oracle Real Application Clusters

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:

  • Capture the current state of configuration settings for IT assets.

  • Monitor these IT assets for changes.

  • Automate processes for provisioning configuration changes along with setting up new environments throughout the application life-cycle — from development through testing, then production.


Licensed Links

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.

Licensed Reports

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

Additional Licensed Features

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.

Configuration Change Console

The Configuration Change Console offers real-time change detection and integration capabilities as described below.

Real-time Change Detection

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

Integration Capabilities

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.

Application Configuration Console

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

Licensed Repository Views

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

Provisioning and Patch Automation Pack for Oracle Database

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.

Features

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

  • Provide end-to-end patching of Oracle products across a wide-range of product patches and customer environments. These include Oracle Database, Oracle Real Application Clusters, Clusterware, and Automatic Storage Management.

  • Integrated management with My Oracle Support providing enhanced levels of patch automation. These include features such as Patch Recommendations and Community information regarding the Patch. The pack also covers the automated deployment part of Patches using PLANs along with Patch Validation and the Merge Patch request process.

  • Patching includes Patch via Deployment Procedures, Linux Patching, and Patch Cache.

  • Provide automated Linux host patching and integration with an Unbreakable Linux network (ULN).

  • Patch Recommendations provide alerts on the patches across Security, Legislative, and Other recommendations that need to be applied.

  • Provide Solaris and Windows patching.

  • Provide out-of-box and custom reporting on patching.

Provisioning and Cloning

  • Create and maintain a library of reference software images.

  • Deploy operating systems and software to bare metal servers.

  • Provide a provisions standard, or "gold," images of Oracle Database, Oracle Real Application Clusters, and Oracle Application Server.

  • Extend RAC clusters or Oracle Application Server middleware.

  • Provide out-of-box and custom reporting on provisioning and deployments.

  • Clone databases and Oracle homes.

  • Convert single-instance databases to RAC.

Security management

  • Ensure system security, and adherence to operation standards.

  • Include policy violation notifications and Enterprise Security Advisor.

Standby database creation

  • Automate the error-prone task of data guard standby database creation.


Licensed Links

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.

Additional Licensed Features

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.

Data Masking Pack for Oracle Database

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.

Features

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.


Licensed Links

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.

Licensed Command Line Interface (CLI) Verbs

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