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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
