基于Docker的Node.js Azure Function连接OracleDB问题求助

I've run into this exact issue before when deploying Azure Functions with Oracle DB connectivity via Docker—here's a working Dockerfile configuration based on the mcr.microsoft.com/azure-functions/node:3.0 base image that fixes the DPI-1047 error by properly installing the Oracle Instant Client libraries:

Complete Dockerfile #

# Use official Azure Functions Node.js 3.0 base image
FROM mcr.microsoft.com/azure-functions/node:3.0

# Set Azure Function environment variables
ENV AzureWebJobsScriptRoot=/home/site/wwwroot \
    AzureFunctionsJobHost__Logging__Console__IsEnabled=true

# Install system dependencies required for Oracle Instant Client
RUN apt-get update && \
    apt-get install -y --no-install-recommends libaio1 wget unzip && \
    rm -rf /var/lib/apt/lists/*

# Define Oracle Instant Client version (adjust based on your oracledb package compatibility)
ENV ORACLE_CLIENT_VERSION=19.3.0.0.0
ENV ORACLE_HOME=/usr/lib/oracle/${ORACLE_CLIENT_VERSION}/client64
ENV LD_LIBRARY_PATH=${ORACLE_HOME}/lib:$LD_LIBRARY_PATH

# Download and extract Oracle Instant Client Basic package
RUN wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linux.x64-${ORACLE_CLIENT_VERSION}.zip && \
    unzip instantclient-basic-linux.x64-${ORACLE_CLIENT_VERSION}.zip && \
    mkdir -p /usr/lib/oracle/${ORACLE_CLIENT_VERSION} && \
    mv instantclient_${ORACLE_CLIENT_VERSION//./_} ${ORACLE_HOME} && \
    rm instantclient-basic-linux.x64-${ORACLE_CLIENT_VERSION}.zip

# Copy your Azure Function code into the image
COPY . /home/site/wwwroot

# Install npm dependencies (ensure package.json includes oracledb, express, etc.)
RUN cd /home/site/wwwroot && \
    npm install

Key Explanations #

• System Dependencies: libaio1 is a mandatory library for Oracle Instant Client to run. wget and unzip are used to fetch and extract the client package. We clean up the apt cache afterward to keep the image size small.
• Oracle Instant Client Setup: We use version 19.3 (a long-term supported release compatible with most oracledb package versions). The environment variables ORACLE_HOME and LD_LIBRARY_PATH tell the system where to find the Oracle client libraries, which resolves the DPI-1047 error.
• Azure Function Configuration: AzureWebJobsScriptRoot specifies the root directory of your function code, ensuring the Azure Functions host can correctly locate and execute your functions.
• Dependency Installation: After copying your code, we run npm install to install all required packages (including oracledb and express).

Important Notes #

• Version Compatibility: Make sure your oracledb package version is compatible with the Oracle Instant Client version you choose. For example:
  • oracledb 5.x supports Oracle Instant Client 11.2 through 21c
  • oracledb 6.x supports Oracle Instant Client 12.1 through 21c+
• Offline Builds: If you can't download the Oracle client package during Docker build (due to network restrictions), download the zip file locally first and replace the wget step with a COPY command:

  # Replace the wget step with this if using a local package
  COPY instantclient-basic-linux.x64-${ORACLE_CLIENT_VERSION}.zip .
  RUN unzip instantclient-basic-linux.x64-${ORACLE_CLIENT_VERSION}.zip && \
      mkdir -p /usr/lib/oracle/${ORACLE_CLIENT_VERSION} && \
      mv instantclient_${ORACLE_CLIENT_VERSION//./_} ${ORACLE_HOME} && \
      rm instantclient-basic-linux.x64-${ORACLE_CLIENT_VERSION}.zip
  

• Image Size Optimization: The Dockerfile already cleans up unnecessary files, but if you need an even smaller image, consider using a multi-stage build to separate the client installation from the function code.

内容的提问来源于stack exchange，提问作者Aybuke