apxchpwd.sql about oracle-apex-docker-stack HOT 2 OPEN

    volumes:
      - apex-vol:/opt/oracle/apex

services:
  auto-xe-reg:
    container_name: auto-xe-reg
    image: gvenzl/oracle-xe
    ports: 
      - 1521:1521
    environment:
      - ORACLE_PASSWORD=PASSWORDHERE
    volumes:
      - apex-vol:/opt/oracle/apex
    hostname: database
    healthcheck:
      test: ["CMD", "healthcheck.sh"]
      interval: 30s
      timeout: 10s
      retries: 100
  auto-ords-reg:
    container_name: auto-ords-reg
    restart: always
    depends_on:
      auto-xe-reg:
        condition: service_healthy
    volumes:
      - ./ords_secrets:/opt/oracle/variables
      - apex-vol:/opt/oracle/apex
      - ords-config-reg:/etc/ords/config
    ports:
      - 8181:8181
    image: container-registry.oracle.com/database/ords:latest
volumes:
  ords-config-reg:
    name: ords-config-reg
  apex-vol:
    name: apex-vol
networks:
  default:
    name: database-network

docker exec -it auto-xe-reg bash
cd /opt/oracle/apex/23.1.0/
sqlplus / as sysdba
ALTER SESSION SET CONTAINER = XEPDB1;
@apxchpwd.sql