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