If you’ve worked with Autonomous Database previously, you know that every now and then you need to get files from the Autonomous Database or put files to Autonomous Database so they can be processed. For example, when you migrate data using Oracle Data Pump, the log files will be placed on the Autonomous Database. Typically,…
ZDM migration to Autonomous Database on GCP using Network Link for direct migration – part 2
Well this took a while! With recent work and travel it’s been couple busy months. Excited to write on this after being at Google Next 25 last week! I really feel the Oracle partnership with Google, Azure and AWS is going to be awesome for folks who still leverage Oracle technology heavily but want to…
ZDM migration to Autonomous Database on GCP using Network Link for direct migration – part 1
This will be a weird and fun post. I have recently been working with Autonomous Database migrations and wanted to highlight the option of using Oracle datapump (ZDM Logical Offline) and network link option. Using network link removes the need to export the data first to cloud storage and allows you to import “directly” your…
Autonomous Database Audit Logs to Logging Service Part 1
I recently came across requirement to get OCI Oracle Autonomous Database audit logs to OCI Logging Service, mainly due to getting them to external SIEM system. Typically once we get the logs to Logging, we can use OCI Service Connector to ingest them to Oracle Streaming and then from there, external systems can get the…
Can you believe it? Provisioning Autonomous Database in GCP!
I bet few years back folks didn’t expect that by 2024 we would be able to provision OCI resources in other clouds. Last year the announcement for Azure and this year announcements for GCP and AWS have been really exciting and I think long term they’ll have a positive impact with Oracle’s reputation also. One…
Thoughts on Oracle Database@Azure
This will NOT be a technical walkthrough on Oracle Database@Azure but rather my opinions and thoughts on how it will shape the Oracle workload destinations when migrating out from on-premises. Once I get few technical implementations under my belt, I’ll also write some more details on how I see it works and how we need…
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!