Common Tasks

Once your environment is set up, these are the most common tasks you’ll perform during APEX development.

Managing Containers

Start/Stop Containers

# Stop database
local-23ai.sh stop
# You could also run this, but the script will gracefully stop the database
# docker-compose stop

local-23ai.sh start
# Or
# docker-compose start

ORDS Configuration

Modify ORDS Settings

The ords-config folder in the root directory contains ORDS configuration files. Modify these files and restart the ORDS container to apply changes:

# After modifying config files
docker-compose restart ords

SSL Configuration

Enable HTTPS for ORDS by creating self-signed certificates. On MacOS and Linux it will also add the certificate to your system’s keychain:

sudo ./scripts/create-self-signed-certificates.sh
docker-compose restart ords

Access via: https://localhost:8443/ords (Port 8443 instead of 8181).

Maintenance Tasks

Check Database Space Usage

Keep in mind that the FREE database has a space limitation of 12GB. You can check the used space with:

local-23ai.sh used-space

#    CURRENT_GB    LIMIT_GB    PERCENT_OF_LIMIT STATUS
# _____________ ___________ ___________________ _________
#          5.04          12               41.97 OK


# Tablespace                 Total MB    Used MB    Free MB    Pct. Free
# _______________________ ___________ __________ __________ ____________
# SYSAUX                         3440       3158        282            8
# SYSTEM                          690        679         11            2
# USERS                           118         59         59           50
# TBS_PLUGINS                     112         38         74           66
# UNDOTBS1                        103         23         80           78
# TBS_AOP                          77          7         70           91

Shrink Database Files

If your tablespaces have grown over it’s actually used space, you can shrink them to reclaim space. This can take a while.

local-23ai.sh shrink-space

Disable Archive Logs

For development environments, you might want to disable archive logging. You will be asked if you want to do this in the after-first-db-start.sh script, but you can also run it manually:

./scripts/disable-archive-logs.sh

Complete Environment Reset

Delete All Data

To start completely fresh (⚠️ ALL DATA WILL BE LOST):

docker-compose down
docker volume rm oradata
rm .env

Then follow the setup instructions again.