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…
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…
New Console Experience for OCI
Just saw that OCI has enabled preview for new OCI Console experience. To enable it, scroll down on your dashboard after login and click on the enable preview. Let’s take a look on it! When I login to the Console, I see the normal dashboard with slightly bigger fonts. Not all services have been enabled…
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…
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…
IP Address Insights with CLI
My previous post on IP Address Insights I mentioned it wasn’t yet available with CLI but I was wrong! It was there, just my Cloud Shell CLI version wasn’t the latest so didn’t have the command yet available. If you have 3.40.2 and above, the following commands are now available: oci network ipam list-ip-inventory oci…
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 Vulnerability Scanning Setup
Many times when you work for someone, they already have their own vulnerability scanning throughout the organization. What usually happens is that onboarding to that tooling might take time, that’s why I initially started to look on OCI Vulnerability Scanning Service – to have something scanning your servers or images from day 1! Or could…