Hey all!

Hope that you are OK!

This is the fifth post of OCI. You can see the another published posts:

Oracle Cloud Infrastructure – Post 1 – Creating an OCI Account

Oracle Cloud Infrastructure – Post 2 – Key Concepts

Oracle Cloud Infrastructure – Post 3 – Compartment and VCN

Oracle Cloud Infrastructure – Post 4 – DB System Concepts

After understand a little bit about DB Systems, let’s start creating a new DB System:

In the top left corner, click on hamburger, then on Bare Metal, VM, and Exadata:

 

Make sure that you are in DEV_COMPARTMENT, then, click on [Create DB System] button:

 

You need specify some values to fit your needs:

  • Compartment;
  • Name of DB System;
  • Availability Domain where DB System will be created;
  • Shape type;
  • Shape;
  • Total node count;
  • Database Software Edition;
  • Available Storage;
  • Add public SSH keys;
  • License type;
  • VCN;
  • Client Subnet;
  • Hostname prefix.

As an example, all those informations can be verified in below screens, but, in summary:

  • Compartment: DEV_COMPARTMENT;
  • Name of DB System: TESTDEVDB;
  • Availability Domain where DB System will be created: AD-1;
  • Shape type: Virtual Machine;
  • Shape: VM.Standard2.2;
  • Total node count: 1;
  • Database Software Edition: Enterprise Edition High Performance;
  • Available Storage: 256GB;
  • Add public SSH keys: add your public ssh key. If you don’t have one, create a SSH key pair in OpenSSL format: Creating a Key Pair;
  • License type: License Included;
  • VCN: DEV_VCN;
  • Client Subnet: Public Subnet for AD-1;
  • Hostname prefix: TESTDEVDB.

 


Then, click on [Next] button:


 

Then you need to specify some information for Database that will be created:

  • Database Name;
  • Database Version;
  • PDB name (Optional):
  • Administrator credentials;
  • Workload type;
  • Enable automatic backups;
  • Backup retention period;
  • Character set (in advanced options).

In my example, I just filled out the the form with following:

  • Database name: DEVCDB;
  • Database version: 12.1.0.2.181016;
  • PDB name: ERPDEV;
  • Workload type: OLTP;
  • Enable automatic backups: Yes;
  • Backup retention period: 7 days.


Then, click on [Create DB System] button:

 

You will see the following screen meanwhile DB System is being created:


After some time your DB System will be ready to use. In my case, the creation task took 90 minutes. When ready, you see the screen:

All set! In the next post we will continue exploring OCI.

You can read more about Database on OCI here:

Overview of the Database Service

 

Peace!

 

Vinicius