This post provides all the necessary steps to create a Database-as-a-Service (DBaaS) database in the Oracle® Cloud.
This service enables users to create a database without setting up any physical hardware, installing an operating system, and dealing with the Oracle Database installation prerequisites. It doesn’t take long to create the database, and you need minimal system administrator privileges.
In this post, you learn the following steps to set up DBaaS in the Oracle Cloud:
A compartment is a logical container that stores the Oracle Cloud Infrastructure (OCI) resources, including the instance, storage, network, load balancer, and so on. Compartments are a fundamental process. You can move most resources between compartments. If you want to do anything in the OCI console, first, you need to choose a compartment.
Perform the following steps to create a compartment:
Log in to the Oracle cloud URL (https://www.oracle.com/cloud/sign-in.html).
Enter your account details and press Next.
Finally, enter your username and password and click Sign in.
Now, you can see the Oracle Cloud Console.
After you log into the Oracle cloud, create compartments by using the following steps:
NAME: Compartment Name.
DESCRIPTION: Short description about the compartment, such as Compartment for Test environment.
PARENT COMPARTMENT: It defaults to
Now you have to create VCN. You set up a private network in Oracle data centers, with your chosen firewall rules and specific types of communication gateways. You can create subnets, route tables, and gateways for your compute instance in the VCN.
Perform the following steps to create the VCN:
Select the compartment you created previously.
Click Create Virtual Cloud Network and fill in the details:
NAME: Enter the new VCN name.
CREATE IN COMPARTMENT: Select your compartment.
CIDER BLOCK: Enter the Cider block (for example:
Then click Create virtual cloud Network.
Select a compartment: Enter the compartment that you created. Name your DB system: Enter the database name. Select an availability domain: Select the default domain.
Select a shape type: Choose a shape type. I selected
Select a shape: Choose a shape, click change shape, and select it.
Total node count: Enter the number of nodes. If you want to configure for Oracle Real
Application Clusters (RAC), then choose two nodes. Otherwise, select one node.
Oracle Database software edition: Select the edition. Choose Storage Management Software: Select the management software.
Available storage (GB): Select the available storage size. Total storage (GB): select the total storage size. Add public SSH keys: Create and upload a public ssh key.
Choose a license type: Choose
Bring your Own License(BYOL).
Virtual cloud network: Choose the VCN you created.
Hostname prefix: Enter the hostname prefix.
Database name: Enter the database name. Database version: Select a database versión to install. PDB name Optional: Put a PDB name.
Create administrator credentials: Create new credentials.
Select workload type: Enter the workload type.
Configure database backups: If you want to configure the database, select the checkbox.
And finally, click Create DB System.
The database service enables you to create autonomous and user-managed Oracle Database cloud solutions. You can create a database in a short time. If you don’t want the headache of managing the hardware or datacenter, OCI provides this type of facility. DBaaS offers full access to the available database features and operations, where Oracle owns and manages the infrastructure.
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.