Docker-Oracle 部署文档

前提最新版Docker安装好，配置阿里云镜像库
# 获取镜像
docker pull registry.cn-hangzhou.aliyuncs.com/qida/oracle-xe-11g

# 运行命令
docker run --name oracle11g -d -p 1521:1521 -v /docker/oracle/v/oradata/:/u01/app/oracle/oradata/oracle11g-data/ -e ORACLE_ALLOW_REMOTE=true --restart=always registry.cn-hangzhou.aliyuncs.com/qida/oracle-xe-11g

# 进入容器：
docker exec -it oracle11g bash

# 安装好的 Oracle 默认参数
- 系统用户：root 密码：admin
- 数据库链接
    - hostname: localhost
    - port: 1521
    - sid: xe
    - username: system
    - password: oracle

切换用户：su oracle
进入SQL交互：sqlplus / as sysdba

# 创建数据库用户
create user fdm identified by qwe123;
# 授权给用户
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO fdm;