Creating the Database in the Cloud – Creating a Database

In the previous chapter, we discussed what is needed to install the Oracle Base Database in the Oracle Cloud (OCI). This will create the virtual machine, compute instance, install the database software, and create the database. Once this is accomplished, you can connect to the database server and create additional databases as well. We will look at how to manage and maintain the Oracle Base Database on OCI in later chapters too.

However, there is an additional option to create the database in OCI, and that is just to create an Autonomous Database. The Oracle Autonomous Database can be created on a shared or a dedicated environment. There are different management tasks that are needed for each of these options.

Autonomous Shared/Serverless

The Autonomous Database in a shared environment needs a couple pieces of information and then in less than five minutes the database is up and available.
Figure 2-9 shows the basic setup for the database. A name is needed, and you have a few option types based on workload, data warehouse, transactional, JSON, or APEX for low-code applications.

Figure 2-9. Create Autonomous Database

The next information that is needed is an admin password and license type. There are options on autoscaling and version of the database, but default values normally work well here.

After all we have discussed, this seems too easy. But the provisioning of the Autonomous Database in the cloud takes care of the back end, and you have a database that is easily provisioned and ready to use. Even as a DBA there are things that will need to be done after creation, and we will take a look at them in the upcoming chapters.