Not able to create extension oracle_fdw

[barkowich]

Getting this error: secure_data=# CREATE EXTENSION oracle_fdw; ERROR: could not load library "/usr/lib/postgresql/15/lib/oracle_fdw.so": /usr/lib/postgresql/15/lib/oracle_fdw.so: undefined symbol: getRTEPermissionInfo

postgres@dev-pg-stats01:~$ ls -lhtr /usr/lib/postgresql/15/lib/oracle_fdw.so -rwxr-xr-x 1 root root 606K Dec 13 16:38 /usr/lib/postgresql/15/lib/oracle_fdw.so

postgres@dev-pg-stats01:/usr/share/postgresql/15/extension$ ls -alhtr oracle_fdw* -rw-r--r-- 1 root root 133 Dec 13 16:55 oracle_fdw.control -rw-r--r-- 1 root root 1.3K Dec 13 16:55 oracle_fdw--1.2.sql -rw-r--r-- 1 root root 240 Dec 13 16:55 oracle_fdw--1.1--1.2.sql -rw-r--r-- 1 root root 231 Dec 13 16:55 oracle_fdw--1.0--1.1.sql

postgres@dev-pg-stats01:~$ echo $PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/usr/lib/oracle/19.21/client64/lib/:/usr/lib/postgresql/15/bin

postgres=# select version(); version PostgreSQL 15.5 (Ubuntu 15.5-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit

i currently tried this solution ( https://github.com/laurenz/oracle_fdw/issues/630 ) but not working as i guess. Any other solution Thank you for your help.

[laurenz]

This is an exact duplicate of #630, so see that ticket for the solution.

[laurenz]

Can we close this issue, or do you need more help?

[barkowich]

yea2 sure