Migrate to 25.2

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

Changes:

• DB 23.6 -> 23.7
• Script to disable archive logging
  • local-23ai.sh disable-archive-logs
• Script to test an application install (incl. supporting objects)
  • Will show the amount and types of installed objects
  • Will show the amount of invalid objects
  • Will run an object dependency scan and show the results
  • local-23ai.sh test-app-insall ./path/to/my_app.sql

Still, we want to backup the database and the oradata volume.

Check that db is running

docker ps

Otherwise start the database:

docker-compose up -d

Give permission to all new scripts

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

Backup the database

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

local-23ai.sh backup-all

Now check the backups/export directory if the backup was created successfully.

Optional: backup the oradata volume

Optionally also back up the oradata files. This can take a moment, mine is about 10GB big. Make sure that ./backups/oradata does not exist.

source ./scripts/util/load_env.sh

docker exec $CONTAINER_NAME bash -c "echo 'shutdown immediate;
exit' | sqlplus / as sysdba && exit"

docker cp $CONTAINER_NAME:/opt/oracle/oradata ./backups/oradata

Stop the containers

local-23ai.sh stop

Switch branch

git fetch
git checkout 25-2

Start the containers

docker-compose up -d

Optional: delete old images

docker image ls
docker image rm