FROM centos:8
WORKDIR /app
RUN sed -i -e "s|mirrorlist=|#mirrorlist=|g" /etc/yum.repos.d/CentOS-* && \
    sed -i -e "s|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g" /etc/yum.repos.d/CentOS-*

RUN yum install -y \
unixODBC-devel \
libnsl \
dos2unix \
libaio && \
yum clean all && \
rm -rf /var/cache/yum

ADD https://download.oracle.com/otn_software/linux/instantclient/2340000/oracle-instantclient-basic-23.4.0.24.05-1.el8.x86_64.rpm basic.rpm
ADD https://download.oracle.com/otn_software/linux/instantclient/2340000/oracle-instantclient-sqlplus-23.4.0.24.05-1.el8.x86_64.rpm sqlplus.rpm
ADD https://download.oracle.com/otn_software/linux/instantclient/2340000/oracle-instantclient-tools-23.4.0.24.05-1.el8.x86_64.rpm tools.rpm

RUN rpm -i *.rpm && \
    rm -rf *

ENV ORACLE_HOME /usr/lib/oracle/23.4/client64
ENV LD_LIBRARY_PATH $ORACLE_HOME/lib
ENV PATH $ORACLE_HOME/bin:$PATH