Re: BUG #15648: oracle_fdw extension not able to create

Поиск
Список
Период
Сортировка
От Prakash Ramakrishnan
Тема Re: BUG #15648: oracle_fdw extension not able to create
Дата
Msg-id CAA2eZXzkpK2wugsQBrJAj8GegA1F5tsZY6h2rHJr9BJWEb1Agw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15648: oracle_fdw extension not able to create  (Euler Taveira <euler@timbira.com.br>)
Ответы Re: BUG #15648: oracle_fdw extension not able to create  (Euler Taveira <euler@timbira.com.br>)
Список pgsql-bugs
Hi Euler,

Still am not able to create the oracle_fdw extension please find the below details,

postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==> ll
total 984
-rw-r--r--. 1 postgres postgres  15887 Sep 25 12:04 CHANGELOG
drwxr-xr-x. 2 postgres postgres    123 Sep 25 12:04 expected
-rw-r--r--. 1 postgres postgres   1086 Sep 25 12:04 LICENSE
-rw-r--r--. 1 postgres postgres   1968 Sep 25 12:04 Makefile
-rw-r--r--. 1 postgres postgres   1459 Sep 25 12:17 META.json
drwxr-xr-x. 2 postgres postgres     99 Sep 25 12:04 msvc
-rw-r--r--. 1 postgres postgres    231 Sep 25 12:04 oracle_fdw--1.0--1.1.sql
-rw-r--r--. 1 postgres postgres   1003 Sep 25 12:04 oracle_fdw--1.1.sql
-rw-r--r--. 1 postgres postgres 194018 Sep 25 12:04 oracle_fdw.c
-rw-r--r--. 1 postgres postgres    133 Sep 25 12:04 oracle_fdw.control
-rw-r--r--. 1 postgres postgres   8284 Sep 25 12:04 oracle_fdw.h
-rw-------. 1 postgres postgres 570584 Feb 15 16:46 oracle_fdw.o
-rw-r--r--. 1 postgres postgres  44474 Sep 25 12:04 oracle_gis.c
-rw-r--r--. 1 postgres postgres  93976 Sep 25 12:04 oracle_utils.c
-rw-r--r--. 1 postgres postgres  37530 Sep 25 12:04 README.oracle_fdw
drwxr-xr-x. 2 postgres postgres     98 Sep 25 12:04 sql
-rw-r--r--. 1 postgres postgres    315 Sep 25 12:04 TODO
postgres@brurhenppp001.enterprisenet.org:/home/postgres/software/oracle_fdw-2.1.0
==> 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


On Fri, Feb 22, 2019 at 2:25 AM Euler Taveira <euler@timbira.com.br> wrote:
Em qui, 21 de fev de 2019 às 15:39, PG Bug reporting form
<noreply@postgresql.org> escreveu:
>
> we are not able to create the extesnion oracle_fdw and we did pre check for
> oracle client 12c and getting below error.
>
Report issues to oracle_fdw project [1].

> ==> 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/sdk/include -I/oci/include -I/rdbms/public
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

It seems you do not set ORACLE_HOME env variable. Hence, it can't find
oci.h. Check Makefile for details.


[1] https://github.com/laurenz/oracle_fdw/issues


--
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento


--


Regards,
Prakash.R
Postgresql DBA

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Maksim Milyutin
Дата:
Сообщение: Re: BUG #15638: pg_basebackup with --wal-method=stream incorrectlygenerates WAL segment created during backup
Следующее
От: Paul Mansueto Namuag
Дата:
Сообщение: BUG #14954: fresh install of postgresql-server 9.6.6-3PGDG.rhel6fails on initdb