Migrate to 25.3

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

Changes

• DB 23.7 -> 23.8 (DB files are compatible)
• ORDS 25.1
  • 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
  • used-space to check the used space of the database
  • shrink-space to reclaim space from tablespaces

Migration

Make sure your database is running:

docker ps

Otherwise start the database:

docker-compose up -d

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

Copy APEX images

docker cp local-ords:/opt/oracle/apex/24.1.0/images .
mv images apex-images
rm .env.ords
rm -r ords-secrets
echo "DBSERVICENAME=\"FREEPDB1\"" >>.env
echo "DBHOST=\"23ai\"" >>.env
echo "DBPORT=\"1521\"" >>.env
echo "FORCE_SECURE=\"false\"" >>.env
echo "DEBUG=\"true\"" >>.env

Stop the containers

local-23ai.sh stop

Switch branch

git fetch
git checkout 25-3

Give permission to all new scripts

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

Start the containers

docker-compose up -d

Optional: delete old images

docker image ls
docker image rm {image_name}