docker-compose.yml

services:
  oracle:
    image: ${ORACLE_IMAGE}
    container_name: oracle23ai
    ports:
      - "${ORACLE_PORT}:1521"        # Oracle listener
    environment:
      ORACLE_PASSWORD: "${ORACLE_PASSWORD}"   # SYS/SYSTEM password (first run)
      APP_USER: "${APP_USER}"                 # create an app schema/user
      APP_USER_PASSWORD: "${APP_USER_PASSWORD}"
      # Optional: generate random admin pwd instead of ORACLE_PASSWORD
      # ORACLE_RANDOM_PASSWORD: "y"
    volumes:
      # Persistent database files
      - oradata:/opt/oracle/oradata
      # One-time initialization scripts (first run only)
      - ./db/init:/container-entrypoint-initdb.d
      # Scripts executed on every start (e.g., dynamic seed/reset hooks)
      - ./db/startup:/container-entrypoint-startdb.d
    healthcheck:
      # Wait until we can actually run SQL against FREEPDB1
      test: ["CMD-SHELL", "echo 'select 1 from dual;' | sqlplus -s -L system/${ORACLE_PASSWORD}@localhost:1521/FREEPDB1 | grep -q 1"]
      interval: 30s
      timeout: 10s
      retries: 20
      start_period: 90s
    restart: unless-stopped

volumes:
  oradata: