Re: error installing oracle_fdw extension

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(dot)rouhaud(at)dalibo(dot)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
>