Docker 安装 Oracle 11g

Docker 安装 Oracle 11g

进入( docker/mysql 没有就创建)

cd /usr/local/docker/mysql

编辑 docker-compose.yml

vi docker-compose.yml

version: '3.1'
services:
  oracle:
    image: docker.io/jaspeen/oracle-xe-11g
    container_name: oracle11g
    privileged: true
    restart: always
    environment:
      - TZ=Asia/Shanghai
      - ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
    volumes:
      - ./data:/u01/app/oracle
    ports:
      - 1521:1521

当前镜像默认oracle账号和密码

ip:1521/xe 
system
oracle

Oracle创建用户

create user root identified by 123456;

grant connect,resource, dba to root;

修改密码规则策略为密码永不过期

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;    

修改数据库最大连接数据

alter system set processes=2000 scope=spfile;