Managing Autonomous Database Resources

After provisioning any OracleDB@Azure resource, you can use the Microsoft Azure blade for a limited set of management functions.

Note

There are prerequisites that must be completed before you can provision Autonomous Database Services. You need to complete the following:
  1. An existing Azure subscription
  2. An Azure VNet with a subnet delegated to the Oracle Database@Azure service (Oracle.Database/networkAttachments)
  3. Permissions in Azure to create resources in the region, with the following conditions:
    • No policies prohibiting the creation of resources without tags, because the OracleSubscription resource is created automatically without tags during onboarding.
    • No policies enforcing naming conventions, because the OracleSubscription resource is created automatically with a default resource name.
  4. Purchase OracleDB@Azure in the Azure portal.
  5. Select your Oracle Cloud Infrastructure (OCI) account.
For more detailed documentation, including optional steps, see Onboarding with Oracle Database@Azure.

Common Management Functions from the Microsoft Azure Blade

The following management functions are available for all resources from the Microsoft Azure blade for that resource.

Access the Resource Blade

These are the steps to perform the most common management function for Autonomous Database Services.

  1. From the Microsoft Azure portal, select OracleDB@Azure application.
  2. From the left menu, select Oracle Autonomous Database@Azure.
  3. Select the resource from the list.

List Status for All Resources of the Same Type

These are the steps to list the status of all the Autonomous Database Services resources.

  1. Follow the steps to Access the Resource Blade.
  2. Resources will be shown in the list as Succeeded, Failed, or Provisioning.
  3. Access the specifics of that resource by selecting the link in the Name field in the table.

Provision a New Resource

These are the steps to provision a new resource in Autonomous Database Services.

  1. Follow the steps to Access the Resource Blade.
  2. Select the + Create icon at the top of the blade.
  3. Follow the provisioning flow for Provisioning an Autonomous Database.

Refresh the Blade's Info

These are the steps to refresh the blade's info for Autonomous Database Services.

  1. Follow the steps to Access the Resource Blade.
  2. Select the Refresh icon at the top of the blade.
  3. Wait for the blade to reload.

Remove a Resource

These are the steps to remove a resource in Autonomous Database Services.

  1. Follow the steps to Access the Resource Blade.
  2. You can remove a single or multiple resources from the blade by selecting the checkbox on the left side of the table. Once you have selected the resource(s) to remove, you can then select the Delete icon at the top of the blade.
  3. You can also remove a single resource by selecting the link to the resource from the Name field in the table. From the resource's detail page, select the Delete icon at the top of the blade.

Add, Manage, or Delete Resource Tags

These are the steps for adding, managing, and deleting resource tags in Autonomous Database Services.

  1. Follow the steps to Access the resource blade.
  2. Select the link to the resource from the Name field in the table.
  3. From the resource's overview page, select the Edit link on the Tags field.
  4. To create a new tag, enter values in the Name and Value fields.
  5. To edit an existing tag, change the value in the existing tag's Value field.
  6. To delete an existing tag, select the Trashcan icon at the right-side of the tag.

Access Autonomous Database Backups

These are steps for accessing Autonomous Database Backups from Microsoft Azure console.

  1. From the Microsoft Azure portal, select OracleDB@Azure application.
  2. From the left menu, select Oracle Autonomous Database@Azure.
  3. Select your Autonomous Database, and click the Settings link located on the resource's overview page.
  4. Select the Backups link to access and manage all backup information and actions.

Restore Autonomous Database Backups

These are steps to restore your Autonomous Database from backups located on the Microsoft Azure portal.

  1. From the Microsoft Azure portal, select OracleDB@Azure application.
  2. From the left menu, select Autonomous Database.
  3. Select your Autonomous Database, and then click the Settings link located on the resource's overview page.
  4. To restore your Autonomous Database from a backup, select the Backups link, and then click Restore.
  5. From the drop-down list, select the Backup timestamp, and then click Restore.

Clone Autonomous Database from Backups

These are steps to clone your Autonomous Database from backups located on the Microsoft Azure portal.

  1. From the Microsoft Azure portal, select OracleDB@Azure application.
  2. From the left menu, select Autonomous Database.
  3. There are two paths to clone your Autonomous Database from backups.
    1. Click the Setting link located at the resource's overview page. To clone your Autonomous Database from a backup, select the Backups link, and then click Create clone from backup.
    2. Click the Overview link, and then click Create clone.
  4. From the Basics tab of the Clone Oracle Autonomous Database flow, enter the following information.
    1. Select your Subscription. The current Subscription field is automatically selected. If you have any other subscriptions that your account can assess, those will be available in the drop-down list.
    2. Select your Resource group from the drop-down list.
    3. Enter a Name for your Oracle Autonomous Database instance clone.
    4. Select the Region from the drop-down list. The current Region is automatically selected.
    5. The current Source database name is automatically selected.
    6. Select the Clone type from the drop-down list. If you want to create a new database with source database's data and metadata, select Full Clone. If you want to create a new database that includes all source database schema metadata but not the source database data, select Metadata Clone.
    7. The Clone source is a drop-down list containing two existing options. To create a clone from a backup, select Clone from a backup. To create a clone of a running database, select Clone from database instance.
    8. The Backup timestamp field is drop-down list that allows you to select the timestamp of the backup to clone.
    9. The Backup time ended field provides the end time of the backup. This field is automatically changed based on your Backup timestamp selection.
    10. Click the checkbox next to Latest backup timestamp, if you want to use the latest backup timestamp.
    11. Select Next to continue.
  5. For the Oracle Autonomous Database instance cloning flow, see Provisioning an Autonomous Database, and follow the instructions from the Step 4.
    Note

    Supported Workload type for creating a clone from backups include Data Warehouse and Transaction Processing. Select your Workload type from the drop-down list.

Manage Resource Allocation for Oracle Autonomous Database Serverless Instances

These are the steps for managing resource allocation for Autonomous Database Services.

Note

You can only change the resource allocation settings for Oracle Autonomous Database Serverless instances using these steps. This does not apply to any other resource type.
  1. Follow the steps to access the Access the Resource Blade.
  2. Select the link to the resource from the Name field in the table.
  3. From the resource's overview page, select the Setting link left-menu, and then the Resource allocation link.
  4. Select the Manage button at the top of the Resource allocation page.
  5. From the Manage resource allocation window, you can set the ECPU count from 2 to 512. The Compute auto scaling checkbox allows you to enable your Oracle Autonomous Database to scale its computing allocation automatically up to 512. The Storage is a slider UI that allows setting the Storage allocation from 1 TB to 384 TB. The Storage auto scaling checkbox allows you to enable your Oracle Autonomous Database to scale its storage allocation automatically up to 384 TB.
  6. After you have set or reviewed the fields, select the Apply or Cancel button as appropriate.

Perform a Connectivity Test

These are the steps to perform a connectivity test for Autonomous Database Services.

  1. Follow the steps to access the Access the Resource Blade.
  2. Select the link to the resource from the Name field in the table.
  3. From the resource's overview page, select the Settings link left-menu, and then the Connections link.
  4. Select the Download wallet icon and save the file.
  5. Open Oracle SQL Developer. If you don't have SQL Developer installed, download SQL Developer and install.
  6. Within SQL Developer, open a new connection with the following information.
    1. Name - Enter a name of your choice used to save your connection.
    2. Username - Enter ADMIN.
    3. Password - Enter the password used when creating the Autonomous Database.
    4. Role - Select default.
    5. Save Password - Select the box if you security rules allow. If not, you will need to enter the PDB password every time you use this connection in SQL Developer.
    6. Connection Type - Select Cloud Wallet.
    7. Configuration File - Select Browse, and select the wallet you downloaded.
    8. Select the Test button. The Status at the bottom of the connections list, should show as Success. If the connection is not a success, the wallet is out of date, or the ADB is not currently running.
    9. Select the Save button.
    10. Select the Connect button.

Access the OCI Console

These are the steps to access the OCI console for Autonomous Database Services.

  1. Follow the steps to Access the Resource Blade.
  2. Select the link to the resource from the Name field in the table.
  3. From the resource's detail page, select the Go to OCI link on the OCI Database URL field.
  4. Login to OCI.
  5. Manage the resource from within the OCI console.

Access Oracle Apex from OCI console

These are steps to access Oracle APEX from the OCI console.

  1. Follow the steps to Access the OCI console.
  2. From the Navigation menu, select Oracle Database, and then select Autonomous Database.
  3. After selecting your Autonomous Database, click the Tool configuration.
  4. Under the Tools section, Oracle APEX with Public access URL is listed. Copy the Public access URL and paste it into your website address bar to access Oracle APEX.

Request Increased Storage or ECPU Limits

These are the steps to request increased storage or ECPU limits for Autonomous Database Services.

  1. From the OracleDB@Azure home, select Overview.
  2. Select the View Oracle Subscription button.
  3. Select the default subscription.
  4. From the left menu for the default subscription, select Help > Support + Troubleshooting.
  5. In the Tell us about the issue to get solutions and support field, enter Oracle Database@Azure and the select the Go button.
  6. In the Which service are you having an issue with? drop-down field, select Databases / Oracle Database@Azure from the list.
  7. Select the Next button.
  8. In the message that appears, select the OCI Support portal link.
  9. Follow the steps as discussed in the Support for OracleDB@Azure process.

Support for OracleDB@Azure

These are the steps to request support for OracleDB@Azure.

  1. Follow the steps to Access the OCI Console.
  2. From the OCI console, there are two ways to access support resources.
    1. At the top of the page, select the Help (?) icon at the top-right of the menu bar.
    2. On the right-side of the page, select the floating Support icon. NOTE: This icon can be moved by the user, and the precise horizontal location can vary from user to user.
  3. You have several support options from here, including documentation, requesting help via chat, visiting the Support Center, posting a question to a forum, submitting feedback, requesting a limit increase, and creating a support request.
  4. If you need to create a support request, select that option.
  5. The support request page will auto-populate with information needed by Oracle Support Services, including resource name, resource OCID, service group, service, and several other items dependent upon the specific OracleDB@Azure resource.
  6. Select the support option from the following options:
    1. Critical outage for critical production system outage or a critical business function is unavailable or unstable. You or an alternate contact must be available to work this issue 24x7 if needed.
    2. Significant impairment for critical system or a business function experiencing severe loss of service. Operations can continue in a restricted manner. You or an alternate contact are available to work this issue during normal business hours.
    3. Technical issue where functionality, errors, or a performance issue impact some operations.
    4. General guidance where a product or service usage question, product or service setup, or documentation clarification is needed.
  7. Select the Create Support Request button.
  8. The support ticket is created. This ticket can be monitored within the OCI console or via My Oracle Support (MOS).

Access Network File System from Autonomous Database

You can attach a Network File System (NFS) to a directory location in your Autonomous Database. This allows you to load data from Oracle Cloud Infrastructure (OCI) File Storage in your Virtual Cloud Network(VCN), or from any other NFS in on-premises data centers. You can access the NFS through the supported NFSv4 version.

These are the prerequisites required to begin accessing Network File System from your Autonomous Database.
  1. To enhance security for outbound connections with private endpoints, run the following SQL script on your database to set the ROUTE_OUTBOUND_CONNECTIONS database property to the value PRIVATE_ENDPOINT. This ensures all outgoing connections to a target host follow and are restricted by the private endpoint's egress rules.
    ALTER DATABASE PROPERTY SET ROUTE_OUTBOUND_CONNECTIONS =
        'PRIVATE_ENDPOINT';
  2. These are the steps required for NFS File Share through Azure Files Configuration. Oracle Zero Downtime Migration (ZDM) Logical Offline migration workflow uses Oracle Data Pump export and import to migrate the data from the source to the target database. An NFS file share is provided through the Azure Files Service to store the Data Pump dump files.
    Note

    The private endpoint of the storage account must be in a different VNet than your Autonomous Database. The file share path in this example is odaamigration.file.core.windows.net:/odaamigration/testmigration. The NFS private endpoint IP in this example is an fictional aa.an.fs.pe address.
    1. Mount the NFS Share on the source database server using one of the following methods.
      Note

      You must mount the NFS share on both the source database host and the target Autonomous Database.
      1. As root:
        mkdir /nfstest mount -t nfs
            odaamigration.file.core.windows.net:/odaamigration/testmigration /nfstest -o
            vers=4,minorversion=1,sec=sys
      2. Using IP:
        mount -t nfs aa.an.fs.pe:/odaamigration/testmigration /nfstest -o
            vers=4,minorversion=1,sec=sys 
    2. To make sure your Oracle user has access to NFS mount, run the following command.
      chown oracle:oinstall /nfstest
    3. To create an empty file named test.txt in the /nfstest directory, run the following script as an Oracle user:
      touch /nfstest/test.txt
    4. On the source PDB:
      create directory DATA_PUMP_DIR_NFS as '/nfstest';
  3. On the Oracle Zero Downtime Migration (ZDM) Service Host, using as root, add the Autonomous Database Private Endpoint URL sample.adb.us-region1.oraclecloud.com to the /etc/hosts file to be resolved to the Autonomous Database Private Endpoint IP aa.dd.bb.ss.
These are steps to access Network File System from your Autonomous Database.
  1. Follow the steps to add NFS mount point Fully Qualified Domain Name System (FQDN) to OCI Domain Name System DNS Virtual Cloud Network Resolver.
    Note

    If the OCI tenancy is a new tenancy created within Oracle Database@Azure provisioning process, you might need to increase the limits for Oracle Cloud Infrastructure private DNS and A-records. You can open a Service Request with Oracle Support. A limit of at least 3 records is needed.
    1. From the Microsoft Azure portal, select Oracle Database@Azure application.
    2. From the left menu, select Autonomous Database.
    3. Click the Go to OCI link located on the resource's overview page.
    4. From the OCI console, select Networking, and then click Virtual cloud networks.
    5. From the Virtual Cloud Network Details page, select Details, and then click on the DNS Resolver.
    6. From the Private resolver information, select the Default private view.
    7. Click the Create zone button to create a new private zone. Enter Zone name as file.core.windows.net.
    8. Select the previously created Zone name, and then click on the Manage records to create a record. Enter your preferred Name. From the drop-down list, select A-IPv4 address and set the TTL in seconds to 3600. Replace the e aa.an.fs.pe by the actual IP address, and then save the changes.
    9. Update the Network Security Group in OCI to allow network traffic flow the VNet where the NFS private endpoint resides.
  2. Follow the steps to add NFS Mount FQDN to the Access Control List (ACL).
    1. Use the DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE procedure to append an Access Control Entry (ACE) to the Access Control List of a network host. For more information, see APPEND_HOST_ACE Procedure.
    2. Change the host parameter with your own host name.
    3. Run the following SQL script on your database.
      exec
                    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
                                host =>'odaamigration.file.core.windows.net', 
                                ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
                                principal_name => 'ADMIN',
                                principal_type =>xs_acl.ptype_db));
      
  3. To create a directory or use an existing directory to attach a NFS in your Autonomous Database, run the following command. For example, the following command creates the database directory named FSS_DIR and the file system directory named fss. For more information, see Create Directory in Autonomous Database.
    Note

    You must have WRITE privilege on the directory object in your Autonomous Database instance to attach a file system to a directory location in the database.
    CREATE or replace DIRECTORY FSS_DIR AS 'fss';
  4. Follow these steps to attach NFS to a directory in your Autonomous Database.
    1. Run the DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM procedure to attach a file system to a directory in your Autonomous Database.
      Note

      You must be logged in as the ADMIN user or have EXECUTE privilege on DBMS_CLOUD_ADMIN.
      The following attributes must be set to run this procedure.
      • file_system_name: Specify your file system name.
      • file_system_location: Specify your file system location.
      • directory_name: Specify your directory name for the attached file.
      • description:Specify a description for your task.
      • params: Specify your nfs_version.
        1. Use value 4 to specify NFSv4.
       exec
                    DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM(   
                             file_system_name => 'AZUREFILES', 
                             file_system_location =>'odaamigration.file.core.windows.net:/odaamigration/testmigration', 
                             directory_name => 'FSS_DIR',
                             description => 'Attach Azure Files',   
                             params => JSON_OBJECT('nfs_version' value 4) );
             
          

      For more information, see ATTACH_FILE_SYSTEM Procedure.

    2. To retrieve information about the attached file system, run the following query.
      SELECT object_name FROM DBMS_CLOUD.LIST_FILES('FSS_DIR');