odpi for Debian -------------- Installation notes from the documentation (more in the odpic-doc package): This library requires a (non-free) Oracle client to be installed on the same machine. The simplest one is the Oracle Instant Client which you can obtain from: If Oracle Client libraries are not found, the error "DPI-1047: Cannot locate an Oracle Client library" is raised. If an Oracle Client library is found but the version cannot be determined, the error "DPI-1072: the Oracle Client library version is unsupported" is raised. For example, this could be because the Oracle Client library version is too old (prior to 10g) or entirely unsupported (such as Oracle Client 19 on Windows 7). If the member dpiContextCreateParams.oracleClientLibDir is specified when calling dpiContext_createWithParams(), then only that directory is searched for the Oracle Client libraries. If no directory is specified, then the Oracle Client libraries are looked for in the same directory that the ODPI-C library (or application binary) is located in. If they are not found, then they are searched for in the standard operating system search path, for example PATH on Windows or LD_LIBRARY_PATH on Linux. See standard Windows library search order or standard Linux library search order. Finally, on platforms other than Windows, $ORACLE_HOME/lib is also searched. When using Instant Client on Linux and related operating systems, then that directory must always be in the system library search path. When using the library directory from a full client or database installation, then you additionally need to set the application environment to use this software, for example by setting the ORACLE_HOME environment variable. This should be done prior to ODPI-C initialization. Make sure the application has directory and file access permissions for the Oracle Client libraries. On Linux ensure libclntsh.so exists. On macOS ensure libclntsh.dylib exists. ODPI-C will not directly load libclntsh.*.XX.1 files in dpiContextCreateParams.oracleClientLibDir or from the directory where the ODPI-C library (or application binary) is. Note other files used by libclntsh* are also required. To trace the loading of Oracle Client libraries, the environment variable DPI_DEBUG_LEVEL can be set to 64 before starting your application. -- Joseph Nahmias Tue, 02 Feb 2022 06:01:00 -0500