Troubleshooting Oracle Database at Azure PAYG Edition

Hi! #LinkedInFam and #MultiCloud professionals.

In the past two articles, I did show you folks how to successfully setup an Oracle Database at Azure Pay As You Go option.

In today's article, we shall explore common errors and resolutions on how to successfully troubleshoot these issues.

Common Issues

1) Azure Free Trial

Solution:

Make sure you have a Pay As You Go Account!

This is the first and most important step.

I am not entirely positive that this will work in a Free Trial Azure Account

2) Directly launching the Oracle Database @ Azure service

Solution:

Most folks when they search the marketplace and find this, will encounter an error, to fix this, first enable the following Resource Providers in your Azure Subscription

a) Microsoft.BareMetal

b) Microsoft.BareMetalInfrastructure

c) Oracle.Database

3) Networking:

Make sure you allocate two subnets - public and private

Sometimes folks configure Oracle network attachments for both public and private subnets.

Solution:

Network Attachments

Configure the private subnets to be used as a best practice

4) Oracle Subscriptions vs Multiple Azure Subscriptions

Solution:

Please make sure that only one default Oracle Subscription is tied to one Azure Subscription for this to work.

5) Cannot created / connect Oracle Cloud Account

One of the most common errors, folks usually make is if they are already signed into an OCI tenancy and expect the Azure account to be connected.

Solution:

Make sure you have signed out of any OCI tenancy that you may be logged into to make this to work.

Then try again from the Oracle Database at Azure to see if you are able to create an OCI account

6) Trying to create more than one Oracle subscription?

Solution:

You are allowed one to one mapping subscription between Azure and OCI

7) Cannot create more than ADB - Autonomous Database?

Solution:

You will need to navigate back to the Oracle Database at Azure home in the azure portal and click on the Autonomous DB and click on the create button to create additional ADBs

Those are some of the most common issues and solutions I was able to come across!

I also welcome comments, suggestions and addition to any other feedback in the comments section!

Good luck Provisioning Oracle Database at Azure!