Before you Begin

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

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

1. Open the navigation menu and click Observability and Management. Under Ops Insights, click Administration and then Database Fleet.The Database Fleet Administration page displays.
2. Click Add Databases. The Add Databases to Ops Insights dialog displays.
3. Under Telemetry click on Cloud Infrastructure. Under cloud database type select Autonomous Oracle Databases.
4. 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.
5. Select one or more Autonomous Databases to enable. In this step you can also setup the collection type for your Autonomous Database, by default the check mark option under Full features set is selected. This allows for Full Features collection, deselecting this will limit to Basic Features (Capacity Planning).
   Note
   
   For Exadata Cloud @Customer Autonomous databases full features are checked by default and cannot be unchecked. The basic feature set is not available for these databases.
   Set connection properties to setup the Full Feature connection. This opens the Set credentials window. Depending on the Autonomous Database type, you will see the following connection options:

   • For an IAM credential (ADB-D and ADB-S): Ensure the IAM connection prerequisites mentioned above have been completed and follow these steps:
     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 on Save changes
     5. Ensure that the Prerequisites field shows Complete for all Autonomous Databases to be added
   • For a Local credential follow these steps (ADB-D and ADB-S):
     1. Select the Local Credential radio button
     2. Enter the Database user name
     3. Enter the Database user password secret and verify the compartment chosen
        Note
        
        If you wish to enter a new password secret click on Create password Secret and enter the name, description, compartment, vault, encryption key, and user password. Once entered click onCreate password secret.
     4. Enter the Connection string
     5. Click on Save changes
     6. Ensure that the Prerequisites field shows Complete for all Autonomous Databases to be added
   • For Exadata Cloud @Customer Autonomous databases:
     
     
     1. Select the Management agent
     2. Select the Database service name connection string. The Protocol and Port 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 Database (with mTLS) credential. This type of credential needs access to the database password in the vault as well as the Autonomous 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 on Create Named Credential, this action will take you from Ops Insights into the Agent details page.
        2. In the Agent details page, click on the More Actions drop down, and then click on Managed Named Credentials.
        3. To add a new credential click on Add new Named Credential, enter the Credential Name, Description and Credential Type (Database Credential or Database Credentials for Autonomous Database with JKS encryption) and click Save.

        For more information see: Management Agent Source Credentials.

6. Once you have selected the Autonomous Databases, and configured the feature type (basic or full) and the connection type for Full Features, click Add Databases. This will bring you to the main Database Fleet page where you can monitor the progress for the newly added databases. Once the state shows as Active the process has successfully completed.

Upgrade an Existing Autonomous Database to Full Features Collection