txstatemws/node-oracle repository overview

⁠Notes:

Instructions for the nuances of installing the different types of Oracle instant client can be found here:
https://docs.oracle.com/en/database/oracle/oracle-database/19/lnoci/instant-client.html⁠

To update the client used please see the zip file download links here and be sure to review the LICENSING and README files within any downloaded zip files:
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html⁠

For information on configuring a tuned sqlnet.ora file see the parameters here:
https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html⁠

For information on encrypting and securing client-server communications between the Oracle client and database instances you can find a good explanation here:
https://docs.oracle.com/database/121/DBSEG/asoconfg.htm#DBSEG020⁠

For setting up Oracle's wallet TLS without needing to work out getting their GUI utilities to work over command line only interfaces you may find this guide helpful: https://questoraclecommunity.org/learn/blogs/oracle-database-network-encryption-native-vs-tls-ssl/⁠

⁠Here's an example of the Dockerfile used to build these images:

FROM node:14-buster-slim as BUILD

RUN apt-get update \
  && apt-get install -y unzip \
  && apt-get install -y wget

ENV ZIPFILE=instantclient-basiclite-linux.x64-21.1.0.0.0.zip  
ENV URL_SUBDIR=211000

RUN mkdir -p opt/oracle \
  && wget https://download.oracle.com/otn_software/linux/instantclient/${URL_SUBDIR}/${ZIPFILE} \
  && unzip  ${ZIPFILE} && rm -rf ${ZIPFILE} \
  && mv instantclient_*/* /opt/oracle/instantclient

FROM node:14-buster-slim

COPY --from=BUILD /opt/oracle/instantclient /opt/oracle/instantclient

RUN apt-get update \
  && apt-get install -y libaio1

ENV LD_LIBRARY_PATH="/opt/oracle/instantclient"

RUN echo '/opt/oracle/instantclient/' | tee -a /etc/ld.so.conf.d/oracle_instant_client.conf && ldconfig