Enable Autonomous AI Databases & Full Feature Support

Before you Begin

Exadata Database Service on Dedicated Infrastructure Autonomous AI Databases (ADB-D), and Exadata Database Service Serverless (ADB-S) are supported using private endpoints. Exadata Cloud@Customer Autonomous AI Databases (ADB@ExaCC) are supported using Management Agents.

To enable one or more Autonomous AI Databases (including Autonomous Exadata Cloud@Customer databases) for Ops Insights, log in to OCI and do the following:

1. Open the navigation menu, click Observability & Management, and then click Ops Insights.
2. In the left pane, click Administration, and then click Database fleet.

   The Database fleet administration page displays.

3. Click Add databases.
4. Under Telemetry, select Cloud Infrastructure.
5. In the Database type field, select Autonomous AI Database.
6. Select the Compartment that contains the database that you want to enable for Ops Insights. Optionally, if there are many databases and you know which ones you want to enable, you can filter the returned results based on database type.
7. Select one or more Autonomous AI Databases to enable. By default, Full is selected in the Full feature set column. To select Basic features (Capacity Planning), click the Actions menu for the database and select Disable full feature set.
   Note
   
   

   • For Exadata Cloud @Customer Autonomous AI Databases full features are checked by default and cannot be unchecked. The Basic feature set is not available for these databases.
   • Full feature set is not available for Autonomous AI Database for APEX due to inherent APEX service limitations. For information, see Oracle APEX Limitations on Autonomous AI Database.

   To configure the full feature connection, click the Actions menu for the database and select Set connection properties. In the Set full features credentials panel, the following connection options are available depending on the Autonomous AI Database type:

   • For an IAM credential (ADB-D and ADB-S): Ensure the IAM connection prerequisites have been completed and follow these steps. For information on IAM connection prerequisites, see Prerequisites for Enabling Autonomous AI Databases.
     1. Select the IAM Credential radio button.
     2. Optional, if prompted complete the missing prerequisite policies.
     3. Enter the connection string for IAM.
     4. Click Save changes.
     5. Ensure that the Prerequisites field shows Complete for all Autonomous AI Databases to be added.
   • For a Local database credential follow these steps (ADB-D and ADB-S):
     1. Select the Local database credential radio button.
     2. Enter the Database user name.
     3. Select the Database user password secret compartment and the Database user password secret and verify the compartment chosen.
        Note
        
        If you wish to enter a new password secret, click Create password Secret and enter the name, description, compartment, vault, encryption key, and user password. Once entered, click Create password secret.
     4. Enter the Connection string.
     5. Click Save changes.
     6. Ensure that the Prerequisites field shows Complete for all Autonomous AI Databases to be added.
   • For Exadata Cloud @Customer Autonomous AI Databases:
     1. Select the Management agent.
     2. Select the Database service name connection string. The Protocol and Port fields will be automatically filled.
     3. Specify the named credentials to be used for the connection, these credentials are created by the Agent and do not reside within Ops Insights.
        • For TLS connections, create a credential of type Database credential. This type of credential will not use the wallet to connect.
        • For Mutual TLS (TCPS), create an Database Credential for Autonomous AI Database (with mTLS) credential. This type of credential needs access to the database password in the vault as well as the Autonomous AI Database wallet.
        Note
        
        The type of credential you create must directly relate to the service name you choose when enabling the database.

        If you do not have the Management Agent Credentials (MACS) set, you can set them in this step by following these substeps:

        1. Determine the credential type to use (TLS or MTLS), and then click Create Named Credential, this action will take you from Ops Insights into the Agent details page.
        2. In the Agent details page, click the More Actions drop down, and then click Managed Named Credentials.
        3. To add a new credential click Add new Named Credential, enter the Credential Name, Description and Credential Type (Database Credential or Database Credentials for Autonomous AI Database with JKS encryption) and click Save.

        For more information see: Management Agent Source Credentials.

8. Once you have selected the Autonomous AI Databases and configured the feature type (basic or full) and, for full features, the connection type, click Add databases. On the Database fleet administration page, after the State of the newly enabled database changes to Active, the process has successfully completed.

Upgrade an Existing Autonomous AI Database to Full Features Collection