This error happened when I was making the protocol for converting from Oracle to PostgreSQL on linux. It happened to me two times on two different machines and for different reasons.
The first time:
I installed PosgreSQL, Oracle JDBC, Oracle Instant Client, and oracle_fdw, everything worked fine. Before I was going to make the protocol final, I reinstalled everything to ensure there is no problems. At each step of the installation, the test worked OK. However, when I tried to run the command: "CREATE EXTENSION oracle_fdw", it returned this error:
ERROR: could not load library "/usr/pgsql-9.5/lib/oracle_fdw.so": libmql1.so: cannot open shared object file: No such file or directory
This, at first glance, appears to be a path problem. So, I checked to ensure that a symbolic link for libmql1.so is in the /usr/pgsql-9.5/lib/ directory and the PATH environmental variable was set correctly, but it did not solve the problem. Even though the libmql1.so is right next to the oracle_fdw.so in the /usr/pgsql-9.5/lib/ directory, it was just not able to see it.
The problem was cleared up by restarting the PostgreSQL server. It turned out that after you have installed the Oracle JDBC, it is critical to restart the PostgreSQL server for the oracle_fdw to work.
The second time:
After installed PosgreSQL, Oracle JDBC, Oracle Instant Client, and oracle_fdw on a different linux CentOS 6.6, I got the same error when running "CREATE EXTENSION oracle_fdw". Like before, I ensured the PATH was correctly set and restarted the PostgreSQL server, this time restarting the server did not remove the problem. The problem was solved by executing the command "ldconfig" as root, which configures the dynamic linker run time bindings.
---------------------------------------------------------------------------------------------------
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 free here.
The first time:
I installed PosgreSQL, Oracle JDBC, Oracle Instant Client, and oracle_fdw, everything worked fine. Before I was going to make the protocol final, I reinstalled everything to ensure there is no problems. At each step of the installation, the test worked OK. However, when I tried to run the command: "CREATE EXTENSION oracle_fdw", it returned this error:
ERROR: could not load library "/usr/pgsql-9.5/lib/oracle_fdw.so": libmql1.so: cannot open shared object file: No such file or directory
This, at first glance, appears to be a path problem. So, I checked to ensure that a symbolic link for libmql1.so is in the /usr/pgsql-9.5/lib/ directory and the PATH environmental variable was set correctly, but it did not solve the problem. Even though the libmql1.so is right next to the oracle_fdw.so in the /usr/pgsql-9.5/lib/ directory, it was just not able to see it.
The problem was cleared up by restarting the PostgreSQL server. It turned out that after you have installed the Oracle JDBC, it is critical to restart the PostgreSQL server for the oracle_fdw to work.
The second time:
After installed PosgreSQL, Oracle JDBC, Oracle Instant Client, and oracle_fdw on a different linux CentOS 6.6, I got the same error when running "CREATE EXTENSION oracle_fdw". Like before, I ensured the PATH was correctly set and restarted the PostgreSQL server, this time restarting the server did not remove the problem. The problem was solved by executing the command "ldconfig" as root, which configures the dynamic linker run time bindings.
---------------------------------------------------------------------------------------------------
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 free here.
No comments:
Post a Comment