Setting up and configuring DBaaS requires several steps. While these are well-documented, it seems like a daunting task for those who are unfamiliar with process. A list of steps required to setup DBaaS include the following:
■Create Roles and Users
■Setup Privilege Delegation
■Configure Software Library
■Create PaaS Infrastructure Zone
■Setup Software Pools
■Create Provisioning Profiles
■Create Service Templates
Thanks to the Rapid Start Kit we can setup a fully configured DBaaS environment in minutes.
Rapid Start Kit
The exadata_cloud_setup.py script is the one that is executed to setup DBaaS. Don't worry, it doesn't require an Exadata machine.
You can view the command line options for the scripts by running emcli in script mode.
You should edit the dbaas_cloud_input.xml configuration file to change the default role and credential names as well as default passwords.
To setup a Pluggable database as a service (PDBaaS) environment, you need to have an existing Oracle 12c RAC or single-instance database using ASM for database storage. To find the the list of container databases we can use the emcli get_targets command as shown below.