In blog post Part 1, I described how to subscribe to the PAYG service to use the Oracle Autonomous Database in Azure. Now it’s time to provision a new ADB. As prerequisites, a resource group, a virtual network and several subnets are created.
When provisioning an Autonomous Database on Oracle Database@Azure, it is essential to use a delegated subnet. A delegated subnet is a subnet within a virtual network that is specifically designated for use by a particular service. Using a delegated subnet ensures enhanced security, better network control, simplified management, compliance, and optimized performance, making it an ideal choice for modern database provisioning.
Overview
This is the entry point, click on Create Autonomous Database.
Basics
When deploying an Autonomous Database (ADB) on Oracle Database@Azure, the first step is to select your subscription and resource group. This ensures that the resources you create are associated with the correct billing and management context. Next, you need to set a name for your ADB instance. This name should be unique within your resource group and should follow the naming conventions specified by your organization. Finally, you must choose a region where your ADB instance will be deployed.
Configuration
Define the workload type. This could be either OLTP (Online Transaction Processing) or DW (Data Warehousing), depending on your specific use case. Next, you will need to select the version of the database. Currently, the only available version is 19c
You will also need to set other important parameters such as storage size and auto scaling. The storage size determines the amount of data your database can hold, while auto scaling allows the database to automatically adjust its resources based on workload demands. Additionally, you will need to set the ADMIN password, which is used to manage and access the database.
Depending on your available licenses, you can choose between License Included and Bring Your Own License (BYOL) options. The License Included option provides a complete package with the necessary licenses, while the BYOL option allows you to use your existing Oracle licenses, potentially reducing costs.
Networking
The delegated subnet is a subnet within your Azure virtual network that is specifically designated for use by the Autonomous Database. This ensures that the database is isolated from other resources in your network, enhancing security and performance. Fore more information how to setup it up, read the documentation here: https://learn.microsoft.com/en-us/azure/oracle/oracle-db/database-overview.
Maintenance
When configuring the maintenance settings for your Autonomous Database (ADB) on Oracle Database@Azure, it’s important to note that the patch level cannot be changed at the moment. This ensures that your database remains up-to-date with the latest security patches and performance improvements provided by Oracle.
Additionally, you should set an email address to receive notifications when the Autonomous Database is ready to use. This will help you stay informed about the status of your database and ensure that you can start using it as soon as it is provisioned.
Consent
In the next step of provisioning your Autonomous Database (ADB) on Oracle Database@Azure, you need to agree to the terms of service. This step is crucial as it ensures that you acknowledge and accept the terms and conditions associated with using the service. Once you have agreed to the terms of service, you can proceed to the Review+Create page.
Review + Create
On the review+create page, you will have the opportunity to review all the configurations and settings you have made for your Autonomous Database (ADB) on Oracle Database@Azure. This is your chance to ensure that everything is set up correctly before finalizing the deployment. Carefully check all the details, including the subscription, resource group, instance name, region, workload type, version, storage size, auto scaling, ADMIN password, and networking settings.
Deployment is in progress
Once you have confirmed the creation of your Autonomous Database (ADB) on Oracle Database@Azure, the deployment process will begin. This process typically takes a few minutes. During this time, the necessary resources are being provisioned and configured according to the settings you specified.
After a couple of minutes, you will receive a notification at the email address you provided, informing you that your Autonomous Database is ready to use. You can then start accessing and managing your database, taking advantage of its high-performance, scalability, and security features.
In next post, let’s connect, see how it’s internal built in OCI and read about billing.