This post will be checklist for items you’ll need when you have Firewall (or Hub) VCN where you route traffic to and have 3rd party firewall appliance (such as Palo Alto) inspecting traffic. You have to understand different route tables which are associated and which routes you have to set to them. What this post…
OCI ExaCS Database Upgrade Rollback
Recently I was testing OCI database upgrade from 12c to 19c and ran into an issue I wanted to fix. I was doing this via dbaascli (on Exadata) and the upgrade hit Bug 34455245 – db12c upgrade to 19c fails with ORA-600 [kxhfmgetextent.1] (Doc ID 34455245.8). I tried few things as with dbaascli you can…
Issues with OCI ExaCS PDB cloning
This is mostly just to document if you hit similar issues and how to get past them. I had to perform some remote cloning in ExaCS (from one CDB to another CDB) within same VM cluster, but hit few issues which I had to resolve first before getting it to work. [DBT-05514] Failed to connect…
OCI Tips and Tricks – Managed MySQL Database in OCI (and trying out Heatwave)
Here I’m looking on how to provision MySQL DB on OCI, see how read replicas work and how to add Heatwave Cluster to your DB. After that, I’m running some test queries to try out Heatwave, interesting results!
OCI Tips and Tricks: Create 19c Oracle Database (and manage it)
This time I go over on how to create 19c Oracle Database on OCI (hint: It’s super easy!). But what I feel is more important, where to find relevant log files after you’ve provisioned the database and how to use dbcli to manage your database and debug issues. Hope you enjoy the video!
OCI Tips and Tricks: Three ways to login to your Compute VM
New video! This time I’m showing how to login to your OCI Compute VM in three different ways: Public Compute Bastion Service Cloud Shell Hope you like the video – leave a feedback in the comments of the video if you think I should have covered something else as well. I forgot to mention that…
I’m back! Something new.. and more blog posts!
I attended Oracle Cloud World last week, and was positively surprised how much fun I had there! I really appreciate the folks who came and said they like reading my blog, I’ve been telling folks I haven’t had much motivation to create new content lately, but that actually made my motivation to go higher! Due…
WORM compliance with custom OCI Database backups
When you move your databases to cloud, many times the (current) standard backup configuration what Oracle offers is not enough. That’s when you configure OCI Cloud Database backup module which allows more flexibility with your RMAN configuration and also allows to write backups to custom Object Storage bucket. Question came up regarding this, can we…
Basics of Autonomous Migration with ZDM and integration with CPAT
This will be my third post on using Zero Downtime Migration (ZDM) for your migration, previously I’ve written about physical offline and online migration. Since Oracle talks a lot about Autonomous Database, let’s look this time what options you have on migrating to Autonomous. For Autonomous we have two options, logical offline and logical online…
Data Guard migration with ZDM
In the previous post I showed how to setup cloning or migration using offline physical option with Zero Downtime Migration (ZDM). This time let’s take a look what happens with ONLINE PHYSICAL option. Common migration requirement is to migrate with lowest amount of downtime and with all the latest data available and Data Guard is…