Oracle_fdw installation issue

[gaurav-pandhare]

HI Laurenz, I have installed the postgres 15 on windows and did all configuration for oracle_fdw-2.4.0 like placed oracle_fdw.dll to lib, and oracle_fdw.control and 3 sql files on extension folder as mentioned in the README file and set up the environment varibale of oci.dll. (please note i have installed Oracle 11G on my machine) but still i am getting below error while creating the EXTENSION oracle_fdw "ERROR: could not load library "C:/Program Files/PostgreSQL/15/lib/oracle_fdw.dll": The specified procedure could not be found. SQL state: 58P01".

[laurenz]

In which directory did you install the Oracle client? Is the directory with oci.dll on the PATH environment variable?

[Gpandhare]

Oracle 11G is installed in C directory and directory with oci.dll is on path environment variable.

[gaurav-pandhare]

Oracle 11G is installed in C directory and directory with oci.dll is on path environment variable.

[chrullrich]

This is the somewhat unusual case where the DLLs are there but some symbol is missing.

There is no 2.4.0 binary release for PostgreSQL 15 here on GitHub. Did you build it yourself, or are you using a binary package from somewhere else?

You did not mention which minor version of PostgreSQL 15 you are using. There was an API change between PostgreSQL 15.1 and 15.2 that means that oracle_fdw cannot be used with 15.0 and 15.1. The error would most likely be the one you are getting. See the "Installation Requirements" section in the README.

[gaurav-pandhare]

Postgres version I am using is 15.2. And I have downloaded the 2.4.0 binary from pgxn.org/dist/oracle_fdw/2.4.0

[chrullrich]

Thank you. Please excuse me if I am missing something blindingly obvious, but I cannot see binary downloads on that page. Would you mind posting the full download URL, please?

[gaurav-pandhare]

Hi , incorrect URL pasted, correct url https://github.com/laurenz/oracle_fdw/releases/tag/ORACLE_FDW_2_4_0 file name : oracle_fdw-2.4.0-pg10-win64

[gaurav-pandhare]

if it is not the correct or compatible version with Postgres 15.2 , then will you please suggest me the version compatible with said postgres 15.2

[chrullrich]

This is a binary package for PostgreSQL 10. It does not work with any other version. For PostgreSQL 15 you need a package made for that version, and there is no such package of oracle_fdw 2.4.0. There is, however, one of oracle_fdw 2.5.0 at https://github.com/laurenz/oracle_fdw/releases/download/ORACLE_FDW_2_5_0/oracle_fdw-2.5.0-pg15-win64.zip . Can you try this one?

[gaurav-pandhare]

Hey ,it worked . thanks for support . we can close this now.

[chrullrich]

Thank you for confirming.