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.ramakrishnan.ap@nielsen.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@brurhenppp001 lib]# ldconfig
ldconfig: /opt/app/oracle/product/12.1.0/client_64/lib/libexpat.so.1 is not
a symbolic link

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