2 New Features In Oracle Enterprise Manager Cloud Control 13c Release 4

This chapter provides an overview of the new features available in Oracle Enterprise Manager Cloud Control 13c Release 4 (13.4).

It contains the following sections:

Installation and Upgrade

This section describes new features and enhancements for Installation and Upgrade.

  • Parallel OMS Upgrades: In a multi-OMS environment, you can now upgrade the primary OMS and then all additional OMS can be upgraded simultaneously.

    For more information, see Upgrading Multiple OMS in Parallel in the Oracle Enterprise Manager Cloud Control Upgrade Guide.

  • Decommission Multiple Agents: You can now decommission multiple agents at the same time using the Enterprise Manager console or EM CLI. You can choose to remove multiple agents and their associated targets from the repository only, or you can choose to remove multiple agents and their targets from the repository as well as deinstall all agent software from their hosts. You need super administrator privileges to perform this operation.

    For more information, see Decommissioning Oracle Management Agents in the Enterprise Manager Cloud Control Advanced Installation and Configuration Guide.

Enterprise Monitoring

This section describes new features and enhancements for Enterprise Monitoring.

  • Always-on Monitoring – Filter Alerts by Severity and Event Type: New emsctl enable_notification and disable_notification verb options are available that let you filter alerts by:
    • Severity (-severities) such as Fatal, Critical, Warning, or Clear
    • Event Type (-alert_types) such as Metric Alert, Availability, and Metric Evaluation Error

    For more information, see Enabling Notifications in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

  • Exclude Targets from Composite Targets During a Blackout using emcli: New emcli blackout verb options (exclude_targets, exclude_types) are now available that let you exclude targets or target types from a blackout.

    For more information, see Exclude Targets from Composite Targets During a Blackout in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

  • Automated Password Functionality for DBSNMP (monitoring only) Database Password: A new job type allows you to automate updating the password for dbsnmp or any monitoring user that is not SYSDBA or SYSOPER from the Enterprise Manager Cloud Control console. The password update job can be run on Oracle Database and Cluster Database instances.

Database Management

This section describes new features and enhancements for Database Management.

  • Execute SQL is supported via REST API: You can now use HTTP-based REST endpoints to execute SQL commands and extract data. Using this you can extract data from:
    • The Oracle Management Repository
    • A database target configured in Oracle Enterprise Manager Cloud Control

    For more information, see Executing SQL via REST API in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

  • Cluster Health Advisor integration with Oracle Enterprise Manager Cloud Control: You can now use Oracle Cluster Health Advisor, which is integrated into the Incident Manager in Oracle Enterprise Manager Cloud Control, to detect and analyze operating system and cluster resource-related degradation and failures. Cluster Health Advisor is enabled by default and it continuously tracks the operating system resource consumption at each node, process, and device level. It provides detailed explanation regarding issues that occur in clusters where Oracle Clusterware and Oracle Real Application Clusters (RAC) are running, for example, during node eviction.

    Here are some of the benefits you can derive from the Cluster Health Advisor functionality:

    • Detects node and database performance problems
    • Provides early-warning alerts and corrective action
    • Supports on-site calibration to improve sensitivity

    For more information, see Introduction to Oracle Cluster Health Advisor in the Oracle Database Autonomous Health Framework User's Guide.

  • Automatic Indexing for Autonomous Transaction Processing – Dedicated databases: You can now enable Automatic Indexing for the Autonomous Transaction Processing – Dedicated databases monitored in Oracle Enterprise Manager Cloud Control.

    The automatic indexing feature automates index management tasks such as creating, rebuilding, and dropping indexes based on the changes in application workload, thereby improving database performance.

    For more information, see Monitoring and Administration Tasks in the Oracle Enterprise Manager Cloud Control Administrator's Guide for Oracle Autonomous Databases.

  • Automatic Workload Repository (AWR) warehouse enhancements:
    • Active Data Guard (ADG) support in AWR warehouse: ADG now supports the switch over when the warehouse database or source database is configured with ADG and the primary database goes down and the standby database becomes the primary. After the switchover, the databases are automatically switched in the AWR warehouse.

      Previously, the AWR warehouse did not recognize the switch over when the primary database was down and the standby database became the primary, and this caused issues such as Extract-Transform-Load (ETL) process failure.

    • AWR Warehouse Diagnosability: You can now proactively identify the points of failure after the AWR warehouse is configured and the ETL process started running between the source database and warehouse, by running a number of tests on the AWR warehouse or a select set of sources and determine the health of the AWR warehouse configuration.
  • SQL Performance Analyzer Enhancements:
    • Concurrent SQL Execution with SQL Performance Analyzer: You can now execute SQL concurrently with the SQL Performance Analyzer. The default behavior of the SQL Performance Analyzer is to execute SQL sequentially when testing to measure performance. In some cases, when very large SQL tuning sets are involved, you can execute SQL concurrently to expedite the testing process. This enables you to complete testing quickly and with added flexibility.

      For more information, see Configuring the Degree of Parallelism for an Analysis Task in the Oracle Database Testing Guide.

    • SQL Performance Analyzer Result Set Validation: You can now use SQL Performance Analyzer Result Set Validation to validate whether the result sets which were returned during the initial SQL Performance Analyzer test are similar to the result sets returned in the subsequent tests. This feature adds an additional assurance that the queries are executing as expected and returning the exact same set of data.

      For more information, see Validating SQL Result Sets Using SQL Performance Analyzer in the Oracle Database Testing Guide.

  • Real Application Testing Enhancements:
    • When capturing a workload carrying PL/SQL based application logic for Database Replay, you can now select the Extended option for the PL/SQL capture mode on the Database Replay > Create Capture: Options page. This ensures that the workload is captured at the first level of recursive PL/SQL calls.
    • When replaying a workload carrying PL/SQL based application logic, you can now select the Extended value for the PL/SQL Mode replay parameter on the Replay Workload: Customize Options page > Replay Parameters tab, thereby ensuring that the workload is replayed at first level of recursive calls. Note that to be able to replay a workload in PL/SQL mode, it must be captured in the Extended mode.
    • For the Synchronization replay parameter, which controls the synchronization method used for database replay, you can now set one of the following values on the Replay Workload: Customize Options page > Replay Parameters tab:
      • Time: If the Synchronization parameter is set to Time, the replay uses the same wall-clock timing as the capture. This is the default option.
      • SCN: If the Synchronization parameter is set to SCN, then the COMMIT order in the captured workload is observed during replay and all replay actions are executed only after all dependent COMMIT actions have completed.

      Previously, the values available for the Synchronization replay parameter were SCN, FALSE, and OBJECT_ID.

    • You can now replay a workload in Query Only Mode by specifying True against the parameter on the Replay Workload: Customize Options page > Replay Parameters tab. When a workload is replayed in Query Only Mode, it omits all PL/SQL, DML and DDL statements, thereby allowing the rerunning of the workload without restoring the database. This mode should be used to perform a sanity check before replaying the workload in Read/Write mode.

    For more information, see Database Replay in the Oracle Database Testing Guide.

  • Support Availability Information: Oracle Enterprise Manager Cloud Control 13.4 has added support for the following:
    • Oracle Database 18c and 19c as repository and managed targets
    • Oracle Exadata Database Machine X6 and X7

Database Lifecycle Management New Features

Following are the new features and enhancements for database lifecycle management:

  • Transparent Data Encryption (TDE) support for Cloning use cases: TDE is now supported in the following Database Lifecycle Management workflows:
    • Creating a full clone database
    • Creating a full clone pluggable database (PDB)
    • Relocating a PDB

    EMCLI verb db_software_maintenance has been updated to support databases with TDE enabled.

  • REST APIs for Fast-start Failover and Observer Management: You can now manage your Fast-start Failover and Observer targets via REST commands.

    Fast-start Failover increases the availability of a database by eliminating the need for administrator intervention as part of the failover workflow.

  • Center for Internet Security (CIS) 2.1.0 for Oracle Database 12c: You can now use the CIS 2.1.0 standard to audit your Oracle Database 12c instance and clusters.
  • Support for Oracle Homes consolidation: You can now use the EM CLI attach_home flag to merge homes of databases running from different Oracle Homes, on the same host. A second Oracle Home can be merged to a previously deployed Oracle Home if the two homes are patched with the same version of the Gold Image. For more information, see Attach Oracle Homes in the Enterprise Manager Database Lifecycle Management Guide.
  • Cleanup of Oracle Homes: Oracle homes consume valuable storage space, they can be cleaned up to release space when they are no longer in use. This operation removes unused, empty no longer needed Oracle Homes to help you better administrate space and resources. For more information, see Cleaning Up Oracle Homes in the Enterprise Manager Database Lifecycle Management Guide.
  • Standby database start option after patching: The new STANDBY_START_OPTION parameter allows you to set a specific start option for your standby database after patching. The Parameter needs to be included in the -input_file. For more information, see Updating and Rolling Back Standby Databases in the Enterprise Manager Database Lifecycle Management Guide.

Engineered Systems Management New Features

Following are the new features and enhancements for Engineered Systems Management:
  • Support for Exadata Extended Storage Server: Oracle Enterprise Manager Cloud Control now provides dedicated support for Exadata Extended (XT) Storage. Since XT storage servers do not have flash drives, Oracle Enterprise Manager Cloud Control will automatically suppress all the flash-related monitoring functionalities, and present only those IO Resource Management settings that are appropriate for XT storage. Exadata X8 systems configured with XT storage are automatically recognized by Oracle Enterprise Manager Cloud Control during discovery, and the corresponding Exadata Storage Server targets automatically adapt to the underlying storage server type.
  • Support to monitor Oracle Database Exadata Cloud Service and Oracle Database Exadata Cloud at Customer using Oracle Enterprise Manager Cloud Control: You can benefit from the following features that are now available with support for the cloud target:
    • Enterprise Manager target for Exadata Cloud:
      • Automatically identifies and organizes related targets
      • Provides an integration point for Exadata Cloud-specific functionality
    • Improved Performance Monitoring:
      • Adds Exadata Storage Server and Exadata Storage Grid targets
      • Offers visualization of storage and compute performance for Oracle Exadata Cloud
      • Enables use of the same Maximum Availability Architecture (MAA) Key Performance Indicators (KPI) that was developed for Oracle Exadata Database Machine
    • Scripted CLI-based discovery: Using emcli, discover the cloud target which includes the existing hosts, clusters, ASM, Database and related member targets.
    • Provides a single pane of glass for all Exadata targets:
      • Monitor and manage Oracle Exadata Database Machine and Oracle Exadata Cloud systems through a common Exadata target menu
      • Consistent experience across Oracle Database Exadata Cloud Service and Oracle Database Exadata Cloud at Customer
    • Visualization: Visualize the database and related targets associated with each Oracle Database Exadata Cloud Service and Oracle Database Exadata Cloud at Customer.

Enterprise Manager Command Line Interface

This section lists the new or updated Enterprise Manager Command Line Interface (EM CLI) commands.

  • create_blackout: New verb options, exclude_targets and exclude_types, let you exclude targets or target types from a blackout.

    For more information, see Exclude Targets from Composite Targets During a Blackout in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

  • create_dynamic_group: New verb for creating a new dynamic group
  • db_software_maintenance: Added support for databases with TDE enabled

    Added a new flag -attach_home. This is used to merge homes of two databases running from different Oracle Homes, on the same host. A second Oracle Home can be merged to a previously deployed Oracle Home if the two homes are patched with the same version of the Gold Image.

    Oracle Home is now a valid target type for cleanup by providing: -performOperation -name="cleanup", -target_list, and -target_type=oracle_home.

  • delete_swlib_entity: New verb for deleting an entity from the Software Library
  • get_supported_privileges: New verb for getting privileges available to the type specified. (For example, ALL | SYSTEM | TARGET | JOB )
  • relocate_wls: New verb for migrating Weblogic Server from physical host to logical host
  • run_auto_discovery: New verb for running target discovery automatically
  • set_target_property_value: New verb to set the value of a target property for a specified target.
  • upload_patches: New verb for multi-part patching
  • verify_swlib -verbose: New option to display verbose logging information.

Cloud Management

This section describes new features and enhancements for Cloud Management.

  • Oracle Linux Virtualization (OLV): You can use Oracle Enterprise Manager Cloud Control to monitor Oracle Linux Virtualization Manager and its constituent parts. A comprehensive set of predefined performance and health metrics enables automated monitoring of the Oracle Linux Virtualization environment. Because all OLV components are full-fledged Enterprise Manager targets, monitoring an OLV Manager instance lets you monitor out-of-box metrics for all sub-components.

    For more information, see Monitoring Oracle Linux Virtualization Infrastructure Cloud in the Oracle Enterprise Manager Cloud Administration Guide.

Middleware Management

This section describes new features and enhancements for Middleware Management.

  • Certification Information: Oracle Enterprise Manager Cloud Control 13.4 has added support for Oracle Fusion Middleware 12.2.1.4.0.
    For more information on the products supported by Oracle Enterprise Manager in 13.4:
    1. Sign in to My Oracle Support and click the Certifications tab.
    2. In the Certification Search region, select one of the following from the Product list:
      • Enterprise Manager Base Platform - OMS, to view the certification for OMS.
      • Enterprise Manager Base Platform - Agent, to view the certification for Management Agent.
    3. From the Release list, select the release you are interested in and click Search.

Enterprise Manager Mobile

Oracle Enterprise Manager Mobile can now be downloaded from the App Store® for Apple mobile devices and from Google Play for Android mobile devices.

You can use the Enterprise Manager Mobile application to perform incident management for the entire IT infrastructure managed by Enterprise Manager.

For more information, see Oracle Enterprise Manager Mobile.