Re: BUG #15665: ERROR: could not load library "/usr/pgsql-11/lib/oracle_fdw.so"

The following bug has been logged on the website:

Bug reference: 15665
Logged by: ramakrishnan r
Email address: prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com
PostgreSQL version: 11.1
Operating system: rhel 7.5
Description:

Hi Team,

Am not able to load the oracle_fdw.so file can you please resolve the
issue.

==========

postgres=# create extension oracle_fdw;
ERROR: could not load library "/usr/pgsql-11/lib/oracle_fdw.so":
libclntsh.so.12.1: cannot open shared object file: No such file or
directory
postgres=# \q
================

==> ls
adminpack.so dict_xsyn.so jsonb_plpython2.so
libpgtypes.so.3 pg_buffercache.so seg.so
utf8_and_euc_jp.so
amcheck.so earthdistance.so latin2_and_win1250.so
libpgtypes.so.3.11 pgcrypto.so sepgsql.so
utf8_and_euc_kr.so
ascii_and_mic.so euc2004_sjis2004.so latin_and_mic.so libpq.a
pg_freespacemap.so sslinfo.so utf8_and_euc_tw.so
auth_delay.so euc_cn_and_mic.so libecpg.a libpq.so
pgoutput.so tablefunc.so utf8_and_gb18030.so
auto_explain.so euc_jp_and_sjis.so libecpg_compat.a libpq.so.5
pg_prewarm.so tcn.so utf8_and_gbk.so
autoinc.so euc_kr_and_mic.so libecpg_compat.so
libpq.so.5.11 pgrowlocks.so tds_fdw.so
utf8_and_iso8859_1.so
bitcode euc_tw_and_big5.so libecpg_compat.so.3
libpqwalreceiver.so pg_stat_statements.so test_decoding.so
utf8_and_iso8859.so
bloom.so file_fdw.so libecpg_compat.so.3.11 llvmjit.so
pgstattuple.so timetravel.so utf8_and_johab.so
btree_gin.so fuzzystrmatch.so libecpg.so
llvmjit_types.bc pg_trgm.so tsm_system_rows.so
utf8_and_sjis2004.so
btree_gist.so hstore_plperl.so libecpg.so.6 lo.so
pg_visibility.so tsm_system_time.so utf8_and_sjis.so
citext.so hstore_plpython2.so libecpg.so.6.11
ltree_plpython2.so pgxml.so unaccent.so
utf8_and_uhc.so
cube.so hstore.so libpgcommon.a ltree.so
pgxs utf8_and_ascii.so utf8_and_win.so
cyrillic_and_mic.so insert_username.so libpgfeutils.a
moddatetime.so pkgconfig utf8_and_big5.so
uuid-ossp.so
dblink.so _int.so libpgport.a
oracle_fdw.so plpgsql.so utf8_and_cyrillic.so
dict_int.so isn.so libpgtypes.a
pageinspect.so postgres_fdw.so utf8_and_euc2004.so
dict_snowball.so jsonb_plperl.so libpgtypes.so
passwordcheck.so refint.so utf8_and_euc_cn.so

==============

[root(at)brurhenppp001 lib]# ldconfig
ldconfig: /opt/app/oracle/product/12.1.0/client_64/lib/libexpat.so.1 is not
a symbolic link

[root(at)brurhenppp001 lib]# cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/opt/app/oracle/product/12.1.0/client_64/lib

Hi,

On 2019-03-04 09:55:06 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15665
> Logged by: ramakrishnan r
> Email address: prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com
> PostgreSQL version: 11.1
> Operating system: rhel 7.5
> Description:
>
> Hi Team,
>
> Am not able to load the oracle_fdw.so file can you please resolve the
> issue.

You *repeatedly* have been told that oracle_fdw is not distributed by
the postgresql core team, and that this is thus the wrong bug reporting
form. Please don't do that, what are you trying to achieve by annoying
people that can't help you with your problem?

Greetings,

Andres Freund

On Mon, Mar 04, 2019 at 09:18:40AM -0800, Andres Freund wrote:
> You *repeatedly* have been told that oracle_fdw is not distributed by
> the postgresql core team, and that this is thus the wrong bug reporting
> form. Please don't do that, what are you trying to achieve by annoying
> people that can't help you with your problem?

Perhaps you could just begin by opening an issue on github? Here you
go with the link:
https://github.com/laurenz/oracle_fdw/issues
--
Michael