19c PDB Refreshable clones

Intro Beside Long term release benefits, upgrading to a multitenant 19c Database will allow to completely ease the way test environments are refreshed from production servers. Say Goodbye to complex & lengthy RMAN duplicate scripts and hello to remote cloning. Even better with refreshable clones, production data is now automatically updated. Many blogs were written …

How to run Datapump from a PDB as SYS when ORACLE_PDB_SID can’t work

Intro In Oracle multitenant architecture, default database container upon connection is CDB$ROOT. But as of 18c, a new environment variable appeared to ease the direct access to a specific PDB (given a defined ORACLE_SID). The variable in question is ORACLE_PDB_SID.  As explained in Mike Dietrich’s Blog, this variable is checked by a small AFTER EVENT …

Terraform for dummies part 5: Terraform deployment On-premises (KVM)

Intro For a long time, Terraform was associated with deploying resources in the cloud. But what many people don’t know is that terraform already had private and community based providers that worked perfectly on non cloud environments. Today, we will discover how to deploy a compute vm in a KVM host. Not only that, but …

KVM lab inside a VirtualBox vm (Nested virtualization) using vagrant

Intro It has been a while since I wanted to blog about nested virtualization, but the good news is I now have a vagrant build to share with you so you can  vagrant it up:). KVM started to interest me as soon as I learned that Oracle allowed for hard partitioning on KVM boxes if …

Create a local Windows10 VPN bastion using a vagrant box

Intro There are many examples online on how to create a linux vagrant box including mine. But not so much around windows boxes. The easiest way?  just shop around in Vagrant Cloud, identify a windows box, and spin it using vagrant up. That’s exactly what I did but I faced a problem after the trial …