Autonomous Database Full Feature Support
Ops Insights allows you to perform advanced collections on your Autonomous Databases via a private endpoint or through secure access from anywhere. These connection methods allows Ops Insights to connect to the database directly and enable Full Features collection, which includes SQL Explorer and ADDM Spotlight.
Prerequisites
To enable Full Features collection set on an Autonomous Database the following prerequisites must be met:- Enable the Autonomous Database in Ops Insights, for more information see Enable Databases for the Service
- If your network requires it, create a Private Endpoint. Make sure you set up the correct network requirements for your database, including the creation of private endpoints. The following table outlines the network requirements by type of autonomous databases:
ADB Type Access Type Network Requirements ADB Serverless (ADB-S) Access Anywhere None ADB Serverless (ADB-S) Private Endpoint Same Private Endpoint requirements as cloud databases. NoteFor more information see: Enabling Database Cloud Service Databases and Exadata Cloud Service
Use the ADB private endpoint VCN/Subnet instead of the database VCN/SubnetADB Serverless (ADB-S) ACL (Access Control List) Restricted The private endpoint needs to be placed in one of the whitelisted VCNs. This VCN must have access to the public ADB endpoint, typically via service gateway. For more information see: Configure Access Control Lists When You Provision or Clone an Instance
ADB Dedicated (ADB-D) N/A Same requirements as cloud databases. For more information see: Enabling Database Cloud Service Databases and Exadata Cloud Service Note
Dedicated Autonomous Databases require a private endpoint with DNS Proxy enabled. Ops Insights private endpoints created prior to September 2023 did not require the DNS proxy enabled. A new private endpoint may need to be created. - Create the policies to allow Ops Insights service to generate autonomous database wallets, and to read the database password secret. It is recommended this step be performed automatically when setting up the Advanced Features collection in Step 4.
Example policy to allow Ops Insights service to generate Autonomous Database wallets:
Example policy to allow Ops Insights service to read the database password secret:allow service operations-insights to read autonomous-database-family in tenancy where ALL{request.operation='GenerateAutonomousDatabaseWallet'}
allow service operations-insights to read secret-family in tenancy where ANY{target.secret.id='<SecretId>'}
Enable Full Features Collection For an Autonomous Database
To enable Full Features collection for an Autonomous Database follow these steps:
- Log into OCI, navigate to Observability and Management, then Ops Insights and click on Administration.
- Under Administration select Database Fleet. This will show you the Database Fleet Administration table where all your databases that have an enabled Ops Insights state are displayed. Autonomous Databases with an Active state and a Basic Feature Set are eligible for Full Feature enabling.
- Select an Autonomous Database you wish to enable the advanced features for and click on the three dots menu located at the right end of the table. From the menu select Enable Full Feature Set.
- In the Enable Full Feature Set window enter the database user name and user password secret. If your Autonomous Database is configured for private endpoint check mark Access database via private network and provide the Private endpoint. Databases configured with ACL restricted and ADB-D require private endpoint connections.
The connect string information is automatically filled out by the service.
If you have not previously created the policies to generate Autonomous Database wallets click on Complete the prerequisites, and then click on Apply.
Click Enable.Note
ADB-S configured with ACL and ADB-D databases may require new private endpoints that have DNS proxy enabled selected. If this parameter is not selected, you will not see existing private endpoints in the drop down menu for these types of databases. - In the Database Fleet Administration table, the Autonomous Database under the Ops Insights State row will now show Full, advanced features are now being collected.