Re: [ADMIN] error installing oracle_fdw extension

Поиск
Список
Период
Сортировка
От Sumeet Shukla
Тема Re: [ADMIN] error installing oracle_fdw extension
Дата
Msg-id CABUL136WWygdaq_+sdufa-1NJOF_OGZCisvK3heNY1x-T6r2ew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] error installing oracle_fdw extension  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Ответы Re: [ADMIN] error installing oracle_fdw extension  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-admin
Дерево обсуждения
Hi,

I have below environment variables set:

export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib:$LD_LIBRARY_PATH
export ORACLE_HOME=/usr/lib/oracle/12.1/client64
PATH=$PATH:/usr/lib/oracle/12.1/client64/bin:/usr/lib/oracle/12.1/client64/lib:/usr/lib/oracle/12.1/client64:/usr/lib/oracle/12.1/client64/sdk
export PATH

The file /opt/postgresql/9.6/lib/postgresql/oracle_fdw.so is available. 

I have also added "include /usr/lib/oracle/12.1/client64/lib" in /etc/ld.so.conf 

I still see below error when I perform "create extension oracle_fdw;"

ERROR: could not load library "/opt/postgresql/9.6/lib/postgresql/oracle_fdw.so": libclntsh.so.12.1: cannot open shared object file: No such file or directory



Thanks & Regards,
Sumeet Shukla


On Mon, May 22, 2017 at 12:00 PM, Julien Rouhaud <julien.rouhaud@dalibo.com> wrote:
Adding Laurenz

On 22/05/2017 07:56, Sumeet Shukla wrote:
> Thanks Tom and Peter. I tried installing the latest version
> oracle_fdw-1.5.0 and now I see below error:
>
> -bash-4.1$ make
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -g -O2
> -DMAP_HUGETLB=0x40000 -fpic
> -I/u01/app/oracle/product/12.1.0.2/db_1/sdk/include
> <http://12.1.0.2/db_1/sdk/include>
> -I/u01/app/oracle/product/12.1.0.2/db_1/oci/include
> <http://12.1.0.2/db_1/oci/include>
> -I/u01/app/oracle/product/12.1.0.2/db_1/rdbms/public
> <http://12.1.0.2/db_1/rdbms/public> -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 <http://10.2.0.5/client>
> -I/usr/include/oracle/10.2.0.5/client64 <http://10.2.0.5/client64>
> -I/usr/include/oracle/10.2.0.4/client <http://10.2.0.4/client>
> -I/usr/include/oracle/10.2.0.4/client64 <http://10.2.0.4/client64>
> -I/usr/include/oracle/10.2.0.3/client <http://10.2.0.3/client>
> -I/usr/include/oracle/10.2.0.3/client64 <http://10.2.0.3/client64> -I.
> -I./ -I/opt/postgresql/9.6/include/postgresql/server
> -I/opt/postgresql/9.6/include/postgresql/internal -D_GNU_SOURCE
>  -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include  -c
> -o oracle_utils.o oracle_utils.c
> oracle_utils.c:22:17: error: oci.h: No such file or directory
Did you also install Oracle SDK files in the directory pointed by
$ORACLE_HOME?

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: [ADMIN] error installing oracle_fdw extension
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: [ADMIN] error installing oracle_fdw extension