v26.1: 26ai

This version guides you how to migrate your existing 23ai DB to 26ai. Follow this migration guide. As the datafiles are not compatible we will export everything from the old db and import it into a fresh new db (you will be able to still use the 23ai if you like).

Changes

• 23ai to 26ai database (23.26.0)
  • Data files are not compatible, so a dump/restore is needed
• ORDS 25.2 → ORDS 25.4
• Now usages a space optimized way with own tablespace for audit and APEX data from Connor McDonald's blog post.
• New Scripts
  • import-all.sh: A script to import all exports (created to automate bulk imports during migration).
  • unexpire-accounts.sh:: Script to unexpire APEX_PUBLIC_USER and workspace accounts (addresses password expiration issues post-migration).
  • fix-ws-group-ids.sh Script to fix p_group_ids in APEX workspace SQL files (resolves a known Oracle bug with group assignments during workspace imports).
  • disable-password-expiration.sh: Script to disable password expiration for APEX workspace accounts (prevents future forced password changes).
• Enhanced scripts
  • backup-user.sh: Added support for ORDS export directory and schema export.
  • import-backup.sh: Added support for optional remap schema parameter and auto-confirmation flag (-y).
  • import-datapump.sh: Updated usage message and added support for optional remap schema parameter.
  • test-script-install.sh: Added support for auto-confirmation with -y flag.
  • test-app-install.sh: Added support for auto-confirmation with -y flag.
  • clear-schema.sh: Added support for auto-confirmation with -y flag.
  • create-user.sh: Added username validation for hyphens and improved quoting.