Provisioning an Autonomous Database (ADB) instance on Oracle Database Service for Azure (ODSA) involves several steps. Here's a step-by-step guide to help you through the process:
Step 1: Access the Oracle Database Service for Azure Console
Log in to the Azure Portal: Go to the Azure Portal and log in with your credentials.
Access ODSA: Navigate to the Oracle Database Service for Azure (ODSA) from the Azure Marketplace or through your Azure services list.
Step 2: Create a New Autonomous Database
Open the ADB Creation Page:
In the ODSA console, go to the Autonomous Database section.
Click on "Create Autonomous Database".
Basic Configuration:
Compartment: Select the compartment where you want to create the database.
Display Name: Enter a display name for your database.
Database Name: Enter a unique name for your database (e.g., myadb).
Choose a Deployment Type:
Shared Infrastructure: Choose this option if you want to use Oracle’s shared infrastructure.
Dedicated Infrastructure: Choose this option if you prefer dedicated infrastructure for your ADB instance.
Select a Database Type:
Transaction Processing: Optimized for transactional workloads.
Data Warehouse: Optimized for analytical and data warehousing workloads.
JSON: Optimized for JSON document storage and retrieval.
APEX: For APEX applications.
Step 3: Configure Database Details
Database Version: Select the desired version of the database.
OCPU Count: Specify the number of OCPUs (Oracle CPUs) you want to allocate to your ADB instance.
Storage: Specify the amount of storage you need for your database (in TB).
Step 4: Configure Network Access
Network Access Type:
Secure Access from Anywhere: Allows secure access over the internet.
Virtual Cloud Network (VCN): Use this if you have a VCN configured and want to restrict access to specific IP ranges.
Whitelisting IP Addresses: If you chose "Secure Access from Anywhere", you may need to specify IP addresses or ranges that are allowed to access your database.
Step 5: Configure Additional Options
Admin Credentials:
Username: Typically, this is set to ADMIN.
Password: Enter a strong password and confirm it.
Tags (Optional): Add any tags that you want to associate with the database for easier identification and management.
Step 6: Review and Create
Review Configuration: Go through the configuration details to ensure everything is correct.
Create Database: Click the "Create Autonomous Database" button.
Step 7: Monitor the Provisioning Process
Provisioning Status: You will be taken to the Autonomous Database details page where you can monitor the provisioning status.
Completion: Once the status changes to "Available", your ADB instance is ready for use.
Step 8: Connect to the Autonomous Database
Download Wallet: From the Autonomous Database details page, click on "DB Connection" and download the wallet file for secure connectivity.
Configure Connection:
Use the wallet file to configure your SQL Developer or other database clients to connect to the ADB instance.
Follow the instructions provided in the connection details to set up the client connection.
Step 9: Access and Manage Your Database
SQL Developer: Use Oracle SQL Developer or any other compatible tool to connect and manage your database.
Oracle APEX: If you chose the APEX deployment type, you can start building applications using Oracle APEX.
By following these steps, you can successfully provision and start using an Autonomous Database instance on Oracle Database Service for Azure.
Comments