# 基于的基础镜像
FROM python:3.7

# 将oracle客户端添加到镜像中
ADD ./instantclient_11_2 /oracle/instantclient_11_2

# 设置oracle相关的环境变量
ENV ORACLE_HOME=/oracle/instantclient_11_2
ENV PATH=$ORACLE_HOME:$PATH
ENV TNS_ADMIN=$ORACLE_HOME/network/admin
ENV LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
ENV NLS_LANGE="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

# 如果apt-get update 耗时很长,可以去下面两句的#解决
#RUN apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 40976EAF437D05B5
#ADD sources.list /etc/apt/sources.list
# 解决 cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library:
# "libclntsh.so: cannot open shared object file: No such file or directory".
RUN apt-get update && apt-get install -y libaio1

# 安装python访问oracle的包cx_Oracle
RUN pip install cx_Oracle -i  https://mirrors.tuna.tsinghua.edu.cn/pypi/web/simple/