1.3.5 Dynamic Update of COMPATIBLE Setting for Oracle AI Database

Starting with Oracle AI Database 26ai, you can change the COMPATIBLE setting for all sessions in the current Oracle AI Database instance without having to restart the instance.

If you want to enable new functionality in Oracle AI Database that is available in a higher release update (RU), you can now change the COMPATIBLE setting for in-memory processes, and not have to restart database instances. This option is only available in releases starting with Oracle AI Database 26ai that can be updated to a new RU. To use the new functionality available in an RU, update the COMPATIBLE setting to the value major-release.release-update.

The following restrictions for this feature apply:

• This option is available only on Oracle AI Database 26ai databases, and only when moving to a higher RU within Oracle AI Database 26ai.

  Changing the in-memory COMPATIBLE setting without requiring instance restarts can only be performed with ALTER DATABASE SET DOWNGRADE COMPATIBILITY. It cannot be done with ALTER SYSTEM.

• If there are primary and multiple standbys, then you must issue the command on standbys first, and then on the primary.
• If the command is interrupted, then you can issue the change COMPATIBLE command again.
• If the command is issued on the primary database, then it must be issued in an instance where CDB$ROOT is open.
• If multiple sessions issue the same command concurrently, then only one of them will succeed.

Note:

To use the new functionality available in an RU, update the COMPATIBLE setting to the value major-release.release-update.