Oracle_fdw installation issue about oracle_fdw HOT 11 CLOSED

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?

from oracle_fdw.

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

from oracle_fdw.

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

from oracle_fdw.

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

from oracle_fdw.

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.

from oracle_fdw.

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

from oracle_fdw.

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?

from oracle_fdw.

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

from oracle_fdw.

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

from oracle_fdw.

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

from oracle_fdw.

Thank you for confirming.

from oracle_fdw.