BUG #15650: oracle_fdw issue - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      15650
Logged by:          ramakrishnan r
Email address:      prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 11.1
Operating system:   rhel 7.5
Description:

Hi Team,

we facing some issue while creating oracle_fdw please find the below steps
and please need do the needful.

==> export PATH=/opt/app/oracle/product/12.1.0/client_64/bin:$PATH
postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==> export ORACLE_HOME=/opt/app/oracle/product/12.1.0/client_64/
postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==> export LD_LIBRARY_PATH=$ORACLE_HOME/lib
postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==>
postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==> make
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wmissing-format-attribute -Wformat-security
-fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong
--param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC
-I/opt/app/oracle/product/12.1.0/client_64//sdk/include
-I/opt/app/oracle/product/12.1.0/client_64//oci/include
-I/opt/app/oracle/product/12.1.0/client_64//rdbms/public
-I/usr/include/oracle/12.2/client -I/usr/include/oracle/12.2/client64
-I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64
-I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64
-I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64
-I/usr/include/oracle/10.2.0.5/client
-I/usr/include/oracle/10.2.0.5/client64
-I/usr/include/oracle/10.2.0.4/client
-I/usr/include/oracle/10.2.0.4/client64
-I/usr/include/oracle/10.2.0.3/client
-I/usr/include/oracle/10.2.0.3/client64 -I. -I./
-I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal
-D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o oracle_utils.o
oracle_utils.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wmissing-format-attribute -Wformat-security
-fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong
--param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC
-I/opt/app/oracle/product/12.1.0/client_64//sdk/include
-I/opt/app/oracle/product/12.1.0/client_64//oci/include
-I/opt/app/oracle/product/12.1.0/client_64//rdbms/public
-I/usr/include/oracle/12.2/client -I/usr/include/oracle/12.2/client64
-I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64
-I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64
-I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64
-I/usr/include/oracle/10.2.0.5/client
-I/usr/include/oracle/10.2.0.5/client64
-I/usr/include/oracle/10.2.0.4/client
-I/usr/include/oracle/10.2.0.4/client64
-I/usr/include/oracle/10.2.0.3/client
-I/usr/include/oracle/10.2.0.3/client64 -I. -I./
-I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal
-D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o oracle_gis.o
oracle_gis.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wmissing-format-attribute -Wformat-security
-fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong
--param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC
-shared -o oracle_fdw.so oracle_fdw.o oracle_utils.o oracle_gis.o
-L/usr/pgsql-11/lib  -Wl,--as-needed -L/usr/lib64/llvm5.0/lib  -L/usr/lib64
-Wl,--as-needed -Wl,-rpath,'/usr/pgsql-11/lib',--enable-new-dtags
-L/opt/app/oracle/product/12.1.0/client_64/
-L/opt/app/oracle/product/12.1.0/client_64//bin
-L/opt/app/oracle/product/12.1.0/client_64//lib -lclntsh
-L/usr/lib/oracle/12.2/client/lib -L/usr/lib/oracle/12.2/client64/lib
-L/usr/lib/oracle/12.1/client/lib -L/usr/lib/oracle/12.1/client64/lib
-L/usr/lib/oracle/11.2/client/lib -L/usr/lib/oracle/11.2/client64/lib
-L/usr/lib/oracle/11.1/client/lib -L/usr/lib/oracle/11.1/client64/lib
-L/usr/lib/oracle/10.2.0.5/client/lib
-L/usr/lib/oracle/10.2.0.5/client64/lib
-L/usr/lib/oracle/10.2.0.4/client/lib
-L/usr/lib/oracle/10.2.0.4/client64/lib
-L/usr/lib/oracle/10.2.0.3/client/lib
-L/usr/lib/oracle/10.2.0.3/client64/lib
/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes
-fno-strict-aliasing -fwrapv -O2
-I/opt/app/oracle/product/12.1.0/client_64//sdk/include
-I/opt/app/oracle/product/12.1.0/client_64//oci/include
-I/opt/app/oracle/product/12.1.0/client_64//rdbms/public
-I/usr/include/oracle/12.2/client -I/usr/include/oracle/12.2/client64
-I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64
-I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64
-I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64
-I/usr/include/oracle/10.2.0.5/client
-I/usr/include/oracle/10.2.0.5/client64
-I/usr/include/oracle/10.2.0.4/client
-I/usr/include/oracle/10.2.0.4/client64
-I/usr/include/oracle/10.2.0.3/client
-I/usr/include/oracle/10.2.0.3/client64 -I. -I./
-I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal
-D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include -flto=thin -emit-llvm
-c -o oracle_fdw.bc oracle_fdw.c
make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found
make: *** [oracle_fdw.bc] Error 127
postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==>