docker 安装 Oracle

安装

https://hub.docker.com/r/loliconneko/oracle-ee-11g

docker pull loliconneko/oracle-ee-11g

启动

docker run 命令

docker run -h "oracle" --name "oracle" -d -p 1521:1521 loliconneko/oracle-ee-11g

docker-compose 启动

oracle.yml

version: '3.1'

services:
  oracle-ee-11g:
    image: loliconneko/oracle-ee-11g
    ports:
      # - 1522:8080
      - 1521:1521
    volumes:
      - /var/docker/oracle:/u01/app/oracle

启动

docker-compose -f oracle.yml up

进入容器

docker exec -it <container_id> /bin/bash

登录oracle

sqlplus sysdba/oracle
# 账号/密码
system/oracle

查看用户

select username,password from dba_users;

创建用户

create user <user_name> identified by <password>;

给用户授权

grant connect,resource to <user_name>;

connect 是保证该用户能连接数据库
resource 是该用户可以使用数据库资源

所有权限

grant all privileges to <user_name>;

删除用户

drop user deque

链接

jdbc:oracle:thin:@<ip>:<port>:EE.oracle.docker
或者
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip>)(PORT=<port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=EE.oracle.docker)))