Docker 安装 Oracle 11g
进入( docker/mysql 没有就创建)
cd /usr/local/docker/mysql
1
编辑 docker-compose.yml
vi docker-compose.yml
1
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
当前镜像默认oracle账号和密码
ip:1521/xe
system
oracle
1
2
3
2
3
Oracle创建用户
create user root identified by 123456;
grant connect,resource, dba to root;
1
2
3
2
3
修改密码规则策略为密码永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
1
修改数据库最大连接数据
alter system set processes=2000 scope=spfile;
1