Oracle Cloud Infrastructure (OCI) : Create a Compartment, VCN and DB


Having spent time playing on the Autonomous Data Warehouse and Autonomous Transaction Processing services, I kind-of lost sight of the Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) stuff. I had a question recently about running (non-autonomous) databases on Oracle Cloud and I didn’t really have anything of my own to point them at, since my only DBaaS article was on the old “Classic” bit of Oracle Public Cloud. I figured it was about time I did a quick run through of the OCI version of that. This resulted in the following three posts, which are just scratching the surface of course.

At first glance it seems a little more complicated, as there are some prerequisites to think about, but actually it makes a lot of sense. The sales pitch demo of any cloud service is to click a few buttons and everything magically appears, but there is some thought needed in the real world. Defining a reasonable network topology for security, and separation of duties and functional areas are pretty common in most companies. This does feel more sensible, and sets you off on the right foot.

If you need a certain amount of manual control and access to the server, the Database VM approach is fine, and there are also Bare Metal and Exadata services too, but I think my starting position would be the autonomous services, unless I had a specific reason not to go that route. I’m all about doing as little as possible… 🙂



Author: Tim...

DBA, Developer, Author, Trainer.