I'm having the same issue as discussed here but with Oracle 11.2. My error is:
Error loading connector library libccora11g.so. libclntsh.so.11.1: cannot open shared object file: No such file or directory
I have the /home/oracle/app/oracle/product/11.2.0/client1 path explicitly added to ORACLE_HOME, LD_LIBRARY_PATH and PATH in dsenv. The connector works fine when I run the job, but I get the error either trying to test the connection or select a server via the Connector stage in Designer.
Error loading connector library
Moderators: chulett, rschirm, roy
I meant it to mean "un-hijacked"... as in split out to its own post and linked back to the original post it came from. Got nothing to do with the problem or solution, just a Moderator thing related to the fact that one shouldn't really jump on an old post... if you have a problem and can't find a solution in the forums, you should start a new topic of your own. With details.
Now, what exactly is "the same problem" that you have?
Now, what exactly is "the same problem" that you have?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
I think you need to restart datastage server.
Check the output of ldd
this should provide a list of the libraries that are required by the oracle 10g connector nd I think that there may be some libraries that it can not find.
If it results no error restart the node agent and engine ,otherwise try restarting datastage all services.
Check the output of ldd
Code: Select all
ldd /opt/IBM/InformationServer/DSComponents/bin/libccora10g.so
If it results no error restart the node agent and engine ,otherwise try restarting datastage all services.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
The problem of the error message telling me that there is an error loading the connector library libccora11g.sochulett wrote:Now, what exactly is "the same problem" that you have?
The resolution was to make some additions to the dsenv script, ensuring that LD_LIBRARY_PATH contained a link to the DSComponents/bin folder, plus the ORACLE_HOME locations.