Docker+OracleDB

由于学习Java的原因，需要安装oracle数据库…
在网上搜了一些解决方案，最终看中了docker+，没办法，简单！！还不用动脑子。

参考

就是这篇文章: 安装 oracle12c-docker

安装环境

我的开发环境为:

$ uname -a
Linux light-Inspiron-3559 4.18.0-15-generic #16~18.04.1-Ubuntu SMP Thu Feb 7 14:06:04 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux

所需软件

需要安装的软件如下:

1. Docker
2. Git
3. oracle12c(12.2.0.1)压缩包(约3G)

安装过程

1. 下载oracle开源docker镜像制作脚本库, 生成目录docker-images/
   git clone https://github.com/oracle/docker-images.git

2. 将已经下载好的压缩包linuxx64_12201_database.zip放入docker-images/OracleDatabase/SingleInstance/dockerfiles/12.2.0.1/目录下。

3. 执行脚本进入目录docker-images/OracleDatabase/SingleInstance/dockerfiles/，执行脚本./buildDockerImage.sh

$ ./buildDockerImage.sh -h

Usage: buildDockerImage.sh -v [version] [-e | -s | -x] [-i] [-o] [Docker build option]
Builds a Docker Image for Oracle Database.
  
Parameters:
   -v: version to build ## 压缩包版本号
       Choose one of: 11.2.0.2  12.1.0.2  12.2.0.1  18.3.0  18.4.0  
   -e: creates image based on 'Enterprise Edition' ## 商业版
   -s: creates image based on 'Standard Edition 2'
   -x: creates image based on 'Express Edition'
   -i: ignores the MD5 checksums ## 忽视MD5检验和
   -o: passes on Docker build option

* select one edition only: -e, -s, or -x

LICENSE UPL 1.0

Copyright (c) 2014-2018 Oracle and/or its affiliates. All rights reserved.

$ ./buildDockerImage.sh -v 12.2.0.1 -e -i

$ docker images
REPOSITORY          TAG                 IMAGE ID            CREATED              SIZE
oracle/database     12.2.0.1-ee         699bb39e21a3        About a minute ago   6.11GB

4. 创建容器

• 设置数据库存储目录

$ mkdir db/docker-oracle-data -p -v
mkdir: created directory 'db'
mkdir: created directory 'db/docker-oracle-data'
$
$ chmod 777 -R db/docker-oracle-data -v
mode of 'db/docker-oracle-data' changed from 0755 (rwxr-xr-x) to 0777 (rwxrwxrwx)

• 创建容器

$ docker run --name oracle12c \
-p 1521:1521 -p 5500:5500 \
-v  ~/db/docker-oracle-data:/opt/oracle/oradata \
oracle/database:12.2.0.1-ee

修改密码
$ docker exec oracle12c ./setPassword.sh helloworld

登录

$ docker exec -ti oracle12c /bin/bash -c "sqlplus system/helloworld@localhost:1521/orclcdb"

SQL*Plus: Release 12.2.0.1.0 Production on Sun Feb 24 12:58:31 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Sun Feb 24 2019 12:47:10 +00:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>