1. 介質準備
1.1. 下載Oracle docker build file
近期Oracle 官方釋出了19.3 版本的docke-images 構建程式,可在這裡下載:可到github下載docker-images-master.zip
https://github.com/oracle/docker-images
將下好的docker-images-master.zip 解壓放在 /Users/myz/Docker/ 目錄下:
cd /Users/myz/Docker/docker-images-master/OracleDatabase/SingleInstance/dockerfiles/19.3.0/
1.2. 下載Oracle19c 預安裝程式
手動下載oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm ,同樣放在19.3.0/ 目錄下
下載地址:
http://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
1.3. 準備Oracle19c的安裝程式
下載19C安裝介質(可從官網) LINUX.X64_193000_db_home.zip同樣放在19.3.0/ 目錄下
其他可根據需要 把常用的安裝包也放到這個位置 下, 如我常用 rlwrap-0.42-1.el6.x86_64.rpm
2. 配置 Oracle image
2.1. 修改Dockerfile
使用自帶的oraclelinux:7-slim 及用官網介紹的方法遇到一些問題不好解決. 後來換成我常用的基礎映象centos:7.6.1810 加Oracle預安裝檔案oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm最後成功構建 .
vi Dockerfile
#FROM oraclelinux:7-slim as base
FROM centos:7.6.1810 as base
....
# Copy files needed during both installation and runtime
# -------------
COPY $SETUP_LINUX_FILE $CHECK_SPACE_FILE $INSTALL_DIR/
COPY oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm $INSTALL_DIR/
COPY rlwrap-0.42-1.el6.x86_64.rpm $INSTALL_DIR/
COPY $RUN_FILE $START_FILE $CREATE_DB_FILE $CONFIG_RSP $PWD_FILE $CHECK_DB_FILE $USER_SCRIPTS_FILE $ORACLE_BASE/
....
2.2. 修改setupLinuxEnv.sh
使用本地安裝preinstall 包, 及增加些其他常用工具包;
vi setupLinuxEnv.sh
…
mkdir -p $ORACLE_BASE/scripts/setup && \
mkdir $ORACLE_BASE/scripts/startup && \
ln -s $ORACLE_BASE/scripts /docker-entrypoint-initdb.d && \
mkdir $ORACLE_BASE/oradata && \
mkdir -p $ORACLE_HOME && \
chmod ug+x $ORACLE_BASE/*.sh && \
yum -y install oracle-database-preinstall-19c openssl && \
yum -y localinstall /opt/install/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm \
&& yum -y install openssl \
&& yum -y install openssl-devel \
&& yum -y install lsof \
&& yum -y install iproute \
&& yum -y install net-tools \
&& yum -y install rsyslog \
&& yum -y install bash-completion \
&& yum -y install tmux \
&& yum -y install lrzsz \
&& yum -y install telnet \
&& yum -y localinstall /opt/install/rlwrap-0.42-1.el6.x86_64.rpm && \
rm -rf /var/cache/yum && \
ln -s $ORACLE_BASE/$PWD_FILE /home/oracle/ && \
echo oracle:welcome1 | chpasswd && \
echo root:welcome1 | chpasswd && \
chown -R oracle:dba $ORACLE_BASE
2.3. 修改installDBBinaries.sh 檔案
vi installDBBinaries.sh
…
# Temp location
#rm -rf /tmp/* && \
…
這裡需要註釋掉 rm /tmp/* 動作, 不然會報如下錯誤:
rm: cannot remove '/tmp/ks-script-6pKh_p': Operation not permitted
rm: cannot remove '/tmp/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm': Operation not permitted
rm: cannot remove '/tmp/yum.log': Operation not permitted
Removing intermediate container 508f7c0f5041
The command '/bin/sh -c chmod ug+x $INSTALL_DIR/*.sh && sync && $INSTALL_DIR/$INSTALL_DB_BINARIES_FILE $DB_EDITION' returned a non-zero code: 1ERROR: Oracle Database Docker Image was NOT successfully created.ERROR: Check the output and correct any reported problems with the docker build operation.
2.4 .其它視需要
預設資料庫 CDB模式, 資料庫名 ORCLCDB, PDB name 為 ORCLDPB1 (可在run時指定)
其他可視需要修改 createDB.sh 及runOracle.sh
3. 構建 Oracle映象
Dockfile所在上一級目錄下下執行build
./buildDockerImage.sh -v 19.3.0 -e
大概10分鐘左右成功完成映象製作
如果過程中報錯,需要仔細檢視報錯檔案及內容進行排錯;
接下來就可以通過該映象來安裝部署Oracle19c例項....
Oracle Database on Docker
https://github.com/oracle/docker-images
Sample Docker build files to facilitate installation, configuration, and environment setup for DevOps users. For more information about Oracle Database please see the
Oracle Database Onlin
e Documentation.
How to build and run
This project offers sample Dockerfiles for:
-
Oracle Database 19c (19.3.0) Enterprise Edition and Standard Edition 2
-
Oracle Database 18c (18.4.0) Express Edition (XE)
-
Oracle Database 18c (18.3.0) Enterprise Edition and Standard Edition 2
-
Oracle Database 12c Release 2 (12.2.0.2) Enterprise Edition and Standard Edition 2
-
Oracle Database 12c Release 1 (12.1.0.2) Enterprise Edition and Standard Edition 2
-
Oracle Database 11g Release 2 (11.2.0.2) Express Edition (XE)
To assist in building the images, you can use the
buildDockerImage.sh script. See below for instructions and usage.
The
buildDockerImage.sh script is just a utility shell script that performs MD5 checks and is an easy way for beginners to get started. Expert users are welcome to directly call
docker b
uild with their prefered set of parameters.
Building Oracle Database Docker Install Images
IMPORTANT: You will have to provide the installation binaries of Oracle Database (except for Oracle Database 18c XE) and put them into the
dockerfiles/<version> folder. You only need
to provide the binaries for the edition you are going to install. The binaries can be downloaded from the [Oracle Technology Network](http://www.oracle.com/technetwork/database/enterprise-e
dition/downloads/index.html), make sure you use the linux link:
Linux x86-64. The needed file is named
linuxx64__database.zip. You also have to make sure to have internet conne
ctivity for yum. Note that you must not uncompress the binaries. The script will handle that for you and fail if you uncompress them manually!
Before you build the image make sure that you have provided the installation binaries and put them into the right folder. Once you have chosen which edition and version you want to build an
image of, go into the
dockerfiles folder and run the
buildDockerImage.sh script:
[oracle@localhost dockerfiles]$ ./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
…back 1 page
Oracle Database on Docker
Sample Docker build files to facilitate installation, configuration, and environment setup for DevOps users. For more information about Oracle Database please see the
Oracle Database Onlin
e Documentation.
How to build and run
This project offers sample Dockerfiles for:
-
Oracle Database 19c (19.3.0) Enterprise Edition and Standard Edition 2
-
Oracle Database 18c (18.4.0) Express Edition (XE)
-
Oracle Database 18c (18.3.0) Enterprise Edition and Standard Edition 2
-
Oracle Database 12c Release 2 (12.2.0.2) Enterprise Edition and Standard Edition 2
-
Oracle Database 12c Release 1 (12.1.0.2) Enterprise Edition and Standard Edition 2
-
Oracle Database 11g Release 2 (11.2.0.2) Express Edition (XE)
To assist in building the images, you can use the
buildDockerImage.sh script. See below for instructions and usage.
The
buildDockerImage.sh script is just a utility shell script that performs MD5 checks and is an easy way for beginners to get started. Expert users are welcome to directly call
docker b
uild with their prefered set of parameters.
Building Oracle Database Docker Install Images
IMPORTANT: You will have to provide the installation binaries of Oracle Database (except for Oracle Database 18c XE) and put them into the
dockerfiles/<version> folder. You only need
to provide the binaries for the edition you are going to install. The binaries can be downloaded from the [Oracle Technology Network](http://www.oracle.com/technetwork/database/enterprise-e
dition/downloads/index.html), make sure you use the linux link:
Linux x86-64. The needed file is named
linuxx64__database.zip. You also have to make sure to have internet conne
ctivity for yum. Note that you must not uncompress the binaries. The script will handle that for you and fail if you uncompress them manually!
Before you build the image make sure that you have provided the installation binaries and put them into the right folder. Once you have chosen which edition and version you want to build an
image of, go into the
dockerfiles folder and run the
buildDockerImage.sh script:
[oracle@localhost dockerfiles]$ ./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
19.3
.0
-e: creates image based
on
-s: creates image based
on
-x: creates image based
on
-i: ignores the MD5 checksums
-o: passes
on Docker build
option
*
select one edition only: -e, -s,
or -x
LICENSE UPL
1.0
Copyright (c)
2014
-2019 Oracle
and/
or its affiliates. All rights reserved.
IMPORTANT: The resulting images will be an image with the Oracle binaries installed. On first startup of the container a new database will be created, the following lines highlight when
the database is ready to be used:
DATABASE IS READY TO USE!
You may extend the image with your own Dockerfile and create the users and tablespaces that you may need.
The character set for the database is set during creating of the database. 11g Express Edition supports only UTF-8. You can set the character set for the Standard Edition 2 and Enterprise E
dition during the first run of your container and may keep separate folders containing different tablespaces with different character sets.
Running Oracle Database in a Docker container
Running Oracle Database Enterprise and Standard Edition 2 in a Docker container
To run your Oracle Database Docker image use the
docker run command as follows:
docker run --name <container name> \
-p <host port>:
1521 -p <host port>:
5500 \
-e ORACLE_SID=<your SID> \
-e ORACLE_PDB=<your PDB name> \
-e ORACLE_PWD=<your database passwords> \
-e ORACLE_CHARACTERSET=<your character
set> \
-v [<host mount point>:]/opt/oracle/oradata \
oracle/database:
19.3
.0-ee
Parameters:
--name: The name
of the container (
default:
auto generated)
-p: The port mapping
of the host port
to the container port.
Two ports are exposed:
1521 (Oracle Listener),
5500 (OEM Express)
-e ORACLE_SID: The Oracle Database SID that should be used (
default: ORCLCDB)
-e ORACLE_PDB: The Oracle Database PDB name that should be used (
default: ORCLPDB1)
-e ORACLE_PWD: The Oracle Database SYS, SYSTEM
and PDB_ADMIN password (
default:
auto generated)
-e ORACLE_CHARACTERSET:
The character
set
to use
when creating the database (
default: AL32UTF8)
-v /opt/oracle/oradata
The data volume
to use
for the database.
Has
to be writable
by the Unix
"oracle" (uid:
54321) user inside the container!
If omitted the database will
not be persisted over container recreation.
-v /opt/oracle/scripts/startup | /docker-entrypoint-initdb.d/startup
Optional: A volume
with
custom scripts
to be run after database startup.
For further details see the
"Running scripts after setup and on startup" section below.
-v /opt/oracle/scripts/setup | /docker-entrypoint-initdb.d/setup
Optional: A volume
with
custom scripts
to be run after database setup.
For further details see the
"Running scripts after setup and on startup" section below.
Once the container has been started and the database created you can connect to it just like to any other database:
sqlplus sys
/<your password>@/
/localhost:1521/<your SID>
as sysdba
sqlplus system
/<your password>@/
/localhost:1521/<your SID>
sqlplus pdbadmin
/<your password>@/
/localhost:1521/<Your PDB name>
The Oracle Database inside the container also has Oracle Enterprise Manager Express configured. To access OEM Express, start your browser and follow the URL:
https:
NOTE: Oracle Database bypasses file system level caching for some of the files by using the
O_DIRECT flag. It is not advised to run the container on a file system that does not suppor
t the
O_DIRECT flag.
Changing the admin accounts passwords
On the first startup of the container a random password will be generated for the database if not provided. You can find this password in the output line:
ORACLE PASSWORD
FOR SYS, SYSTEM
AND PDBADMIN:
The password for those accounts can be changed via the
docker exec command.
Note, the container has to be running:
docker exec
<
container
name> ./setPassword.sh
<
your
password>
Running Oracle Database 18c Express Edition in a Docker container
To run your Oracle Database 18c Express Edition Docker image use the
docker run command as follows:
docker run --name <container name> \
-p <host port>:
1521 -p <host port>:
5500 \
-e ORACLE_PWD=<your database passwords> \
-e ORACLE_CHARACTERSET=<your character
set> \
-v [<host mount point>:]/opt/oracle/oradata \
oracle/database:
18.4
.0-xe
Parameters:
--name: The name
of the container (
default:
auto generated)
-p: The port mapping
of the host port
to the container port.
Two ports are exposed:
1521 (Oracle Listener),
8080 (APEX)
-e ORACLE_PWD: The Oracle Database SYS, SYSTEM
and PDB_ADMIN password (
default:
auto generated)
-e ORACLE_CHARACTERSET:
The character
set
to use
when creating the database (
default: AL32UTF8)
-v /opt/oracle/oradata
The data volume
to use
for the database.
Has
to be writable
by the Unix
"oracle" (uid:
54321) user inside the container!
If omitted the database will
not be persisted over container recreation.
-v /opt/oracle/scripts/startup | /docker-entrypoint-initdb.d/startup
Optional: A volume
with
custom scripts
to be run after database startup.
For further details see the
"Running scripts after setup and on startup" section below.
-v /opt/oracle/scripts/setup | /docker-entrypoint-initdb.d/setup
Optional: A volume
with
custom scripts
to be run after database setup.
For further details see the
"Running scripts after setup and on startup" section below.
Once the container has been started and the database created you can connect to it just like to any other database:
sqlplus sys
/<your password>@//localhost:
1521/XE
as sysdba
sqlplus system
/<your password>@//localhost:
1521/XE
sqlplus pdbadmin
/<your password>@//localhost:
1521/XEPDB1
The Oracle Database inside the container also has Oracle Enterprise Manager Express configured. To access OEM Express, start your browser and follow the URL:
https:
On the first startup of the container a random password will be generated for the database if not provided. You can find this password in the output line:
ORACLE PASSWORD
FOR SYS
AND SYSTEM:
Note: The ORACLE_SID for Express Edition is always
XE and cannot be changed, hence there is no ORACLE_SID parameter provided for the XE build.
The password for those accounts can be changed via the
docker exec command.
Note, the container has to be running:
docker exec/opt/oracle/setPassword.sh
Running Oracle Database 11gR2 Express Edition in a Docker container
To run your Oracle Database Express Edition Docker image use the
docker run command as follows:
docker run --name <container name> \
--shm-size=
1g \
-p
1521:
1521 -p
8080:
8080 \
-e ORACLE_PWD=<your database passwords> \
-v [<host mount point>:]/u01/app/oracle/oradata \
oracle/database:
11.2
.0
.2-xe
Parameters:
--name: The name
of the container (
default:
auto generated)
--shm-size: Amount
of Linux
shared memory
-p: The port mapping
of the host port
to the container port.
Two ports are exposed:
1521 (Oracle Listener),
8080 (APEX)
-e ORACLE_PWD: The Oracle Database SYS, SYSTEM
and PDB_ADMIN password (
default:
auto generated)
-v /u01/app/oracle/oradata
The data volume
to use
for the database.
Has
to be writable
by the Unix
"oracle" (uid:
1000) user inside the container!
If omitted the database will
not be persisted over container recreation.
-v /u01/app/oracle/scripts/startup | /docker-entrypoint-initdb.d/startup
Optional: A volume
with
custom scripts
to be run after database startup.
For further details see the
"Running scripts after setup and on startup" section below.
-v /u01/app/oracle/scripts/setup | /docker-entrypoint-initdb.d/setup
Optional: A volume
with
custom scripts
to be run after database setup.
For further details see the
"Running scripts after setup and on startup" section below.
There are two ports that are exposed in this image:
-
1521 which is the port to connect to the Oracle Database.
-
8080 which is the port of Oracle Application Express (APEX).
On the first startup of the container a random password will be generated for the database if not provided. You can find this password in the output line:
ORACLE PASSWORD
FOR SYS
AND SYSTEM:
Note: The ORACLE_SID for Express Edition is always
XE and cannot be changed, hence there is no ORACLE_SID parameter provided for the XE build.
The password for those accounts can be changed via the
docker exec command.
Note, the container has to be running:
docker exec/u01/app/oracle/setPassword.sh
Once the container has been started you can connect to it just like to any other database:
sqlplus sys
/<your password>@//localhost:
1521/XE
as sysdba
sqlplus system
/<your password>@//localhost:
1521/XE
Running SQL*Plus in a Docker container
You may use the same Docker image you used to start the database, to run
sqlplus to connect to it, for example:
docker run --rm -ti oracle/database:19.3.0-ee sqlplus pdbadmin/
<
yourpassword>@//
<
db-container-ip>:1521/ORCLPDB1
Another option is to use
docker exec and run
sqlplus from within the same container already running the database:
docker exec -ti <container name> sqlplus pdbadmin
@ORCLPDB1
Running scripts after setup and on startup
The docker images can be configured to run scripts after setup and on startup. Currently
sh and
sql extensions are supported.
For post-setup scripts just mount the volume
/opt/oracle/scripts/setup or extend the image to include scripts in this directory.
For post-startup scripts just mount the volume
/opt/oracle/scripts/startup or extend the image to include scripts in this directory.
Both of those locations are also represented under the symbolic link
/docker-entrypoint-initdb.d. This is done to provide
synergy with other database Docker images. The user is free to decide whether to put the setup and startup scripts
under
/opt/oracle/scripts or
/docker-entrypoint-initdb.d.
After the database is setup and/or started the scripts in those folders will be executed against the database in the container.
SQL scripts will be executed as sysdba, shell scripts will be executed as the current user. To ensure proper order it is
recommended to prefix your scripts with a number. For example
01_users.sql,
02_permissions.sql, etc.
Note: The startup scripts will also be executed after the first time database setup is complete.
Note: Use
/u01/app/oracle/scripts/ instead of
/opt/oracle/scripts/ for Express Edition.
The example below mounts the local directory myScripts to
/opt/oracle/myScripts which is then searched for custom startup scripts:
docker run --name oracle-ee -p
1521:
1521 -v /home/oracle/myScripts:/opt/oracle/scripts/startup -v /home/oracle/oradata:/opt/oracle/oradata oracle/database:
19.
3.
0-ee
Known issues
- The
`overlay` storage driver on CentOS has proven to run into Docker bug #25409. We recommend using
btrfs or
ov<br />erlay2 instead. For more details see issue #317.
Frequently asked questions
Please see
FAQ.md for frequently asked questions.
Support
Oracle Database in single instance configuration is supported for Oracle Linux 7 and Red Hat Enterprise Linux (RHEL) 7.
For more details please see My Oracle Support note:
Oracle Support for Database Running on Docker (Doc ID 2216342.1)
License
To download and run Oracle Database, regardless whether inside or outside a Docker container, you must download the binaries from the Oracle website and accept the license indicated at that
page.
All scripts and files hosted in this project and GitHub
docker-images/OracleDatabase repository required to build the Docker images are, unless otherwise noted, released under
UPL 1.
0 license.
Copyright
Copyright (c) 2014-2019 Oracle and/or its affiliates. All rights reserved.
