12.4. Oracle
12.4.1. docker中运行oracle数据库
git clone https://github.com/oracle/docker-images.git
cd docker-images/OracleDatabase/SingleInstance/dockerfiles
cp ~/Downloads/oracle-xe-11.2.0-1.0.x86_64.rpm.zip 11.2.0.2/
./buildContainerImage.sh -v 11.2.0.2 -x
Building image 'oracle/database:11.2.0.2-xe' ...
[+] Building 1158.3s (8/8) FINISHED docker:default
=> [internal] load build definition from Dockerfile.xe 0.0s
=> => transferring dockerfile: 3.64kB 0.0s
=> [internal] load metadata for docker.io/library/oraclelinux:7-slim 0.4s
=> [internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [internal] load build context 0.0s
=> => transferring context: 188B 0.0s
=> CACHED [1/3] FROM docker.io/library/oraclelinux:7-slim@sha256:09e76dbbb70c3fd3496bebbb7dd00811371d7e509a2e8179e219d3909070f744 0.0s
=> [2/3] COPY oracle-xe-11.2.0-1.0.x86_64.rpm.zip xe.rsp runOracle.sh setPassword.sh checkDBStatus.sh /install/ 0.5s
=> [3/3] RUN yum -y install unzip libaio bc initscripts net-tools openssl compat-libstdc++-33 && rm -rf /var/cache/yum && cd $INSTALL_DIR && unzip $INSTALL_FILE_1 && rm $INSTAL 1154.7s
=> exporting to image 2.6s
=> => exporting layers 2.6s
=> => writing image sha256:bca01f5a33fb62a70765bcfcdee6cf913e1593adb8edc5cd0e5c1841539e6103 0.0s
=> => naming to docker.io/oracle/database:11.2.0.2-xe 0.0s
Oracle Database container image for 'xe' version 11.2.0.2 is ready to be extended:
--> oracle/database:11.2.0.2-xe
Build completed in 1158 seconds.
docker run
12.4.2. ODBC访问Oracle数据库
安装说明： https://www.oracle.com/cn/database/technologies/releasenote-odbc-ic.html
下载Oracle Instant Client的Base Package和ODBC Package。
下载地址：https://www.oracle.com/cn/database/technologies/instant-client/microsoft-windows-32-downloads.html
备注
最好下32位版本的，64位版本的，可能在某些软件中不支持，例如PD。
将下列压缩包解压到C盘根路径上。
instantclient-basic-nt-21.13.0.0.0dbru.zip instantclient-odbc-nt-21.13.0.0.0dbru.zip
运行C:/odbc_install.exe。
剩下的就是去Windows的ODBC数据源配置中添加Oracle数据源即可。