Docker：（一）安装Oracle数据库
程序员文章站
2024-03-25 17:42:46
...
1.下载并安装Docker
-
第一步：下载docker（500M左右）
下载连接：https://download.docker.com/mac/stable/Docker.dmg -
第二步：点击Docker.dmg安装即可
-
第三步：打开终端，输入命令
docker version查看docker版本，看是否安装成功：
Client: Docker Engine - Community
Version: 18.09.2
API version: 1.39
Go version: go1.10.8
Git commit: 6247962
Built: Sun Feb 10 04:12:39 2019
OS/Arch: darwin/amd64
Experimental: false
Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?能得到上面的信息，证明docker已经安装就绪！
-
第四步：在Launchpad找到Docker图标，点击并启动
2.下载并安装Oracle 11g
第一步：使用docker search docker-oracle-xe-11g命令，搜索docker远程仓库的镜像：
终端输出结果：
AME DESCRIPTION STARS OFFICIAL AUTOMATED
docker Docker in Docker! 1024 [OK]
oraclelinux Official Docker builds of Oracle Linux. 572 [OK]
jaspeen/oracle-11g Docker image for Oracle 11g database 98 [OK]
carloscastillo/rgt-oracle-xe-11g This is a simple image based on sath89/oracl… 10 [OK]
deepdiver/docker-oracle-xe-11g 8 [OK]
pengbai/docker-oracle-xe-11g-r2 oracle xe 11g r2 with sql initdb and web con… 6 [OK]
arahman/docker-oracle-xe-11g phusion/baseimage based spin off of alexei-l… 5 [OK]
oracleinanutshell/oracle-xe-11g 5
ukhomeofficedigital/oracle-xe-11g Oracle Database Express Edition 11g Container 4 [OK]
rafaelri/docker-oracle-xe-11g Fork from wnameless/docker-oracle-xe-11g 3 [OK]
ignatov/docker-oracle-xe-11g Dockerfile of Oracle Database Express Editio… 2 [OK]
christophesurmont/oracle-xe-11g Clone of the wnameless/oracle-xe-11g. 1
epiclabs/docker-oracle-xe-11g Customized Oracle XE 11g build for CI and de… 1 [OK]
rdehuyss/docker-oracle-xe-11g Oracle Express 11g R2 on Ubuntu 14.04.2 LTS 0 [OK]
kikicarbonell/docker-oracle-xe-11g Docker image of Oracle Database Express Edit… 0 [OK]
zigac/docker-oracle-xe-11g Oracle xe 11g 0 [OK]
deradam/docker-oracle-xe-11g Oracle Express Edition 11g Release 2 on Ubun… 0
jeromefromcn/docker-oracle-xe-11g docker-oracle-xe-11g 0 [OK]
webdizz/oracle-xe-11g-sa This is a simple image based on sath89/oracl… 0 [OK]
gswteam/docker-oracle-xe-11g Oracle XE 11g 0 [OK]
ambientdocker/docker-oracle-xe-11g oracle-xe-11g image 0 [OK]
deadok22/docker-oracle-xe-11g docker-oracle-xe-11g 0
konnecteam/docker-oracle-xe-11g Fork of https://github.com/wnameless/docker-… 0 [OK]
lynxsolutions/docker-oracle-xe-11g docker-oracle-xe-11g 0 [OK]
nguoianphu/docker-oracle-xe-11g Oracle Express Edition 11g Release 2 on Ubun… 0 [OK]
第二步：下载oracle 11g 输入如下命令：(用的是阉割版的docker-oracle-xe-11g，大家可根据自己的口味选取)
docker pull alexeiled/docker-oracle-xe-11g
命令解释：pull 是Docker 容器的拉取命令alexeiled/docker-oracle-xe-11g 为镜像的完整名字
终端消息：显示下载的状态
Using default tag: latest
latest: Pulling from alexeiled/docker-oracle-xe-11g
759d6771041e: Pulling fs layer
8836b825667b: Pulling fs layer
c2f5e51744e6: Pulling fs layer
a3ed95caeb02: Pull complete
787648ea7b44: Pull complete
46f20000ce59: Pull complete
2a190e47ca3f: Pull complete
f8043f470a85: Pull complete
0f6111a00dd6: Pull complete
deacbfda2b11: Pull complete
6eb979936fa3: Pull complete
5194f2505f56: Pull complete
a63e30990791: Pull complete
994cf2ce199e: Pull complete
5eba4c64e295: Pull complete
01227e9ca0a6: Pull complete
076b6fa27478: Pull complete
d6407a7221b5: Pull complete
bbc5a28168da: Pull complete
dd783b45fa26: Pull complete
0a686089bc7e: Pull complete
73fac5e681c5: Pull complete
afaede9e60b1: Pull complete
a5d9cef8ef2a: Pull complete
32bcfcf46e45: Pull complete
aa896f927427: Pull complete
f99ab5aba6e5: Pull complete
Digest: sha256:35448e199115012a742ff9098da3287c666ce52d18efcf4658e0437892ed3ee6
Status: Downloaded newer image for alexeiled/docker-oracle-xe-11g:latest下载完成后，启动镜像为容器：
aiuiot:~ root# docker run -h "oracle" --name "oracle" -d -p 49160:22 -p 49161:1521 -p 49162:8080 alexeiled/docker-oracle-xe-11gdocker run -h "oracle" --name "oracle" -d -p 49160:22 -p 49161:1521 -p 49162:8080 alexeiled/docker-oracle-xe-11g
3、进入容器并启动Oracle
第一步：在终端中执行命令进入容器：
aiuiot:~ root# docker exec -it 0677fc709d77 /bin/bash
其中0677fc709d77是容器id，可使用docker ps命令获得：
aiuiot:~ root# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
0677fc709d77 alexeiled/docker-oracle-xe-11g "/bin/sh -c /start.sh" 5 minutes ago Up 5 minutes 0.0.0.0:49160->22/tcp, 0.0.0.0:49161->1521/tcp, 0.0.0.0:49162->8080/tcp oracle
aiuiot:~ root# docker exec -it 0677fc709d77 /bin/bash进入容器后，输入sqlplus system/oracle命令登录：
aaa@qq.com:/# sqlplus system/oracle
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jan 8 08:46:58 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production4.创建用户并分配权限
查看用户：
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
SYS
ANONYMOUS
SYSTEM
APEX_PUBLIC_USER
APEX_040000
XS$NULL
OUTLN
FLOWS_FILES
MDSYS
CTXSYS
XDB
USERNAME PASSWORD
------------------------------ ------------------------------
HR
12 rows selected.创建新用户：用户名为 deque 密码 123
SQL> create user deque identified by 123;
User created.输入命令select * from all_users;查看是否有用户deque:
SQL> select * from all_users;
USERNAME USER_ID CREATED
------------------------------ ---------- ---------
XS$NULL 2147483638 28-AUG-11
DEQUE 48 08-JAN-19
APEX_040000 47 28-AUG-11
APEX_PUBLIC_USER 45 28-AUG-11
FLOWS_FILES 44 28-AUG-11
HR 43 28-AUG-11
MDSYS 42 28-AUG-11
ANONYMOUS 35 28-AUG-11
XDB 34 28-AUG-11
CTXSYS 32 28-AUG-11
OUTLN 9 28-AUG-11
USERNAME USER_ID CREATED
------------------------------ ---------- ---------
SYSTEM 5 28-AUG-11
SYS 0 28-AUG-11
13 rows selected.4.1 给新创建的用户授权
给用户deque赋予connect,resource角色，这俩角色含有许多权限.connect:是保证该用户能连接数据库;resource:是该用户可以使用数据库资源。
输入命令grant connect,resource to deque;
SQL> grant connect,resource to deque;
Grant succeeded.连接到
5.删除用户
因为oracle数据库是基于用户去创建表，如果想删除自己创建的用户，可用命令是：drop user deque；
注意:分号不可少，且当前连接数据库的用户必须具有删除用户权限（如sys）。
6.在Docker 停止或启动服务
docker stop oracle 停止oracle
docker start oracle 启动oracle
7、常用命令
-
docker ps查看正在运行的容器
常见问题：
1、Docker未正常启动
命令行提示信息：
Cannot connect to the Docker daemon at unix:
///var/run/docker.sock. Is the docker daemon running?解决：启动你的Docker
2、未正常拉取镜像，仓库不存在或者需要登录
Using default tag:
latest Error response from daemon:
pull access denied for alexeiled/docker-oracle-xe-11g,
repository does not exist or may require 'docker login'错误提示：使用默认标记：
来自守护程序的最新错误响应：
拒绝对 alexeled/docker-oracle-xe-11g 的拉入访问，
存储库不存在，或者可能需要“Docker登录”
解决方案：
① 在终端输入登录命令docker login登录docker账号
Login with your Docker ID to push and pull images from Docker Hub. If you don't have a Docker ID, head over to https://hub.docker.com to create one.
Username: aiuiot
Password:
Login Succeeded② 使用搜索命令docker search docker-oracle-xe-11g搜索仓库有用的镜像，并拉取
参考：
https://www.jianshu.com/p/b867263995b5