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.

25.3.1: Hotfix

This is only relevant if you are already on 25.3:
Please delete the DEBUG=TRUE env var from the .env. More context

If you are not on 25.3 yet, please follow this migration guide.

v25.3 DB 23.8 and ORDS 25.2

What's Changed

• DB 23.7 → 23.8 (DB files are compatible)
• ORDS Developer 24.4 → ORDS 25.2
  • Includes migration from ords-developer to the ords image because of deprecation.
• New scripts
  • test-script-install to test SQL scripts in a clean environment (more on test-script-install)
  • used-space to check the used space of the database (more on used-space)
  • shrink-space to reclaim space from tablespaces (more on shrink-space)

Migration

Follow the migration guide

v25.1

Version Changes:

• DB 23.5 -> 23.6
• APEX 24.1 -> 24.2

New scripts:

• local-23ai.sh (intended from global use on your system)
• start.sh
• stop.sh

To migrate see this:
https://github.com/United-Codes/uc-local-apex-dev/blob/25-1/docs/migrations/25-1.md

Full Changelog: https://github.com/United-Codes/uc-local-apex-dev/commits/v25.1