Intro Whatโs the point of moving a database to the Cloud if we canโt automatically deploy it. After blogging about web compute provisioning on AWS,OCI, Azure, & GCP using terraform. The least I could do as a (future-ex) DBA is to terraform database provisioning in Oracle Cloud. On top of that, I also wanted to …
Read more “Terraform for dummies part 6: Deploy Oracle DB System 21c using terraform”
Intro I didnโt know I had that many things to write about refreshable PDB clones, but I do like the techno and how useful it can be to application teams that want to replicate QA environments out of their prod database very quickly. After showcasing how to automate the refresh of a PDB clone using …
Read more “How to remote clone a PDB from a READ ONLY refreshable PDB (tips & tricks)”
Intro I lately had a silly error while running dbaascli on an ExaCC cluster but the java output was not helpful at all. This is a super short post that shows where to find dbaascli execution logs and also an example of what can break your command execution depending on who runs it. My error …
Read more “ExaCC dbaascli command with mysterious PILOT error when creating a PDB”
Intro In my previous blog post, I showcased how to automate the refresh of a PDB clone using a DBMS scheduler job which gives a better control on the frequency, instead of relying on the minutely refresh. Handy if you donโt like keeping an automatic refresh every X minutes and rather have it run once …
Read more “What they don’t tell you about refreshable PDB clones (ghost archives)”
Intro In part II, and after demonstrating how to use OCI Bastion service using the Console (see part I ) we will cover how to create Bastion Service using automation tools like OCI CLI and terraform as I didnโt want all these approaches to be lumped in one post. Quick table of contents – Create …
Read more “OCI Bastion Service Part II: Create Bastion service using OCI CLI & Terraform”