4 Cloud Management

This chapter describes the Cloud Management pack offered by Enterprise Manager.

Out-of-the-box cloud licenses are granted to already existing targets on which licenses are defined and whenever new targets are discovered the packs are granted automatically. Verify license access information by clicking Setup, Management Packs, then Management Pack Access.

Oracle Cloud Management Pack for Oracle Database

Oracle Cloud Management Pack for Oracle Database helps to set up a Database Cloud and operate the Database as a Service (DBaaS) model. The following table describes this management pack offered by Enterprise Manager:

Management Pack Type of Licensing Information Licensing Information

Oracle Cloud Management Pack for Oracle Database

Prerequisites

The Oracle Cloud Management Pack for Oracle Database requires the Database Lifecycle Management Pack for Oracle Database.

Oracle Cloud Management Pack for Oracle Database

Feature Summary

The Oracle Cloud Management Pack for Oracle Database provides the following features:

  • Out-of-box Self Service Portal that empowers users to easily provision and clone databases without IT intervention.

  • Self-service support that seamlessly spans hybrid and multicloud environments, including on-premises systems, ExaDB-C@C, ExaDB-D, and Oracle Cloud Infrastructure (OCI) Compute service. This simplifies management and enhances flexibility across a diverse deployment model.

  • Comprehensive deployment model that supports shared server (VM based), shared cluster, and Pluggable Database-as-a-Service (PDBaaS) deployment models.

  • Snap Clone - a fast, storage-agnostic, space-efficient approach to cloning Oracle Databases.

    This feature supports Oracle Databases including Pluggable databases (PDBs). Enterprise Manager support for Exadata Sparse Clone (Exadata on premsies, ExaDB-D, and ExaDB-C@C), CloneDB, ACFS Snapshot-based thin cloning of Multitenant, and thin cloning on ZFS storage appliance are included under the Snap Clone feature.

  • Data Refresh for Full Clones - the ability to refresh the data contained in full clones with the latest from production using newer RMAN backups or using RMAN duplicate. This feature significantly reduces the DBA time and effort.

    Note: The ability to create 'new' full clones is licensed under Database Lifecycle Management Pack for Oracle Database, but the additional 'refresh' function requires licensing the Cloud Management Pack for Oracle Database.

  • Administrative flows (non-self service) creates snap clones of source databases, including the ability to refresh the database while maintaining its name and configuration parameters.

  • Snap Clone using TestMaster Snapshots - TestMaster Snapshots represent a storage snapshot of RMAN Image BACKUP from a production database. This is used to create Storage-efficient clones with periodic data refresh capability.

  • Grouping of Cloud Infrastructure under the umbrella of 'PaaS Zone' and creation of Homogeneous Cloud Pool(s).

  • Governance - a role-based access and resource control through quotas and retirement policies.

  • Chargeback and Metering provides the ability to distribute IT costs to business based on fixed costs, utilization and configuration metrics. In addition, it provides the ability to identify peaks and trending for individual targets.

  • Programmatic access to the Self Service Portal through REST APIs and EMCLIs.

Oracle Cloud Management Pack for Oracle Database

Provisioning

Provision new databases and PDBs using DBaaS.

  • Create databases using database templates from the service catalog.

  • Create an empty PDB.

  • Create an empty PDB based on profile.

Oracle Cloud Management Pack for Oracle Database

Hybrid Pluggable-Database-as-a-Service

Provision Pluggable Databases (PDBs) on CDBs running in hybrid multicloud environments, which include:

  • On-premises machine

  • Exadata database machine

  • ExaDB-D

  • ExaDB-C@C

  • OCI Compute service

Oracle Cloud Management Pack for Oracle Database

Full Clone

Create full clones either by using profiles or from a live database.

  • Create a full database clone using RMAN Backup from the Self Service Portal.

  • Create a full database clone using RMAN Duplicate from the Self Service Portal.

Oracle Cloud Management Pack for Oracle Database

Snap Clone

Create snap clones either by using profiles or from a live database.

Storage agnostic approach to create rapid and space efficient clones of large databases. Clones of the production database are often required for test and development purposes, and it is difficult and time consuming to create these clones, especially if the databases are huge.

Self-service driven approach, which empowers the self-service user to clone databases as required on an ad hoc basis.

Enterprise Manager offers the following solutions with snap clone:

  • Software solution: ZFS file system clone database

  • Hardware solution: Sun ZFS Storage Appliance and Exadata Sparse Clone

The following is the list of procedures that can be performed to create and manage snap clone databases:

  • Create a snap clone database

  • Create a Test Master Database

  • Create a Test Master PDB

  • Create a Storage Test Master

  • Refresh clone databases

  • Create snap clones from discretely synchronized Test Master

  • Create snap clones from Storage Test Master

Oracle Cloud Management Pack for Oracle Database

DBaaS Self Service Portal

Database Self Service Portal allows self service users to view, monitor, and deploy databases on selected zones.

  • Request a database based on a selected service template.

  • Request a PDB based on a selected service template.

  • Refresh a database: Keep the data current and consistent with the production database by refreshing it on a regular basis.

  • Create a database service with one or more schemas and populate the schema with the required data.

  • Data Guard switchover: Role reversal between the primary database and one of its standby databases.

Oracle Cloud Management Pack for Oracle Database

Maintaining and Customizing Databases

Support for maintaining a database pool and ways to customize a database.

PDBaaS

Use EMCLI commands to perform PDBaaS fleet operations such as:

  • Prepare and subscribe to the Software Image

  • PDBaaS Pool Operations performed by SSA Admin

  • Update CDB

  • PDBaaS Pool Cleanup Operations

Customizing DBaaS

Pre and post request creation and deletion of scripts: Run custom scripts before and after a service instance has been created.

Database Onboarding on DBaaS Cloud

  • Perform Database Lifecycle Management operations like creating and deleting a database, startup and shutdown, backup and restore, patching and so on, using the Self Service Portal.

  • Perform onboarding on DBaaS cloud using an EMCLI command.

Database Relocation

  • Migrate an existing database to a new database software pool.

  • Perform relocation on DBaaS cloud using an EMCLI command.

PDB Onboarding on DBaaS Cloud

  • Perform Database Lifecycle Management operations such as creating and deleting PDBs, startup and shutdown, backup and restore, and patching using the Self Service Portal.

  • Perform PDB onboarding on DBaaS cloud using an EMCLI command.

PDB Relocation

  • Migrate an existing PDB to a new PDB software pool.

  • Perform PDB relocation on DBaaS cloud using an EMCLI command.

PDB Instance Resize

  • Resize an OEM DBaaS PDB instance by initiating a resize operation to a workload size defined in the corresponding service template.

  • Resize a PDB instance using an EMCLI command.

PDB Upgrade using Fleet Maintenance

  • Upgrade PDBs provisioned on Enterprise Manager DBaaS cloud.

  • Upgrade a PDB using an EMCLI command.

Oracle Cloud Management Pack for Oracle Database

Cloud APIs

  • Programmatic access to the Self Service Portal through REST APIs and EMCLIs.

  • Full support for cloud APIs and RESTful API for automation.

Oracle Cloud Management Pack for Oracle Database

Licensed Links

The following are the licensed pages and links for the Oracle Cloud Management Pack for Oracle Database:

  • Licensed actions

    From the Database home page, select the Database target menu. Select Cloning and then select Clone Management. On this page, these actions are licensed:

    Create Clone Databases

    Create Snap Clone Databases

    Create Snapshot Clone

    Promote as Test Master

    Remove from Test Masters

    Refresh

  • Oracle VM Infrastructure home page

    From the Enterprise menu, select Cloud, then Oracle VM Infrastructure Home.

  • Oracle VM Infrastructure Request Dashboard page

    From the Enterprise menu, select Cloud, then Oracle VM Infrastructure Request Dashboard.

  • Policies page

    From the Enterprise menu, select Cloud, then Policies.

  • Cloud Home page

    From the Enterprise menu, select Cloud, then Cloud Home.

  • Self Service Portal page

    From the Enterprise menu, select Cloud, then Self Service Portal.

  • Chargeback page

    From the Enterprise menu, select Chargeback.

  • Infrastructure page

    From the Setup menu, select Cloud, then select Infrastructure.

  • Database page

    From the Setup menu, select Cloud, then select Database.

  • Storage Registration page

    From the Setup menu, select Provisioning and Patching, then select Storage Registration.

Snap Clone

From the Enterprise menu:

  • Select Provisioning and Patching, then select Database Provisioning.

  • On the Database Provisioning page in the Related Links section of the left menu page, select Provision Pluggable Databases.

  • From the PDB Operations section, select Create New Pluggable Databases. Click Launch.

  • From the Pluggable Database Creation Options, select Clone an Existing PDB -> Snap Clone.

From the multitenant CDB home page:

  • From the Oracle Database menu, select Provisioning, and then select Provision Pluggable Database.

  • From the PDB Operations section, select Create New Pluggable Databases. Click Launch.

  • From the Pluggable Database Creation Options, select Clone an Existing PDB, and the select Snap Clone.

Oracle Cloud Management Pack for Oracle Database

Licensed RESTful APIs

The following RESTful APIs are licensed:

  • Assembly Operations

    Any POST/GET/PUT/DELETE on /em/cloud/iaas URI space for Resources Assembly Template and Assembly Instance.

  • Database and Schema Operations

    Any POST/GET/PUT/DELETE on /em/cloud/dbaas/ URI space.

  • DBaaS Setup Operations

    Any POST/GET/PUT/DELETE on /em/websvcs/restful/extws/cloudservices/admin/cfw/v1 URI space.

Oracle Cloud Management Pack for Oracle Database

Licensed EMCLI Verbs

The following EMCLI verbs are licensed under the Oracle Cloud Management Pack for Oracle Database:

add_pool_members cancel_cloud_service_requests create_charge_item create_dbaas_quota create_pool create_service_template db_cloud_maintenance db_software_maintenance delete_charge_item delete_cloud_service_instances delete_cloud_user_objects delete_dbaas_quota delete_pool delete_service_template deploy_rac_software deploy_db_software get_cloud_service_requests get_cloud_user_objects get_cloud_service_instances get_dbaas_quota get_dbaas_request_settings get_metering_data get_pool_capacity_data get_pool_capacity_summary_data get_pool_detail get_service_template get_pool_constraints get_pool_criteria get_pool_instance_data get_pool_target_type get_pools list_charge_item_candidates refresh_database remove_pool_members update_dbaas_request_settings update_dbaas_quota update_pool

Oracle Cloud Management Pack for Oracle Database

Licensed Views and Tables

The following objects within the repository schema are licensed under the Oracle Cloud Management Pack for Oracle Database:

  • Tables starting with EMCT_CBA.

  • Views starting with EMCT$CBA.

  • The views: 

    GP_EMCT_CBA_TARGET_CHARGE MGMT$EMCT_CBA_CHARGE_HOURLY MGMT$EMCT_CBA_CHARGE_DAILY

Oracle Cloud Management Pack for Oracle Database

Licensed Chargeback Reports

The following Oracle Analytics Server reports are licensed under the Oracle Cloud Management Pack for Oracle Database. Also, any report created using the "create-like" feature of Oracle Analytics Server referring the following reports, falls under this license.

  • Charge Trend Report

  • Charge Summary Report

  • Usage Trend Report

  • Usage Summary Report