After you have installed Oracle Instant Client and Oracle Data Wrapper, you execute the command: CREATE EXTENSION oracle_fdw, and you are returned with the following error:
ERROR: could not access file "$libdir/oracle_fdw": No such file or directory
This is obviously a PATH problem.
When you are running psql, it will look for files in the /usr/pgsql-9.5 directory. The above error occurs because it could not find the oracle_fdw.so in the /usr/pgsql-9.5/lib directory.
To fix it, copy the oracle_fdw.so from oracle_fdw-ORACLE_FDW_1_3_0 directory to the /usr/pgsql-9.5/lib directory or create a symbolic link.
Also make sure that all the .so files in your Oracle Instant Client directory also have symbolic links in the /usr/pgsql-9.5/lib directory.
-----------------------------------------------------------------------------------------------------------------
Watch the blessing and loving online channel: SupremeMasterTV live
If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.
No comments:
Post a Comment