Info icon
End of Life Notice: For Trend Cloud One™ - Conformity Customers, Conformity will reach its End of Sale on “July 31st, 2025” and End of Life “July 31st, 2026”. The same capabilities and much more is available in TrendAI Vision One™ Cloud Risk Management. For details, please refer to Upgrade to TrendAI Vision One™
Use the Knowledge Base AI to help improve your Cloud Posture

Check for Database Version

TrendAI Vision One™ provides continuous assurance that gives peace of mind for your cloud infrastructure, delivering over 1400 automated best practice checks.

Risk Level: Medium (should be achieved)
Rule ID: OCI-AutonomousAIDatabase-011

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.

Security
Operational
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

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

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

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

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

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

  6. 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

  1. 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"'
    
  2. The command output should return the requested OCI compartment identifiers (OCIDs):

    [
    	"ocid1.tenancy.oc1..aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
    	"ocid1.compartment.oc1..abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
    ]
    
  3. 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"'
    
  4. The command output should return the requested database instance IDs:

    [
    	"ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
    	"ocid1.autonomousdatabase.oc1.ap-sydney-1.abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
    ]
    
  5. 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"'
    
  6. The command output should return the database version installed on your instance:

    "19c"
    
  7. 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"'
    
  8. 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

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

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

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

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

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

  6. 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

  1. 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"'
    
  2. The command output should return the requested OCI compartment identifiers (OCIDs):

    [
    	"ocid1.tenancy.oc1..aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
    	"ocid1.compartment.oc1..abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
    ]
    
  3. 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"'
    
  4. The command output should return the requested database instance IDs:

    [
    	"ocid1.autonomousdatabase.oc1.ap-sydney-1.aaaabbbbccccddddabcd1234abcd1234abcd1234abcd1234abcd1234abcd",
    	"ocid1.autonomousdatabase.oc1.ap-sydney-1.abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd1234abcd"
    ]
    
  5. 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
    
  6. 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

Publication date Dec 3, 2025