18 ­­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:

• Supported DBaaS Use Cases

• Getting Started with DBaaS

Supported DBaaS Use Cases

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

Figure 18-1 DBaaS Use Cases

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 18-1 DBaaS Use Cases

Service Type	Service Offering	Using Graphical User Interface	Using EMCLI	Using Rest API
New	Creating Databases Using Database Template.	Creating Databases Using Database Template	Creating Databases Using Database Template With REST APIs and EM CLI Verbs	Creating Databases Using Database Template With REST APIs and EM CLI Verbs
-	Schema Creating an Empty Schema Creating a Schema Based on Profile	Creating Schema	Creating Empty Schemas and Schemas Based on Profile With REST APIs and EM CLI Verbs	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	Provisioning Pluggable Databases	Creating Empty PDBs and PDBs 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
Clone	Full Clone Cloning Databases Using RMAN Backup Cloning Databases Using RMAN Duplicate	Creating Full Clones	Creating Full Database Clones Using RMAN With REST APIs and EM CLI Verbs	Creating Full Database Clones Using RMAN With REST APIs and EM CLI Verbs
Snap Clone	Hardware Solution Sun ZFS Storage Appliance Software Solution ZFS File System Clone DB	Creating Snap Clones	Creating Databases Using Snap Clone With REST APIs and EM CLI Verbs	Creating Databases Using Snap Clone With REST APIs and EM CLI Verbs

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 18-2 Cloud Home Page

   
   
   
2. From the Oracle Cloud menu, select Setup, then select Getting Started. You must first perform the common setup tasks as described in 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.
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 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. The available service types are Database, Pluggable Database, and Schema.
   • See Provisioning New Database Artifacts
   • See Cloning Databases