由于学习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
所需软件
需要安装的软件如下:
- Docker
- Git
- oracle12c(12.2.0.1)压缩包(约3G)
安装过程
-
下载oracle开源docker镜像制作脚本库, 生成目录docker-images/
git clone https://github.com/oracle/docker-images.git
-
将已经下载好的压缩包linuxx64_12201_database.zip放入docker-images/OracleDatabase/SingleInstance/dockerfiles/12.2.0.1/目录下。
-
执行脚本进入目录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
- 创建容器
- 设置数据库存储目录
$ 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>