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…
Connecting to Autonomous Database Running on Google Cloud
Last time I showed how to provision Autonomous Database Serverless (ADB-S) on Google Cloud. This time I have provisioned a new ADB and want to see how I can connect from my VM running on the same VPC as the ADB. I’ll use sqlcl to connect to the database, to install it you will need…
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…
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…
Autonomous JSON Database with Database API for MongoDB
Oracle had announced Database API for MongoDB which can be used together with Autonomous JSON Database. This post will be with some learnings what I went through when I tested it out. Official announcement post goes through the setup rather well. When provisioning the database, remember to select Autonomous JSON database as DB type and…