14 ­­Getting Started with Database as a Service

This chapter describes the procedure to different DBaaS use cases supported in this release. It contains the following sections:

14.1 Supported DBaaS Use Cases

The following figure provides an overview of the different flavors of Enterprise Manager DBaaS.

Figure 14-1 DBaaS Use Cases

Surrounding text describes Figure 14-1 .

This table lists the DBaaS use cases that are supported in this release and lists the different methods (GUI, EMCLI, and Rest API) that can be used to run these use cases.

Table 14-1 DBaaS Use Cases

Service Type Service Offering Using Graphical User Interface Using EMCLI Using Rest API

New

Creating Databases Using Database Template.

Chapter 15, "Creating Databases Using Database Template"

Section 49.2, "Creating Databases Using Database Template With REST APIs and EM CLI Verbs"

Section 49.2, "Creating Databases Using Database Template With REST APIs and EM CLI Verbs"

 

Schema

  • Creating an Empty Schema

  • Creating a Schema Based on Profile

Chapter 16, "Creating Schemas"

Section 49.3, "Creating Empty Schemas and Schemas Based on Profile With REST APIs and EM CLI Verbs"

Section 49.3, "Creating Empty Schemas and Schemas Based on Profile With REST APIs and EM CLI Verbs"

 

Pluggable Database

  • Creating an Empty Pluggable Database

  • Creating a Pluggable Database Based on Profile

Chapter 17, "Provisioning Pluggable Databases"

Section 49.4, "Creating Empty PDBs and PDBs Based on Profile With REST APIs and EM CLI Verbs"

Section 49.4, "Creating Empty PDBs and PDBs Based on Profile With REST APIs and EM CLI Verbs"

Clone

Full Clone

  • Cloning Databases Using RMAN Backup

  • Cloning Databases Using RMAN Duplicate

Chapter 19, "Creating Full Clones"

Section 49.7, "Creating Full Database Clones Using RMAN With REST APIs and EM CLI Verbs"

Section 49.7, "Creating Full Database Clones Using RMAN With REST APIs and EM CLI Verbs"

Snap Clone

  • Software Solution

    Sun ZFS

    Clone DB

  • Hardware Solution

    ZFS File System

    NetApp

    EMC

Section 20, "Creating Snap Clones"

Section 49.6, "Creating Databases Using Snap Clone With REST APIs and EM CLI Verbs"

Section 49.6, "Creating Databases Using Snap Clone With REST APIs and EM CLI Verbs"


14.2 Getting Started with DBaaS

To get started with database as a service, follow these steps:

  1. From the Enterprise menu, select Cloud, then select Cloud Home. The following page appears:

    Figure 14-2 Cloud Home Page

    Oracle Cloud Home
  2. From the Oracle Cloud menu, select Setup, then select Getting Started. You must first perform the common setup tasks as described in Section 11.2, "Common Setup Tasks". This page is the main entry point for setting up database as a service.

  3. Click the Setup link next to the Database Service Family in the left panel. Select one of the service types (Database, Pluggable Database, or Schema) from the drop down list and perform the necessary tasks required for the selected service type.

    Figure 14-3 Getting Started with DBaaS

    Surrounding text describes Figure 14-3 .
  4. Depending on your selection, the list of tasks can be different. Any step that has been configured is marked with a green check mark and the non-configured are listed as not configured.

    Note:

    The service types you can access are based on your user role. For example, if you have logged in as a user (for instance DBAAS_ADMIN) who can access only Database service type, you will see only the tasks relevant to that service type. But if you have logged in as a user with the EM_SSA_ADMINISTRATOR role, you can view all the service types. See Section 3.3, "Defining Roles and Assigning Users" for more details.
  5. Depending on the service type you wish to configure, you can perform the relevant tasks required to set up that service type.