Continuing testing Oracle Database@Google features, this time I wanted to test provisioning using gcloud CLI on Google and seeing how it works out. Google has documentation on using CLI to provision Autonomous Database (ADB) here: https://cloud.google.com/sdk/gcloud/reference/oracle-database/autonomous-databases/create Some of the variables are not right away clear, but in addition to the example I wanted to provision…
OCI Networking – Routing Oracle Services Network Public IPs via Service Gateway
This topic keeps coming up and there are many good blog posts from Oracle and their A-Team on this. As you know, you utilize Oracle Service Gateway to access Oracle Services within the Region. However, you can also broadcast these public IP addresses via Service Gateway towards Dynamic Routing Gateway (DRG) and then to your…
Can I connect with custom private hostname to my Autonomous Database?
Short answer: Yes! When you deploy your Autonomous Database with a private endpoint, you will get endpoint which translates to A record in your VCN. In some cases, you don’t want to relay that oraclecloud.com address further down the road outside of OCI. This could be case for example connecting from on-premises via FastConnect or…
Using Google Cloud Storage with Autonomous Database@GCP
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…
OCI CLI work – getting Cloud Guard risk levels via script
I recently got a requirement to get all Cloud Guard recipes and their rule risk levels printed out. I could go and get them one by one from the Console but thought it’s doable via OCI CLI. Looking the CLI command reference, there are two commands that are required: “oci cloud-guard detector-recipe list” which will…
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…
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…