Oracle (oci8) Extension Problem With AMD64 Libraries

[devilslane-com]

So this isn't a straightforward support request as i realise it's a bit off-topic, but i'm hoping it might save someone else the trouble. I've used these production images a few times and they're great. The most esoteric i've had to get was installing the MongoDB extension, but it was simple. At work we rely on Oracle, and there's no getting out of it. Installing the PHP extension's been tricky, but generally possible - in so small part to the guidance here: https://gist.github.com/milo/d4a15d67e6538bf82438babc39482b80 .

The process is:

1. Download the Instantclient libraries from Oracle: https://www.oracle.com/database/technologies/instant-client/linux-arm-aarch64-downloads.html
2. Build using PECL or manually.

Oracle does some weird things with the naming and versioning of the object files in their release, which means you have to unzip all the symlinks in their place. For AMD, that means v19.22 of the client, compared to v21 for other distros.

Here's the extended Dockerfile:

FROM serversideup/php:8.2-fpm-nginx

# Place to store the Oracle files
RUN mkdir /opt/oracle;

RUN curl -X GET 'https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linux-arm64.zip' -o /opt/oracle/instantclient-basic-linux-arm64.zip && curl -X GET 'https://download.oracle.com/otn_software/linux/instantclient/instantclient-sdk-linux-arm64.zip' -o /opt/oracle/instantclient-sdk-linux-arm64.zip;

COPY oci8-3.3.0 /opt/oracle/oci8 # This is optional, you can use PECL

# Install basics
RUN set -ex; \
    apt update; \
    apt -y install php8.2-dev wget unzip libaio1;

# unzips to instantclient_19_22, and causes huge problems with overwriting
RUN unzip -o /opt/oracle/instantclient-basic-linux-arm64.zip -d /opt/oracle/basic
RUN unzip -o /opt/oracle/instantclient-sdk-linux-arm64.zip -d /opt/oracle/sdk

# Merge the folders
RUN mv /opt/oracle/basic/instantclient_19_22 /opt/oracle/instantclient
RUN mv /opt/oracle/sdk/instantclient_19_22/sdk /opt/oracle/instantclient/sdk

# Tell the compiler where to find the libraries it needs
RUN export ORACLE_HOME=/opt/oracle/instantclient
RUN export LD_LIBRARY_PATH=/opt/oracle/instantclient:$LD_LIBRARY_PATH

# Clean up
RUN rm /opt/oracle/*.zip && rm -rf /opt/oracle/basic && rm -rf /opt/oracle/sdk

WORKDIR /opt/oracle/oci8
RUN phpize8.2
RUN ./configure --with-oci8=instantclient,/opt/oracle/instantclient --with-php-config=/usr/bin/php-config8.2
RUN make LDFLAGS='-L/opt/oracle/instantclient' && make install

RUN echo "extension=oci8.so" | tee -a /etc/php/8.2/mods-available/oci8.ini;
RUN echo "extension=oci8.so" | tee -a /etc/php/8.2/cli/conf.d/20-oci8.ini;
RUN echo "extension=oci8.so" | tee -a /etc/php/8.2/fpm/conf.d/20-oci8.ini;
RUN phpenmod -v 8.2 oci8
RUN apt -y remove php8.2-dev

Which works fine, until you get to the make command on either the PECL or from source on any of these images:

/usr/bin/ld: skipping incompatible /opt/oracle/instantclient/libclntsh.so when searching for -lclntsh
/usr/bin/ld: cannot find -lclntsh: No such file or directory
/usr/bin/ld: skipping incompatible /opt/oracle/instantclient/libclntsh.so when searching for -lclntsh
collect2: error: ld returned 1 exit status
make: *** [Makefile:232: oci8.la] Error 1
``

The file `lclntsh.so` is definitely in the distribution, but `make` doesn't like it at all and refuses to use it because it's incompatible. Symlinking manually doesn't work, neither does unzipping or downloading. 

Can anyone shed any light on how to fix it on Amd64/Arch?

Any ideas?

[jaydrogers]

Have you tried using our new beta images and installing with the new extension method? https://serversideup.net/open-source/docker-php/docs/guide/installing-additional-php-extensions

[devilslane-com]

Thanks Jay!

That's definitely the way i found worked with Alpine. For those who might encounter this in future, here are the two ways to do it without the ability to switch image, with the long way around:

Notes:

• This obviously inflates the size of the container
• Assumes you have downloaded a copy of php-pear.phar to a subdirectory named php/

Method 1: Native PHP images (Alpine)

FROM php:8.2-cli-alpine3.19

ADD --chmod=0755 https://github.com/mlocati/docker-php-extension-installer/releases/latest/download/install-php-extensions /usr/local/bin/

# Add PEAR in, just in case
COPY php/go-pear.phar .
RUN php go-pear.phar && pecl channel-update pear.php.net

RUN install-php-extensions ldap oci8 pdo_oci @composer

Method 2: Pain

• Assumes you have downloaded copies of the AMD instantclient files (basic + sdk) and have a copy of the OCI8 pecl source code also copied in. The same error results running pecl install oci8.

This always ends with this problem, one way or another:

4.049 /usr/bin/ld: skipping incompatible /opt/oracle/instantclient/libclntsh.so when searching for -lclntsh
4.049 /usr/bin/ld: cannot find -lclntsh: No such file or directory
4.050 /usr/bin/ld: skipping incompatible /opt/oracle/instantclient/libclntsh.so when searching for -lclntsh

FROM serversideup/php:8.2-fpm-nginx

# Developed from https://gist.github.com/milo/d4a15d67e6538bf82438babc39482b80
# Config vars here: https://serversideup.net/open-source/docker-php/docs/reference/environment-variable-specification
# The files have to be unzipped here because they contain symlinks within the zip file the compiler expects to be there.
# This image is the base AMD/ARM64 PHP8.2 FPM container (175MB), but with the Oracle PHP extension (oci8 3.3.0) installed into it. Which increases its size by 300%, not including php-dev deps.
# Note: this image is based on 64-bit Debian Alpine (amd64), so it is NOT an Ubuntu or x86 64-bit package like Laravel Sail. It needs the 19.22 AMD client libraries from Oracle (not 21)

# Place to store the Oracle files
RUN mkdir /opt/oracle;

COPY docker/production/go-pear.phar .
RUN php go-pear.phar && pecl channel-update pear.php.net

# Get the zips and ext src from the repo rather than download
COPY docker/production/instantclient-sdk-linux-arm64.zip /opt/oracle/instantclient-sdk-linux-arm64.zip
COPY docker/production/instantclient-basic-linux-arm64.zip /opt/oracle/instantclient-basic-linux-arm64.zip
COPY docker/production/oci8-3.3.0 /opt/oracle/oci8

# Install basics
RUN apt-get update && \
    apt-get install -y build-essential gcc make autoconf libtool pkg-config re2c bison libc6-dev gobjc++

# Install PHP development files
RUN apt-get install -y php-dev

# Debug: Print system architecture
RUN echo "System Architecture: $(uname -m)"

# unzips to instantclient_19_22, and causes huge problems with overwriting
RUN unzip -L -o /opt/oracle/instantclient-basic-linux-arm64.zip -d /opt/oracle/basic
RUN unzip -L -o /opt/oracle/instantclient-sdk-linux-arm64.zip -d /opt/oracle/sdk

# Merge the folders
RUN mv /opt/oracle/basic/instantclient_19_22 /opt/oracle/instantclient
RUN mv /opt/oracle/sdk/instantclient_19_22/sdk /opt/oracle/instantclient/sdk

RUN echo /opt/oracle/instantclient > /etc/ld.so.conf.d/oracle-instantclient.conf
RUN ldconfig

# Create symbolic links for Oracle Instant Client libraries if they don't exist
RUN if [ ! -e /opt/oracle/instantclient/libclntsh.so ]; then \
    ln -s /opt/oracle/instantclient/libclntsh.so.19.1 /opt/oracle/instantclient/libclntsh.so; \
    fi
RUN if [ ! -e /opt/oracle/instantclient/libocci.so ]; then \
    ln -s /opt/oracle/instantclient/libocci.so.19.1 /opt/oracle/instantclient/libocci.so; \
    fi

# Set LD_LIBRARY_PATH
# Set the Instant Client path
ENV INSTANT_CLIENT_PATH=/opt/oracle/instantclient
ENV LD_LIBRARY_PATH=$INSTANT_CLIENT_PATH:$LD_LIBRARY_PATH
ENV ORACLE_HOME=/opt/oracle/instantclient

# Clean up
RUN rm /opt/oracle/*.zip && rm -rf /opt/oracle/basic && rm -rf /opt/oracle/sdk

WORKDIR /opt/oracle/oci8

RUN phpize && \
    ./configure --with-oci8=instantclient,$INSTANT_CLIENT_PATH \
        --with-pic CFLAGS=-fPIC && \
    make && \
    make install || (cat config.log && false)

[devilslane-com]

Also - this is directly from the docs on the site:

FROM serversideup/php:8.2.12-fpm-nginx-bookworm

RUN install-php-extensions ldap oci8 pdo_oci @composer

Result:

[+] Building 0.6s (2/2) FINISHED                                                                                                      docker:default
 => [internal] load build definition from Dockerfile                                                                                            0.0s
 => => transferring dockerfile: 141B                                                                                                            0.0s 
 => ERROR [internal] load metadata for docker.io/serversideup/php:8.2.12-fpm-nginx-bookworm                                                     0.5s 
------
 > [internal] load metadata for docker.io/serversideup/php:8.2.12-fpm-nginx-bookworm:
------
Dockerfile:1
--------------------
   1 | >>> FROM serversideup/php:8.2.12-fpm-nginx-bookworm
   2 |
   3 |     RUN install-php-extensions ldap oci8 pdo_oci @composer
--------------------
ERROR: failed to solve: serversideup/php:8.2.12-fpm-nginx-bookworm: docker.io/serversideup/php:8.2.12-fpm-nginx-bookworm: not found

Fix with:

FROM serversideup/php:beta-8.2-fpm-nginx-bookworm