Re: [ADMIN] error installing oracle_fdw extension

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