Intro We all know Windows is the preferred platform for Oracle DBAs !! I hear that every day :D. All right, maybe not so much ;). But Jokes aside, when your client has the majority of his DB workload running on windows, it’s hard to dodge the job. It becomes even more challenging to switch …
Intro The thing we usually forget when completing a certification is to save a mental image of the topics that were exciting to learn or the concepts that we had no clue about right before starting the preparation. This is what practitioners should focus on after every major Cloud cert exam, as it provides an …
Read more “Hashicorp Terraform Associate certification takeaways”
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”
Intro In the cloud, bastion or jump server is the only node exposed to the outside world and acts as a gateway between the private network where your backend resources (application, databases..etc) are hosted and the Internet. A Bastion runs bare minimum applications and is extremely secure. Even if any network can access it, it …
Read more “OCI Bastion Service Part I: How to use it to connect to your Private Subnet (Console)”
Intro Terraform uses API to interact with your Cloud provider’s platform. Hence many error messages thrown by your terraform deploy come directly from the cloud platform (i.e OCI services) . In some cases, they prove to be very unhelpful and empty of insights, leaving you wonder what really is breaking your deployment. These are part …
Read more “Terraform in OCI: The infamous error 404-NotAuthorizedOrNotFound”
Intro The first time I had seen a glimpse of this Infrastructure as Code artifact in 2018 (presented by Roopesh Ramklass at our TOUG meetup), I found the it ugly as hell and sworn to never touch it (probably confused it with Json ;)). Today I am happy to admit that I was totally wrong …