Azure Availability Zone Mapping For Oracle Database@Azure

Before you begin:

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

• The Azure subscription ID for the subscription you're using. 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
  ...
  ...
                  

1. Open the Azure Cloud Shell or CLI. You can open Cloud Shell by select 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.

2. 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. Don't 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. Don't 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/<subscription-id>/locations/eastus",
   	"metadata": {
   	  "geography": "United States",
   	  "geographyGroup": "US",
   	  "latitude": "37.3719",
   	  "longitude": "-79.8164",
   	  "pairedRegion": [
   		{
   		  "id": "/subscriptions/<subscription-id>/locations/westus",
   		  "name": "westus"
   		}
   	  ],
   	  "physicalLocation": "Virginia",
   	  "regionCategory": "Recommended",
   	  "regionType": "Physical"
   	},
   	"name": "eastus",
   	"regionalDisplayName": "(US) East US",
   	"type": "Region"
     }
   ]