Provisioning an Oracle Autonomous Database
You can provision an Oracle Autonomous Database from Oracle Database Service for Azure, and set it up to support data warehouse, transaction processing, JSON, or APEX workloads.
For more information on Oracle Autonomous Databases, refer to the following:
Provisioning an Oracle Autonomous Database Serverless
The Oracle Database Service for Azure portal enables you to provision an Oracle Autonomous Database Serverless (ADB-S) deployment that supports Transaction Processing, Data Warehouse, JSON, or APEX workloads.
- Select Autonomous Database from the OracleDB for Azure portal. Alternatively, select Create a resource from the OracleDB for Azure portal, and then select the Create link for Autonomous Database from the Create a resource blade.
- This is the Basics tab on the Autonomous Database blade.
- Select any Subscription linked to your Oracle Cloud Infrastructure (OCI)tenancy through OracleDB for Azure.If you have a single subscription, you will not be able to change the value in this field. If you have multiple subscriptions linked to your OCI tenancy, you can change the default value for this field following the tasks outlined in Setting Account UI Settings.
- Select a Resource group for where to place the resource.Follow this link for more information on Microsoft Azure Resource Groups Microsoft Azure Resource Groups.
- The Instance Name must be unique for your subscription.
- In the Region field, select the region where this database will be provisioned. If you have a single region, you will not be able to change the value in this field. If you have multiple regions assigned, you can change the default value for this field following the tasks in Setting Account UI Settings.
- Select the Next: Configuration > button.
- The Workload type selection allows to select any of the supported workload types, including Transaction Processing, Data Warehouse, JSON, and APEX. For more information, see About Autonomous Database Workload Types.
- The ECPU count must be between 1 and 128.
- The ECPU auto scaling allows the system to use up to three (3) times the ECPUs, as specified by ECPU count up to 128, as workload increases.
- The Storage (TB) must be between 1TB and 128TB.
- The License type options will vary based on the Workload type you select. Transaction Processing and Data Warehouse workloads can opt for either License included or Bring your own license (BYOL) types. JSON and APEX workloads are assigned to License included, and this cannot be altered.
- Bring Your Own License (BYOL) Select if your organization already owns Oracle Database software licenses. Bring your existing database software licenses to the database cloud service. See Cloud pricing for information on Bring Your Own License (BYOL) and other licensing options for Oracle Cloud Infrastructure cloud service pricing.
- License Includes subscribes you to a new database software licenses and the database cloud service.
- The Database version will vary based on your subscription. Select the choice that works for best for your requirements.
- Specify the Database name. It must consist of letters and numbers only. The maximum length is 30 characters. The same database name cannot be used for multiple Autonomous Databases in the same tenancy in the same region. If you do not meet the naming requirements, you will see a validation message.
- Select the Next: Networking > button.
- The default Access type is Secure access from everywhere. You can set it to Secure access from allowed IP addresses. In the field, you can enter individual IP addresses or IP address ranges using CIDR block notation.
- Select the Next: Security > button.
- The Base Database administrator Username is set to
ADMIN
, and cannot be changed. - The Base Database administrator Password must be set. It must contain two (2) uppercase characters, two (2) lowercase characters, two (2) numeric characters, two (2) special characters within
_
,#
, and-
, and must be between 12 and 255 characters long. If the password you enter does not meet these requirements, you will see a confirmation message similar to the following. - The Base Database administrator Confirm Password must be match the value you entered for your Password. If the Confirm Password does not match, you will see a confirmation message similar to the following.
- Select the Next: Tags > button. Here is where you can set tags, which are Name-Value pairs that can be set to improve management. Select the Learn more about tags link if you want more information. Tags created here are applied to OCI provisioned resources.
- Select the Next: Review + create > button.
- If the validation fails, you will see a screen similar to the following. You must resolve all of the validation issues before you can submit the creation process to the queue.
- To create the Oracle Autonomous Database Serverless, select the Create button.
- To review or change any settings, select the < Previous button.
- To cancel creation of the Oracle Autonomous Database Serverless, select either the Home breadcrumb or the X (close) icon at the top-right of the page.
- If you select the Create button, the provisioning process for the Oracle Autonomous Database Serverless begins. The time it takes to complete this process will vary based on the values you selected or entered for the database.
- To check on all Oracle Autonomous Database Serverless deployments, successful, failed, or in-progress, check the Deployments blade or the Autonomous Database blade.
- This completes the steps for provisioning an Autonomous Database Serverless deployment.