Re: error installing oracle_fdw extension

Yes, postmaster does not seem to be aware of LD_LIBRARY_PATH. I tried
ldconfig and postgres service restart but it does not seem to work. How can
I fix this.

Also the owner of /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1 is
root. Please confirm if it is OK.

Thanks & Regards,
Sumeet Shukla
Ph. No. 962 323 4700

On Mon, May 22, 2017 at 2:24 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
wrote:

> Sumeet Shukla wrote:
> > 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/or
> > acle/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
>
> Two possibilities:
>
> - There is no libclntsh.so.12.1 in /usr/lib/oracle/12.1/client64/lib
> - The environment variable LD_LIBRARY_PATH is not set in the postmaster's
> environment.
>
> For the latter (assuming you are using Linux), find out the process ID of
> the
> PostgreSQL server process (postmaster).
>
> Assuming it is 12345, run this:
> $ cat /proc/1234/environ | xargs -n 1 -0 echo
>
> And see if LD_LIBRARY_PATH is set correctly there.
>
> Yours,
> Laurenz Albe
>