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