- Knowledge Base
- Oracle Cloud Infrastructure
- OCI Autonomous AI Database
- Check for Database Version
Ensure that your OCI Autonomous AI Databases are using the latest version of Oracle AI Database to gain access to the newest AI/GenAI capabilities, performance enhancements, and critical security features. The latest version ensures optimal efficiency, reliability, and continuous protection via automated patching, keeping your mission-critical data repository state-of-the-art.
excellence
Your Autonomous AI Databases should be running the latest database version to receive the newest AI/GenAI features, critical security fixes, and performance enhancements. This practice mitigates vulnerabilities, enhances efficiency, and ensures compliance with current best practices.
Audit
To determine if your OCI Autonomous AI Databases are using the latest version of Oracle AI Database, perform the following operations:
Using OCI Console
-
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 General information section, check the Database version attribute value to identify the Oracle AI Database version installed on your database instance. Compare this value with the latest Oracle AI Database version available here. If the Database version installed on your instance is not the latest version and the Schedule upgrade to \<latest-database-version\> is displayed, the selected OCI Autonomous AI Database is running an older version of Oracle AI Database.
Using OCI CLI
-
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 name of the Autonomous AI Database that you want to examine as the identifier parameter and custom output filters to identify the Oracle AI Database version installed on the selected database instance:
oci db autonomous-database get --autonomous-database-id 'ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd' --query 'data."db-version"'
-
The command output should return the database version installed on your instance:
"19c"
-
Run db autonomous-database get command (Windows/macOS/Linux) with the name of the Autonomous AI Database that you want to examine as the identifier parameter and custom output filters to describe the latest versions of Oracle AI Database available for upgrade for the Autonomous AI Database service:
oci db autonomous-database get --autonomous-database-id 'ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd' --query 'data."available-upgrade-versions"'
-
The command output should return the latest Oracle AI Database versions available for upgrade:
[ "23ai", "26ai" ]
Compare the database version installed on your instance (returned in step no. 6) with the latest Oracle AI Database version(s) available for upgrade (returned in step no. 8). If the database version installed on your instance is not the latest version available for upgrade, the selected OCI Autonomous AI Database is running an older version of Oracle AI Database.
Remediation / Resolution
To ensure that your OCI Autonomous AI Databases are using the latest version of Oracle AI Database, perform the following operations:
Using OCI Console
-
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 General information section, choose Schedule upgrade to \<latest-database-version\>, select Earliest available schedule from the Select Schedule dropdown list, and choose Schedule to set the upgrade window for the selected database instance. The upgrade will cause a few minutes of downtime for the database and its attached refreshable clones and standbys. New refreshable clones or disaster recovery standbys cannot be created while the upgrade is scheduled.
Using OCI CLI
-
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 update command (Windows/macOS/Linux) with the name of the Autonomous AI Database that you want to configure as the identifier parameter, to schedule the database upgrade to the latest Oracle AI Database version, at the earliest available time. The upgrade process will cause a few minutes of downtime for the database and its attached refreshable clones and standbys. New refreshable clones or disaster recovery standbys cannot be created while the upgrade is scheduled:
oci db autonomous-database update --autonomous-database-id 'ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd' --db-version '26ai' --is-schedule-db-version-upgrade-to-earliest true
-
The command output should return the configuration information available for the modified database instance:
{ "data": { "allocated-storage-size-in-tbs": 0.0078125, "are-primary-whitelisted-ips-used": null, "auto-refresh-frequency-in-seconds": null, "auto-refresh-point-lag-in-seconds": null, "autonomous-container-database-id": null, "autonomous-maintenance-schedule-type": "REGULAR", "availability-domain": "ABCD:AP-SYDNEY-1-AD-1", "failed-data-recovery-in-seconds": null, "freeform-tags": {}, "id": "ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd", "in-memory-area-in-gbs": null, "in-memory-percentage": null, "infrastructure-type": null, "is-access-control-enabled": null, "is-auto-scaling-enabled": true, "is-auto-scaling-for-storage-enabled": true, "is-backup-retention-locked": true, "is-data-guard-enabled": true, "is-dedicated": false, "is-dev-tier": null, "is-free-tier": false, "is-local-data-guard-enabled": false, "is-mtls-connection-required": true, "is-preview": false, "is-reconnect-clone-enabled": false, "is-refreshable-clone": null, "is-remote-data-guard-enabled": false, "key-store-wallet-name": null, "kms-key-id": "ORACLE_MANAGED_KEY", ... "license-model": "LICENSE_INCLUDED", "lifecycle-details": null, "lifecycle-state": "UPDATING", "local-adg-auto-failover-max-data-loss-limit": null, "local-disaster-recovery-type": "BACKUP_BASED", "time-data-guard-role-changed": null, "time-deletion-of-free-autonomous-database": null, "time-disaster-recovery-role-changed": null, "time-earliest-available-db-version-upgrade": "2025-12-13T14:10:00+00:00", "time-latest-available-db-version-upgrade": "2025-12-13T13:40:00+00:00", "time-local-data-guard-enabled": "2025-12-13T09:27:58.721000+00:00", "time-maintenance-begin": "2025-12-15T06:00:00+00:00", "time-maintenance-end": "2025-12-15T08:00:00+00:00", "time-of-auto-refresh-start": null, "time-of-joining-resource-pool": null, "time-of-last-failover": null, "time-of-last-refresh": null, "time-of-last-refresh-point": null, "time-of-last-switchover": null, "time-of-next-refresh": null, "time-reclamation-of-free-autonomous-database": null, "time-scheduled-db-version-upgrade": null, "time-undeleted": null, "time-until-reconnect-clone-enabled": null, "total-backup-storage-size-in-gbs": 0.0, "used-data-storage-size-in-gbs": null, "used-data-storage-size-in-tbs": null, "vanity-connection-urls": null, }, "etag": "abcd1234", "opc-work-request-id": "ocid1.coreservicesworkrequest.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd" }
References
- Oracle Cloud Infrastructure Documentation
- Oracle AI Database 26ai
- What’s New for Oracle Autonomous Database Serverless
- Autonomous AI Database with Oracle AI Database 26ai
- Oracle Cloud Infrastructure CLI Documentation
- compartment list
- autonomous-database list
- autonomous-database get
- autonomous-database update