Migrate to 26.2

If you haven’t installed uc-local-apex-dev yet, you can find the setup instructions here.

Make sure you are on 26.1 before you start. Do the previous migrations if not.

Changes

• DB 23.26.0.0 → 23.26.1.0 (DB files are compatible)
• ORDS 25.4 → 26.1
• Enhanced scripts
  • drop-user.sh: now also removes the named SQLcl connection from the connection manager
  • create-user.sh: added grants for AQ (Advanced Queuing), JavaScript, and catalog privileges
  • unexpire-accounts.sh: fixed workspace account expiry using apex_util.set_security_group_id for correct workspace scoping
  • after-first-db-start.sh: sets max application backups and randomizes the internal APEX ADMIN password on first start; non-interactive TTY detection for SSH compatibility
  • install-dbms-cloud.sh / create-datapump-directory.sh: non-interactive TTY detection so scripts work over SSH
  • drop-user.sh: user credentials are now commented out in .env instead of being removed entirely
• Bug fixes
  • drop_all.sql: now also drops Queue Tables; excludes INDEX and LOB object types to prevent errors
  • docker-compose compatibility: scripts now support both docker-compose (v1) and docker compose (v2 plugin)

Migration

Make sure your database is running:

docker ps

Otherwise start the database:

./local-26ai.sh start

Backup the database

This will backup all schemas and APEX workspaces that were created with the local-26ai.sh create-user script. If you have additional schemas or workspaces you need to back them up manually.

./local-26ai.sh backup-all

Check the backups/export directory to confirm the backup was created successfully.

Stop the containers

./local-26ai.sh stop

Switch branch

git fetch
git checkout 26-2

Give permission to all new scripts

chmod +x ./local-26ai.sh ./setup.sh ./scripts/*.sh

Start the containers

./local-26ai.sh start

The database will automatically upgrade from 23.26.0.0 to 23.26.1.0 on first start. ORDS will detect the version mismatch and upgrade itself to 26.1 as well. Monitor the logs until both are ready:

docker logs -f local-26ai
docker logs -f local-26ai-ords

Verify

Navigate to http://localhost:8181/ords/apex to confirm ORDS is serving APEX.

Optional: delete old docker images

docker image ls
docker image rm {image_name}