Enable Diagnostics and Management for Autonomous AI Databases

Sign in to your Oracle Cloud Infrastructure (OCI) account.

Navigate to Autonomous AI Databases console available at https://cloud.oracle.com/db/adbs.

For Applied filters, choose an OCI compartment from the Compartment dropdown menu, to list the Autonomous AI Databases provisioned in the selected compartment.

Click on the name (link) of the Autonomous AI Database that you want to examine, listed in the Display Name column.

Select the Autonomous AI Database information tab to access the general configuration settings available for the selected database instance.

In the Associated services section, check the Database Management attribute value to determine the feature status. If Database Management is set to Not enabled, the Database Management feature is disabled for the selected Oracle Cloud Infrastructure (OCI) Autonomous AI Database.

Run iam compartment list command (Windows/macOS/Linux) with output query filters to list the ID of each compartment available in your Oracle Cloud Infrastructure (OCI) account:

oci iam compartment list
	--all
	--include-root
	--query 'data[]."id"'

The command output should return the requested OCI compartment identifiers (OCIDs):

[
	"ocid1.tenancy.oc1..aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
	"ocid1.compartment.oc1..abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
]

Run db autonomous-database list command (Windows/macOS/Linux) with the ID of the OCI compartment that you want to examine as the identifier parameter, to list the ID of each Autonomous AI Database provisioned in the selected OCI compartment:

oci db autonomous-database list
	--compartment-id 'ocid1.tenancy.oc1..aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd'
	--all
	--query 'data[]."id"'

The command output should return the requested database instance IDs:

[
	"ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
	"ocid1.autonomousdatabase.oc1.ap-sydney-1.abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
]

Run db autonomous-database get command (Windows/macOS/Linux) with the ID of the Autonomous AI Database that you want to examine as the identifier parameter and custom output filters to determine if Database Management is enabled for the selected database instance:

oci db autonomous-database get
	--autonomous-database-id 'ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd'
	--query 'data.{"database-management-status":"database-management-status"}'

The command output should return the requested feature status:

{
	"database-management-status": "NOT_ENABLED"
}

If the db autonomous-database get command output returns null or "NOT_ENABLED" for the "database-management-status" property, as shown in the output example above, the Database Management feature is disabled for the selected Oracle Cloud Infrastructure (OCI) Autonomous AI Database.

Sign in to your Oracle Cloud Infrastructure (OCI) account.

Navigate to Autonomous AI Databases console available at https://cloud.oracle.com/db/adbs.

For Applied filters, choose an OCI compartment from the Compartment dropdown menu, to list the Autonomous AI Databases provisioned in the selected compartment.

Click on the name (link) of the Autonomous AI Database that you want to configure, listed in the Display Name column.

Select the Autonomous AI Database information tab to access the general configuration settings available for the selected database instance.

In the Associated services section, click on the Action button (3-dot icon) available next to the Database Management status, and choose Enable.

On the Enable Diagnostics & Management setup page, provide the following actions to enable and configure the Database Management feature:

1. For Service name, enter a name for the service instance or choose a predefined service name.
2. For Database wallet secret in \, click inside the Select secret box, choose Create new secret, and provide the wallet name and format, the encryption vault and key, to create a new database wallet secret. Inside the A policy is required to access this secret box, choose Add policy to create the necessary access permissions.
3. For Specify credentials for the connection, enter the database user name and the database user password secret. If the secret with the database user password is not available, click inside the Select secret box, choose Create new secret, and provide the required details to create a new database user secret. Inside the A policy is required to access this secret box, choose Add policy to create the necessary access permissions.
4. Choose Enable Diagnostics & Management to enable the Database Management feature for the selected OCI Autonomous AI Database.

Run iam compartment list command (Windows/macOS/Linux) with output query filters to list the ID of each compartment available in your Oracle Cloud Infrastructure (OCI) account:

oci iam compartment list
	--all
	--include-root
	--query 'data[]."id"'

The command output should return the requested OCI compartment identifiers (OCIDs):

[
	"ocid1.tenancy.oc1..aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
	"ocid1.compartment.oc1..abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
]

Run db autonomous-database list command (Windows/macOS/Linux) with the ID of the OCI compartment that you want to examine as the identifier parameter, to list the ID of each Autonomous AI Database provisioned in the selected OCI compartment:

oci db autonomous-database list
	--compartment-id 'ocid1.tenancy.oc1..aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd'
	--all
	--query 'data[]."id"'

The command output should return the requested database instance IDs:

[
	"ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
	"ocid1.autonomousdatabase.oc1.ap-sydney-1.abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
]

Run db autonomous-database enable-autonomous-database-management command (Windows/macOS/Linux) with the ID of the Autonomous AI Database that you want to configure as the identifier parameter, to enable the Database Management feature for the selected database instance:

oci db autonomous-database enable-autonomous-database-management
	--autonomous-database-id 'ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd'

The command output should return the work request ID for the modified database instance:

{
	"opc-work-request-id": "ocid1.coreservicesworkrequest.oc1.ap-sydney-1.abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
}