postgres_oracle_compose.yml

services:
  oracle:
    image: container-registry.oracle.com/database/express:21.3.0-xe
    container_name: oracle
    environment:
      ORACLE_PWD: admin  # SYS, SYSTEM and PDBADMIN password
    ports:
      - 1521:1521
    volumes:
      - "./sql/oracle_setup.sql:/opt/oracle/scripts/startup/oracle_setup.sql"
    healthcheck:
      test: ["CMD-SHELL", "echo 'SELECT COUNT(*) FROM users; exit;' | sqlplus hr/hr@//localhost:1521/xepdb1"]
      interval: 1m
      timeout: 5s
      start_interval: 2s
      start_period: 15s
      retries: 3


  postgres:
    image: docker.io/chumaky/postgres_oracle_fdw:latest
    container_name: postgres
    environment:
      POSTGRES_PASSWORD: postgres
    ports:
      - 5432:5432
    volumes:
      - "./sql/postgres_oracle_setup.sql:/docker-entrypoint-initdb.d/postgres_oracle_setup.sql:z"
    depends_on:
      oracle:
        condition: service_healthy