Task 6: Find the Azure Availability Zone Mapping (Optional)

Learn how to find the Azure availability zone mapping that controls the physical locations of your Azure subscription’s availability zones.

When planning an Exadata deployment, you need to ensure that you have the correct limits set for the availability zone you're using. You also need to know the physical location of the availability zone to ensure that your hardware is provisioned in the physical location that works best for your applications and resources.

Using the Azure Cloud Shell or CLI, you can find the mapping between physical and logical Azure availability zones in your Azure subscription. Both Azure and OCI randomize the mapping of physical and logical availability zones, and therefore the physical location of a logical zone can differ between Azure subscriptions.

See Physical and logical availability zones in the Azure documentation, and Your Tenancy's Availability Domain Names in the OCI documentation for more information.

Before you begin:

You need the following information to run the Azure CLI command in this topic:

Your Azure subscription ID. To find this in the Azure console, see Get subscription and tenant IDs in the Azure portal.
The Name of the Azure region you are mapping. For example, the Azure region with the Display Name "Germany West Central" has the Name germanywestcentral. For the CLI command discussed in this topic, you would use the string germanywestcentral in the command to find the availability zone mapping for the Germany West Central region.

To find the Names of all Azure regions, you can run the account list-locations CLI command, as follows:
```
az account list-locations -o table
```
The output is formatted as shown in the example table that follows . The "Name" value needed for this topic is shown in the second column in the table.
```
DisplayName               Name                 RegionalDisplayName
------------------------  -------------------  -------------------------------------
East US                   eastus               (US) East US
UK South                  uksouth              (Europe) UK South
Central India             centralindia         (Asia Pacific) Central India
Germany West Central      germanywestcentral   (Europe) Germany West Central
...
...
                
```

Open the the Azure Cloud Shell or CLI. You can open Cloud Shell by clicking the Cloud Shell icon from the top navigation of the Azure portal:

Use the PowerShell option to run the command in this task. See What is Azure Cloud Shell for more information.

Run the following command to find the mapping:

az rest --method get --uri '/subscriptions/{subscriptionId}/locations?api-version=2022-12-01' --query 'value' |jq -c '[ .[] | select( .name == "{regionName}")]' | jq

To run the command, you must replace the variables shown in brackets "{}", as follows. Do not include the brackets when you enter the actual values for these variables:

subscriptionId: Your Azure subscription ID.
regionName: This value represents the Azure region's Name value, discussed earlier in this topic under Before you begin. Do not use the "DisplayName" or the "RegionalDisplayName" for this value.

Example command:

az rest --method get --uri '/subscriptions/00000000-0000-0000-0000-000000000000/locations?api-version=2022-12-01' --query 'value' |jq -c '[ .[] | select( .name == "eastus")]' | jq

Example output:

[
  {
   "availabilityZoneMappings": [
	 {
	   "logicalZone": "1",
	   "physicalZone": "eastus-az2"
	 },
	 {
	   "logicalZone": "2",
	   "physicalZone": "eastus-az3"
	 },
	 {
	   "logicalZone": "3",
	   "physicalZone": "eastus-az1"
	 }
  ],
	"displayName": "East US",
	"id": "/subscriptions/&lt;subscription-id>/locations/eastus",
	"metadata": {
	  "geography": "United States",
	  "geographyGroup": "US",
	  "latitude": "37.3719",
	  "longitude": "-79.8164",
	  "pairedRegion": [
		{
		  "id": "/subscriptions/&lt;subscription-id>/locations/westus",
		  "name": "westus"
		}
	  ],
	  "physicalLocation": "Virginia",
	  "regionCategory": "Recommended",
	  "regionType": "Physical"
	},
	"name": "eastus",
	"regionalDisplayName": "(US) East US",
	"type": "Region"
  }
]

What's Next?

Set up Role Based Access Control in the Azure portal for your Oracle Database services. See Task 7: Set Up Role Based Access Control for Oracle Database@Azure for instructions.

Oracle Cloud Infrastructure Documentation

Task 6: Find the Azure Availability Zone Mapping (Optional)

What's Next?