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.
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.