docker compose oracle12c

docker-compose.yaml

version: "3"

services:
  oracle:
    image: sath89/oracle-12c
    container_name: oracle
    volumes:
      - "./docker_data:/external_data"
    networks:
      - oracle
    ports:
      - 1521:1521
      - 8080:8080
    environment:
      - DBCA_TOTAL_MEMORY=512 # 单位: MB
    # command: /bin/sh

networks:
  oracle:

启动docker

mkdir docker_data
# 放置数据到docker_data
sudo docker-compose up -d
sudo docker-compose logs -f

数据库连接配置

Host: localhost
Port: 1521
Database.ServiceName: xe.oracle.docker
Database.SID: xe
Username: system
Password: oracle

sqlplus登录数据库

sqlplus system/oracle@localhost:1521/xe.oracle.docker

web控制台 Oracle Application Express web management console

http://localhost:8080/apex
workspace: INTERNAL
user: ADMIN
password: 0Racle$
new-password: 00Racle$$

web控制台 Oracle Enterprise Management console

http://localhost:8080/em
user: sys
password: oracle
connect as sysdba: true