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@xxxxxxxxxx> 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/ > -I/usr/include/oracle/10.2.0.client
> -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/ client
> -I/usr/include/oracle/11.1/client64
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 Did you also install Oracle SDK files in the directory pointed by
> -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
$ORACLE_HOME?
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
