Table of Contents
- Title and Copyright Information
- Preface
- Part I Cloud Management Overview
-
Part II Setting Up and Enabling Cloud
-
2
Setting Up the Cloud Management Infrastructure
- Setting Up Self Update
- Deploying the Required Plug-ins
- Defining Roles and Assigning Users
- Configuring LDAP Authentication
- Configuring Privilege Delegation Settings
- Customizing the Self Service Login Page
- 3 How to Enable Cloud
-
2
Setting Up the Cloud Management Infrastructure
- Part III Direct Monitoring
-
Part IV Setting Up and Using Platform as a Service
- 5 Setting Up the PaaS Infrastructure
-
6
Enabling the DBaaS Cloud
- Getting Started
- Setting Up Credentials for Provisioning
- Provisioning Database Software for Database as a Service
- Provision the Database for Schema as a Service
- Provision a Container Database for PDB as a Service
- Configuring the Oracle Listener
- Registering and Managing Storage Servers
-
Part V Provisioning New Database Artifacts
- 7 Getting Started with Database as a Service
-
8
Creating Databases Using Database Template
-
Creating Databases Using Database Template
- Creating Resource Providers
- Creating a Database Provisioning Profile Using Database Template
- Creating a Container Database Provisioning Profile Using Database Template
- Configuring Request Settings
- Defining Quotas
- Creating a Service Template Using Database Template Profile
- Creating a Service Template Using Database Template Profile for Container Database
- Configuring Chargeback
- Requesting a Database
- Provisioning Standby Databases
-
Creating Databases Using Database Template
-
9
Provisioning Pluggable Databases
- Getting Started
- Creating Resource Providers
- Creating a Database Provisioning Profile Using Export Schema Objects
- Creation of SSA User Data Profile for Pluggable Database - Dehydrate of PDB by SSA User
- Configuring Request Settings
- Defining Quotas
- Creating a Service Template for PDB Based on Profile
- Creating a Service Template for an Empty PDB
- Creating a Service Template Using a Data Profile Selected by an SSA User At Request Time
- Configuring Chargeback
- Requesting a Pluggable Database
- Pluggable Database creation using SSA User Data Profile - Hydrate PDB
- Enabling a Test Master Pluggable Database
- Disabling a Test Master Pluggable Database
-
10
Creating Schema
- Getting Started
- Creating Resource Providers
- Creating a Database Provisioning Profile Using Export Schema Objects
- Configuring Request Settings
- Defining Quotas
- Creating a Service Template for Schema Based on Profile
- Creating a Service Template with Empty Schema
- Configuring Chargeback
- Requesting a Schema
-
Part VI Cloning Databases
- 11 Supported Cloning Options
-
12
Creating Full Clones
- Creating a Full Database Clone Using RMAN Backup from the Self Service Portal
- Creating a Full Database Clone Using RMAN Duplicate from the Self Service Portal
-
13
Creating Snap Clones
- About Snap Clones
- About Data Lifecycle Management
- Creating Test Master Pluggable Databases and Snapshot Clones
-
Creating Snap Clones from the Cloning Dashboard
- Creating a Snap Clone Database
- Creating a Test Master Database
- Enabling a Test Master Database
- Disabling a Test Master Database
- Creating a Test Master Pluggable Database
- Creating a CloneDB Database
- Managing Clone Databases
- Refreshing Clone Databases
- Creating a Snapshot Clone of an Exadata Test Master Database
-
Creating Snap Clones from an In-Sync Test Master
- Getting Started
- Registering Storage Servers
- Creating Resource Providers
- Configuring Request Settings
- Defining Quotas
- Using a Physical Standby Database as a Test Master
- Enabling the Test Master for Snap Clone
- Creating a Database Provisioning Profile Using Snapshots
- Creating Service Template Using Snap Clone Profile
- Configuring Chargeback
- Requesting a Database
- Example: Creating Snap Clones from an In-Sync Test Master
-
Creating Snap Clones from a Discretely Synchronized Test Master
- Getting Started
- Registering Storage Servers
- Creating Resource Providers
- Configuring Request Settings
- Defining Quotas
- Creating a Discretely Synchronized Test Master
- Creating a Service Template Using Snap Clone Profile
- Configuring Chargeback
- Requesting a Database
- Refreshing the Test Master Database
- Refreshing the Snap Shot Profile
- Example: Creating Snap Clones from Discretely Synchronized Test Master
- Creating a CloneDB Database
-
14
Using the DBaaS Self Service Portal
- About the Database Cloud Self Service Portal
- Provisioning of Database using Database Cloud Self Service Portal
- Requesting a Database
- Refresh an RMAN Database
- Viewing the History of a Request
- Database Service Home Page
- Database Instance Home Page
- Standby Database Home Page
- Cluster Database Home Page
- Pluggable Database Home Page
-
Part VII Maintaining and Customizing Databases
- 15 Maintaining the Database Pool
- 16 PDBaaS Fleet Operations
-
17
Customizing Database as a Service
-
Pre and Post Request Creation / Deletion Scripts
- Selecting the Post SQL Script
- Sample Scripts
-
Input Parameters for Pre and Post Database Scripts
- Input Parameters for DBaaS Pre and Post Request Creation Scripts
- Input Parameters for DBaaS Pre and Post Request Deletion Scripts
- Input Parameters for DBaas Pre and Post Custom Scripts when Provisioning a Standby DB
- Input Parameters for SchaaS Pre and Post Request Creation Scripts
- Input Parameters for SchaaS Pre and Post Request Deletion Scripts
- Input Parameters for PDBaaS Pre and Post Request Creation Scripts
- Input Parameters for PDBaaS Pre and Post Request Deletion Scripts
- Sample Input Files
- Sample PDBaaS Post Scripts
-
Pre and Post Request Creation / Deletion Scripts
- 18 DB Onboarding on DBaaS Cloud
- 19 DB Relocation
- 20 PDB Onboarding on DBaaS Cloud
- 21 PDB Relocation
- 22 PDB Instance Resize
- 23 PDB Upgrade using Fleet Maintenance
-
Part VIII Monitoring the PaaS Cloud
-
24
Administering and Monitoring a PaaS Cloud
- Viewing the Cloud Home Page
- Viewing the List of Resource Providers
- Viewing the List of Service Templates
- Viewing the List of Service Instances
- Viewing the Cloud Request Dashboard
- Viewing All Cloud Requests
- Viewing the PaaS Infrastructure Zone Home Page
- Viewing the Database Pool Home Page
- Viewing the Schema Pool Home Page
- Viewing the Pluggable Database Pool Home Page
- Viewing the Middleware Pool Home Page
- Viewing the Cloud Services Reports
-
24
Administering and Monitoring a PaaS Cloud
-
Part IX Dynamic Resource Provisioning
-
25
Dynamic Resource Provisioning with Oracle VM Server for SPARC
- Integration for a PaaS Solution
- Configure Resources for vDC
- Set Up and Configure a Virtual Data Center
- Validate the Integration and PaaS
- 26 Getting Started with Dynamic Resource Provisioning
- 27 Dynamically Provisioning Resources in a DBaaS Cloud
-
25
Dynamic Resource Provisioning with Oracle VM Server for SPARC
-
Part X Using Chargeback
-
28
Chargeback Administration
- Overview of Chargeback
-
Setting Up Chargeback
- Configuring Global Settings for Chargeback
-
Working with Charge Plans
- Charge Plans and Effective Dates
- Charge Plans and Peak Windows
- Charge Plans and Tiered Pricing
- Creating and Revising the Universal Charge Plan
- Creating an Extended Charge Plan
- Viewing Charge Item Metadata
- Using Conditions in Charge Plans
- Using the Estimate Charges Feature
- Revising Extended Charge Plans
- Using the Plan Advisor
- Creating Cost Centers
- Adding Entities to Chargeback
- Assigning Cost Centers to Entities
- Assigning Charge Plans to Entities
- Running the Daily Data Collection Job
- Self Service Applications and Zones within Chargeback
- Accessing Chargeback Information
- 29 Chargeback for Oracle Cloud Infrastructure
-
28
Chargeback Administration
-
Part XI Using the Cloud APIs
- 30 Introduction to Cloud APIs
-
31
Cloud Resource Models
- Enterprise Manager Cloud Resource Model 10001
- About Cloud Resources
-
Resource Data Models
- Cloud [application/oracle.com.cloud.common.Cloud+json]
- ServiceTemplate [application/oracle.com.cloud.common.ServiceTemplate+json]
- Zone [application/oracle.com.cloud.common.Zone+json]
- Service Family Type [application/oracle.com.cloud.common.ServiceFamilyType+json]
- Service Instance Type [application/oracle.com.cloud.common.InstanceType+json]
- Metric [application/oracle.com.cloud.common.Metric+json]
- Service Instance [application/oracle.com.cloud.common.ServiceInstance+json]
- Quota Usage [application/oracle.com.cloud.common.QuotaUsage+json]
- Service Template Finds [application/oracle.com.cloud.common.ServiceTemplateFinds+json]
- Cloud REST API Examples
- Service Request REST APIs
- Service Request Collection
-
32
EM CLI Verbs for Database as a Service Administrator
- PaaS Zone EM CLI Verbs
- Software Pool EM CLI Verbs
- Database Quota EM CLI Verbs
- Database Request Settings EM CLI Verbs
- Database Size EM CLI Verbs
-
Database Profile EM CLI Verbs
- About Database Provisioning Profile Types
- Creating Provisioning Profiles using EM CLI
- Sample EM CLI Property Files
- Database Profile EM CLI Verbs
- Creating a Database Profile Using EM CLI Verbs
- Editing a Database Profile Using EM CLI Verbs
- Deleting a Database Profile Using EM CLI Verbs
- Viewing All the Database Profiles
- Refreshing a Database Profile Using EM CLI Verbs
- Service Template EM CLI Verbs
- Pluggable Database Profile EM CLI Verbs
-
Service Template Executable .json Files
- DBCA Based Service Template .json File
- DBCA Template Structure-only Profile .json
- Standby DBCA Based Service Template .json File
- RMAN Based Single Instance Database Service Template .json File
- RMAN Based Single Instance Database with Single Instance Standby Service Template .json File
- RMAN Based RAC One Node Database Service Template .json File
- RMAN Based RAC One Node Database with Standby Service Template .json File
- RMAN Based RAC Database with Single Instance Standby Service Template .json File
- RAC Database with Standby Using a DBCA Template Service Template .json File
- DNFS Based Database Service Template .json File
- Snap Clone Single Instance Database with Archiving Enabled Service Template .json File
- Schema Based Service Template .json File
- Pluggable Database Service Template .json File
- RAC Pluggable Database Using an Empty Pluggable Database Service Template .json File
- RAC Pluggable Database Using a Profile Pluggable Database Service Template .json File
- Clone DB Based Service Template .json File
- Full Clone Using an RMAN Duplicate Service Template .json File
- Snapclone Database Using Live Clone Template on EMC Storage Service Template .json File
- Creating a Database Clone Using EM CLI Verbs
- Refreshing a Database Using EM CLI Verbs
- Deleting a Database Using EM CLI Verbs
- Deleting a Database Clone Using EM CLI Verbs
- Database Fleet Maintenance EM CLI Verbs
- Database Request Handling EM CLI Verbs
- Cloning a Pluggable Database
- Creating a Test Master Pluggable Database
- Transferring Data Between Databases
- Backing Up Datafiles and Metadata of a Pluggable Database
- Importing Data from Export Dumps to a Database
- Using the db_clone_management EM CLI Verb
- Invoking a REST API Using EM CLI Verb
-
33
Database as a Service Administrator REST APIs
- Summary of Database as a Service Administrator REST APIs
- Creating a New DBaaS Cloud Setup Using REST APIs
-
Database as a Service Administrator Operations REST APIs
- PaaS Zones and PaaS Zone REST APIs
-
Software Pools and Software Pool REST APIs
- Software Pools
- Software Pool
-
Software Pool REST API Examples
- Viewing Details of the Software Pools Resource
- Viewing Details of a Software Pool Resource
- Viewing Details of a Software Pool Capacity
- Creating a Database Pool
- Updating a Database Pool
- Creating a Schema Pool
- Updating a Schema Pool
- Creating a Pluggable Database Pool
- Updating a Pluggable Database Pool
- Deleting a Database / Schema / Pluggable Database Pool
- Database Request Settings REST APIs
- Database Quota REST APIs
-
Service Template REST APIs
- Service Templates Resource
- Service Template Resource
-
Service Templates and Service Template REST API Examples
- Viewing Details of the Service Templates Resource
- Viewing Details of the ServiceTemplate Resource
- Creating a Service Template for DBCA Based Database
- Creating a Service Template for RMAN Based Single Instance Database
- Creating a Service Template for RMAN Based Single Instance Database with Single Instance Standby
- Creating a Service Template for RMAN Based RAC One Node Database
- Creating a Service Template for RMAN Based RAC One Node Database With Standby
- Creating a Service Template for RMAN Based RAC Database With Standby
- Creating a Service Template for RAC Database with Standby Using a DBCA Template
- Creating a Service Template for DNFS Based Database
- Creating a Service Template for Snap Clone Single Instance Database (with Archiving Enabled)
- Creating a Service Template for Snap Clone Single Instance Database (without Archiving Enabled)
- Creating a Service Template for a Schema
- Creating a Service Template for a Pluggable Database
- Creating a Service Template for RAC Pluggable Database Using an Empty Pluggable Database
- Creating a Service Template for RAC Pluggable Database Using a Profile Pluggable Database
- Deleting a Database / Schema / Pluggable Database Service Template
- DB Onboarding on DBaaS Cloud REST API
- DB Relocation REST API
- PDB Onboarding on DBaaS Cloud REST API
- PDB Relocation REST API
- PDB Upgrade REST API
- Pluggable Database Profile REST API Examples
-
34
Database as a Service SSA User REST APIs
- Summary of Database as a Service SSA User REST APIs
-
Database as a Service
- Database as a Service Resource Model
- Supported Operations for Database as a Service Resources
-
Database as a Service REST API Examples
- Viewing Details of All the Cloud Resources
- Filtering Output for Specific Resource Attributes
- Viewing Details of the Service Family Type Resource
- Viewing Details of the Service Instance Type Resource
- Viewing Details of a Service Requests Resource
- Viewing Details of the DB Zone
- Viewing Details of the DB Platform Template Resource
- Creating a Database Instance
- Viewing the Database Creation Details
- Updating a Database
- Deleting a Database Instance
- Lifecycle operations on a Database Instance
- Lifecycle operations on a Snap clone Database Instance
-
Schema as a Service
- Schema as a Service Resource Model
- Supported Operations for Schema as a Service Resources
- Schema as a Service REST API Examples
-
Pluggable Database as a Service
- Pluggable Database as a Service Resource Model
- Supported Operations for Pluggable Database Resources
- Pluggable Database as a Service REST API Examples
-
35
DBaaS REST APIs and EM CLI Verbs Based Use Cases
- Getting Started with DBaaS With REST APIs and EM CLI Verbs
- Creating Databases Using Database Template With REST APIs and EM CLI Verbs
- Creating Empty Schemas and Schemas Based on Profile With REST APIs and EM CLI Verbs
- Creating Empty PDBs and PDBs Based on Profile With REST APIs and EM CLI Verbs
- Migrating/Transferring Data from One Database to Another
- Creating Databases Using Snap Clone With REST APIs and EM CLI Verbs
- Creating Full Database Clones Using RMAN With REST APIs and EM CLI Verbs
- Configuring Custom Database Placement Option Using REST APIs
- Service Catalog of Database as a Service
-
36
SSA Administration REST APIs
- Summary of SSA Administration REST APIs for V2
- Summary of SSA Administration REST APIs for V1
- Catalog APIs for V1 and V2
-
Resource Provider for V2
- Resource Providers - Collection Resource for V2
- Resource Provider - Singular Resource for V2
- Supported Methods for Resource Provider Resource
-
Resource Provider REST API Examples
- Viewing all the Resource Providers
- Viewing all the Types of Resource Providers
- Creating a Resource Provider
- Creating a PaaS Infrastructure Zone Resource Provider
- Creating a Database Schema Pool
- Creating an Adapter Instance
- Filtering Resource Provider Targets
- Viewing the Resource Provider Type Metadata
- Viewing the Metadata for Creating a PaaS Infrastructure Zone
- Viewing the Metadata for Creating a Schema Pool
- Viewing Details of the Resource Provider
- Updating a Resource Provider
- Deleting a Resource Provider
- Viewing Configuration of a Resource Provider
- Viewing Metric of a Resource Provider
- Provisioning a Resource via a Sample Adapter
- De-provisioning a Resource
- Viewing the Metadata Required to Provision a Resource Provider
-
Service Templates - Collection Resource for V2
- Supported Operations
-
Service Templates REST API Examples for V2
- Viewing all the Service Templates
- Viewing all the Service Template Types
- Viewing the Metadata Required for Creating a Service Template
- Viewing the Resource Provider Characteristics Required for Creating a Service Template
- Viewing Configurations Required for Creating a Service Template
- Creating a Service Template
- Updating a Service Template
- Viewing Details of a Specific Service Template
- Viewing Configuration Details of a Specific Service Template
- Deleting a Service Template
- Creating a Service Template in V2
- Service Types for V2
- Service Requests for V2
- Service Instances for V2
-
Request Settings for V2
- Request Settings Data Model
- Request Settings Composite Attribute Data Model
-
Request Settings REST API Examples for V2
- Viewing Details of the Global Request Settings
- Updating the Global Request Settings
- Viewing Details of the Global Request Settings for a Collection of Roles
- Creating Global Request Settings for a Role
- Viewing Details of Global Request Settings for a Specific Role
- Updating Global Request Settings for a Specific Role
- Deleting Global Request Settings for a Specific Role
- Viewing Details of the Request Settings for a Service Family
- Updating the Request Settings for a Service Family
- Viewing Details of the Service Family Settings by Roles
- Creating Service Family Settings for a Role
- Viewing Details of the Service Family Request Settings for a Specific Role
- Updating the Service Family Request Settings for a Specific Role
- Deleting Service Family Request Settings for a Specific Role
- Viewing Details of the Request Settings for a Service Type
- Updating the Request Settings for a Service Type
- Viewing Details of the Service Type Settings by Roles
- Creating Service Type Settings for Roles
- Viewing Details of the Service Type Request Settings for a Specific Role
- Updating the Service Type Request Settings for a Specific Role
- Deleting Service Type Request Settings for a Specific Role
- VM Adapters for V2
- SSA Admin Resources for V1
- PaasZones for V1
- PaasZone for V1
- SoftwarePools for V1
- SoftwarePool for V1
- Composite Resource Attributes for V1
- Service Template Management for V1
- EM CLI Verbs for Self Service Applications
-
37
SSA Portal Management REST APIs
- Summary of SSA User REST APIs for V2
- Summary of User REST APIs for V1
- Common REST Entities for V2
- Catalog APIs
- Service Types for V2
- Services for V2
-
Service Requests REST APIs for V1 and V2
- Service Requests Resource for V2
- Service Request Collection - Collection Resource for V1
- Supported Operations for Service Requests
-
Service Request REST API Examples for V1 and V2
- Retrieving Top Level View of Service Requests in V1 and V2
- Querying the Service Requests Resource for Status=SUCCESS in V2
- Querying the Service Requests Resource for Expanded=true and Expanded=false in V2
- Querying the Service Requests Resource for status=SUCCESS&expanded=false and status=SUCCESS&expanded=true in V2
- Viewing Details of a Service Request in V2
- Deleting a Service Request in V2
- Rescheduling a Service Request that is in a Scheduled State in V1 and V2
- Viewing the Logs of a Service Request in V2
- Querying the Logs of a Service Request in V2
- Retrieving Top Level View of Service Requests for a Specific Service Family in V1
- Retrieving Top Level View of Service Requests for a Specific Status in V1
- Rescheduling a Service Request that is in a Cancelled State (or in a state other than Scheduled) in V1
- Deleting a Service Request that is in a Scheduled State in V1
- Deleting a Service Request that is in a Canceled State (or in a state other than scheduled) in V1
-
Service Instances for V2
- Supported Methods for Service Instance in V2
-
Service Instances REST API Examples for V2
- Viewing Details of the Service Instance Resource in V2
- Querying the Service Instance Resource in V2
- Viewing Details of a Service Instance in V2
- Viewing Details of the Attributes of a Service Instance in V2
- Viewing Details of the Available Actions on a Service Instance in V2
- Viewing Details of the Action Inputs Required To Execute an Action on a Service Instance in V2
- Executing an Action on a Service Instance in V2
- Executing Actions on a Service Instance in V2
- Quota Usage for V2
-
User Preferences for V2
- Supported Request Methods for User Preference Resource in V2
-
User Preferences for V2 REST API Examples
- Viewing Details of the User Preferences Resource for V2
- Viewing Details of the General User Preferences Resource for V2
- Viewing Metadata of the General User Preferences Resource for V2
- Updating the General User Preferences for V2
- Viewing Details of the Services User Preferences Resource for V2
- Viewing Details of the Service Family User Preferences Resource for V2
- Viewing Metadata of the Service Family User Preferences for V2
- Updating the Service Family User Preferences for V2
- Viewing Details of the Service Type User Preferences Resource for V2
- Viewing Metadata of the Service Type User Preferences for V2
- Updating the Service Type User Preferences for V2
- User Preferences for V1
- Composite Resource Attributes for V1
- Supported Methods for General Preferences (for V1)
- Service Specific User Preferences for V1
- 38 Chargeback and Metering EMCLI Verbs
- Index