Top 60 Oracle Blogs

Recent comments

What’s New with the Latest Release

Yesterday I posted notification of the latest plug-in releases for Enterprise Manager There have been quite a number of enhancements in these new plug-ins, so let’s have a quick look at each plug-in and what’s new.

Enterprise Manager for Cloud (version

PDB as a Service Custom Placement Option

Customers often want to place PDBs that host data of similar applications inside a single CDB. Doing this ensures a flavor of consolidation with intelligent resource utilization. PDB as a Service (PDBaaS) now provides this capability through a specific service template option. In this mode, at request submission time SSA users can specify a particular CDB from the pool members to host the PDB being created.

Data Lifecycle Management

The SSA administrator can now manage the complete lifecycle of the source data including:

  • Capturing data on demand or on a specific schedule
  • Refreshing the data and creating new revisions of the profile
  • Specifying a purge policy
  • SSA users can choose to refresh the service instance when a new revision is available.

Ability to Add and Remove Physical Stand By Databases from the SSA Target Homepage

The topology of a complete database system architecture (for example a primary RDBMS instance along with multiple physical standby databases) is defined in the service template by the SSA administrator. If the Enable Standby Locking option is selected, users can use this template to provision a primary database, then later when required they can submit a request to add or remove one or more standby databases to the existing service instance. In addition, while submitting a new provisioning request from the SSA portal users are offered the flexibility of choosing the standby databases to be created from the topology.

Alternatively, to enforce deployment standardization, if the option is locked then any provisioning using this service template will create and delete the primary database as well as all the defined standby databases at once.

Ability to Specify Various Database Sizes for Provisioning

By specifying and grouping database attributes, administrators can now create database size templates that users can select when they submit a database provisioning request. The database size (for example small, medium, large) is determined by a combination of the following four attributes:

  • CPU
  • Memory
  • Storage
  • Number of processes

This feature enables SSA provisioned databases to adhere to specific configuration standards as selected in the service template.

Live Clone

During provisioning this feature is intended to be used for migrating existing databases under the Oracle PaaS umbrella. The service template in this case refers to a live RDBMS instance being monitored by Oracle Enterprise Manager rather than any data profile.

Service Template Changes

While creating a service template, the self service administrator can now specify values for target properties such as Contact, Location, Line of Business, and so on, lock these properties, and mark them as mandatory. While creating a database, the self service user must specify values for all of the mandatory properties.

Enterprise Manager for Oracle Cloud Framework (version

The Common Self Service Framework enables self service administrators to manage and monitor all cloud services from a single interface. Managing the private cloud is now more intuitive and easy across the different service families such as MWaaS and DBaaS. The SSA framework also acts as a gateway between Enterprise Manager and other public cloud management solutions (for example Oracle Public Cloud) to provide a seamless experience to cloud users.

Enterprise Manager for Storage Management (version

Support for Snap Clone on EMC Storage

Enterprise Manager Cloud Control now supports Snap Clone on the EMC Symmetrix VMAX family and EMC VNX storage appliances. Using an EMC Symmetrix VMAX Family or EMC VNX storage enables you to create thin volumes and ASM disks out of the created thin volumes.

NetApp 8 Cluster Mode Hardware Support for Snap Clone

Enterprise Manager Cloud Control 12c now enables NetApp 8 hardware in cluster mode (c-mode) to support Snap Clone.

Enterprise Manager for Oracle Database (version

Transparent Data Encryption Enhancements

The Transparent Data Encryption feature now supports a third type of key store with the introduction of Oracle Key Vault. This addition helps users configure their key store on an Oracle Key Vault server. The updated Configure Key Store wizard enables you to select Oracle Key Vault as a key store type for managing Master keys used for Data Encryption. Migration and reverse migration operations from Wallet to Oracle Key Vault and vice-versa are also now supported.

Support for Sensitive Column Types and Custom Data Redaction Formats in Oracle Data Redaction Policies

Enterprise Manager can now use Sensitive Column Types to suggest suitable Oracle Data Redaction formats to redact the data present in a table or view column. Also, Enterprise Manager enables users to create, save, and reuse custom Oracle Data Redaction formats.

Out of Place Patching for DBaaS and Software Standardization for the Data Center

Database administrators must maintain the cloud and apply minor updates, for example Patch Set Updates (PSUs) and Critical Patch Updates (CPUs), and major updates, for example patch set or major version updates. This update enables administrators to standardize and maintain the cloud infrastructure by enabling them to apply major and minor updates seamlessly.

DBaaS Pool Patching Mechanism

The DBaaS pool patching mechanism enables process pools to subscribe to database and GI images. New images are automatically deployed to servers in the pool. Self service users or administrators can choose to migrate databases to the new home. This update enables subscription based, mass scale out of place patching and upgrades with reduced downtime. It provides flexibility to users to move to new software versions on their terms and to track compliance across cloud and non-cloud environments.

Software Standardization Advisor

The Software Standardization Advisor detects configuration variances in applied patch levels among existing databases and recommends new standardized configurations to consolidate and reduce the variations among the database fleet. It also recommends software configurations to standardize the database. This helps to reduce the proliferation of software variances based on patch levels across the existing database fleet.

Data Lifecycle Management

Enterprise Manager Cloud Control now supports enhanced methods of cloning databases. You can use the new Clone and Refresh page to create a Full Clone database, a Snap Clone database, and a CloneDB database. Data masking and custom SQL script execution is integrated in this single flow along with inline patching capability. The new Clone and Refresh page also enables administrators to refresh, manage, and promote clone databases to Test Master databases.

Zero Data Loss Recovery Appliance Plug-in Features

Zero Data Loss Recovery Appliance is a ground-breaking data protection solution that is completely integrated with Oracle Database and easily protects all databases in the data center with a massively cloud-scaled architecture. Enterprise Manager for Zero Data Loss Recovery Appliance provides comprehensive management and monitoring of Recovery Appliance operations, enabling complete control of the data protection lifecycle.

Enterprise Manager for Oracle Fusion Middleware (version

Fusion Middleware Provisioning Enhancements

The Fusion Middleware Plug-in includes the following enhancements:

  • The ability to clone SOA domains from source to destination environment.
  • A detailed view of the WebLogic domain-based provisioning profile has been included. If you select a WebLogic domain profile, you may see some or all of the following details depending on the product family the domain belongs to: servers, data sources, JMS servers, and authentication providers.
  • The Provision Fusion Middleware deployment procedure now supports Typical and Advanced modes of provisioning. You are encouraged to start with the default Typical mode. However, if you want the ability to customize a wide range of parameters for the destination domain (for example listener address, port values, JMS configuration), you can leverage the Advanced mode.
  • RESTful Web Services-based API support for listing, describing, and deleting SOA and OSB profiles has been included.
  • EM CLI support for listing, describing, and deleting SOA and OSB profiles has been included.
  • Support for provisioning multi-node WebCenter Portal environments has been introduced.
  • Support for scaling out a WebCenter domain is now available.
  • Support for creating a WebCenter-based provisioning profile has been introduced.
  • EM CLI support for listing, describing, and deleting WebCenter based provisioning profiles has been introduced.
  • RESTful Web Services-based API support for listing, describing, and deleting WebCenter based profiles has been added.

Support for SOA as a Service and OSB as a Service

Beginning with Fusion Middleware Plug-in, support for SOA as a Service (SOAaaS) and OSB as a Service (OSBaaS) has been included as a part of the Oracle Middleware as a Service (MWaaS) family. Now self service administrators can use the Enterprise Manager Cloud Control console to create SOA and OSB zones, pools, and service templates. Using these service templates, self service user can request a new OSB service or SOA service and provision the respective resource. Support to create this service request has been embedded into the Self Service Portal.This release also includes RESTful Web Services-based API support for SOAaaS and OSBaaS.

Common Self Service Framework

The common self service framework is now used to manage and monitor the Web Logic Server cloud service.

Oracle Site Guard Enhancement

This plug-in includes the following enhancements for Oracle Site Guard:

  • Customize Prechecks – Enhance the Prechecks and Health Checks performed by Oracle Site Guard by adding your own Custom Precheck scripts. Use this feature to customize and improve the Prechecks and Health Checks that precede any operation plan.
  • Add User Scripts to Oracle Enterprise Manager’s Software Library – Add your own scripts to Oracle Enterprise Manager’s software library and use them in Oracle Site Guard work flows. This leverages the ability of Oracle Site Guard to automatically deploy the scripts at runtime, thereby eliminating the need to manually pre-deploy your scripts on the hosts where they need to run.
  • Configure Custom Credentials for Script Execution – Configure an alternate set of credentials for executing any configured script. This allows you to execute scripts using credentials that are different than the credentials configured for the script host.
  • Provide Credentials as Parameters to Scripts – Provide one or more credentials as parameters for configured scripts. This allows you to securely pass credentials to any configured script when the script needs to perform additional authentication functions.
  • Stop the Primary Site during a Failover Operation – Configure Oracle Site Guard to optionally stop the primary site during a failover operation. Oracle Site Guard attempts to stop the primary site components on a
    best effort basis before failing over to the standby site.
  • Clone Operation Plans and Script Configuration – Using the Create Like feature, create new operation plans and script configurations by cloning existing ones. This saves time during configuration, especially when the new operation plan or script being created is very similar to an existing plan or script.
  • Support for Oracle Fusion Middleware 12c – Protect your Oracle Fusion Middleware 12c deployment using Oracle Site Guard.
  • Support for Oracle Database 12c – Protect your Oracle Database 12c deployment using Oracle Site Guard.

Enterprise Manager for Oracle Audit Vault and Database Firewall (version

This version of the Audit Vault and Database Firewall plug-in automates many of the complicated tasks required to add Audit Vault agents and sources.

So there you have it! A lot of enhancements to look at, and no doubt I’ll add separate more detailed blog posts on some of these over the coming few weeks, so watch this space!