Oracle
=========


docker中运行oracle数据库
----------------------------------

.. code-block:: bash

    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


.. code-block:: 

    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.


.. code-block:: 

    docker run 


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

.. note:: 

    最好下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数据源即可。