BUG #15650: oracle_fdw issue

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com
Subject: BUG #15650: oracle_fdw issue
Date: 2019-02-22 08:45:41
Message-ID: 15650-530739e51bb99e53@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15650
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,

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(at)brurhenppp001(dot)enterprisenet(dot)org:/home/postgres/software/oracle_fdw-2.1.0
==> export ORACLE_HOME=/opt/app/oracle/product/12.1.0/client_64/
postgres(at)brurhenppp001(dot)enterprisenet(dot)org:/home/postgres/software/oracle_fdw-2.1.0
==> export LD_LIBRARY_PATH=$ORACLE_HOME/lib
postgres(at)brurhenppp001(dot)enterprisenet(dot)org:/home/postgres/software/oracle_fdw-2.1.0
==>
postgres(at)brurhenppp001(dot)enterprisenet(dot)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(at)brurhenppp001(dot)enterprisenet(dot)org:/home/postgres/software/oracle_fdw-2.1.0
==>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message leif 2019-02-22 08:49:38 Re: BUG #15589: Due to missing wal, restore ends prematurely and opens database for read/write
Previous Message Sergei Kornilov 2019-02-22 08:27:37 Re: BUG #15649: ERROR: terminating connection due to administrator command