# exdev 개발서버 — TROAD용 Oracle (Docker)
#
# chatbotApi application.yml 의 troad datasource 와 맞춤:
#   jdbc:oracle:thin:@localhost:1521/orcl2
#   username: OPR_MAIN
#   password: test
#
# 테이블 DDL 은 oracle/apply-sql.sh 로 적용한다.
#
# 이미지: Oracle Database Free 23ai (linux/arm64 지원).
#   개발서버가 Apple Silicon(arm64) 이라 amd64 전용인 oracle-xe:21 은 사용할 수 없다.
services:
  oracle-troad:
    image: gvenzl/oracle-free:23-slim
    container_name: exaichatbot-agent-oracle-troad
    restart: unless-stopped
    ports:
      - "1521:1521"
    environment:
      # SYS / SYSTEM
      ORACLE_PASSWORD: ${ORACLE_SYS_PASSWORD:-OracleExdev!2026}
      # PDB 서비스명 → JDBC .../orcl2
      ORACLE_DATABASE: ORCL2
      # chatbotApi troad 계정
      APP_USER: OPR_MAIN
      APP_USER_PASSWORD: ${ORACLE_TROAD_PASSWORD:-test}
    volumes:
      - oracle-troad-data:/opt/oracle/oradata
      - ./oracle/init:/container-entrypoint-initdb.d:ro
    healthcheck:
      test: ["CMD", "healthcheck.sh"]
      interval: 20s
      timeout: 10s
      retries: 30
      start_period: 90s

volumes:
  oracle-troad-data:
    name: exaichatbot-agent-oracle-troad-data