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.albe@xxxxxxxxxx> wrote:
Sumeet Shukla wrote:
> I have below environment variables set:
>
>
> export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib:$LD_ Two possibilities: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
- 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
