Pinned topic Import Orchestrate Schema error: Could not load "orchoracle": libclntsh.so.
I am using IIS 8.7 on Linux RH5.5 (actually is CentOS 5.5) and Oracle 11g.
Have already set my install.liborchoracle to "see" the 11th version and run the script successfully.
So, problem is that when I try to import orchestrate schema of a 11g database table, a windows pop-up with the following error:
##I IIS-DSEE-TFCN-00006 14:48:25(001) <main_program> conductor uname: -s=Linux; -r=2.6.18-238.el5; -v=#1 SMP Thu Jan 13 15:51:15 EST 2011; -n=deiis87; -m=x86_64
##E IIS-DSEE-TCDB-00004 14:48:25(002) <main_program> Unable to access database oracleLibrary orchoracle could not be loaded; Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object file: No such file or directory.
I believe that the cause is that DS Engine is looking up for a 10 or 10g driver which does not exist since I am using 11g.
Does anyone have any idea how to fix this or already have come into the error and fixed ?
Evgen_Odrina 270004EMJQ1 Post
Re: Import Orchestrate Schema error: Could not load "orchoracle": libclntsh.so.2014-03-04T10:48:15ZThis is the accepted answer. This is the accepted answer.
I think you already fix this :) But I want to add comment for future searches...
You must add in /opt/IBM/InformationServer/Server/DSEngine/dsenv file next variable:
if [ -z "$ORACLE_HOME" ]thenORACLE_HOME=/u01/oracle/product/11.2.0/client_1; export ORACLE_HOMEfi
And you must modify LIBPATH variable by adding "/u01/oracle/product/11.2.0/client_1/lib"
NOTE: ALL Paths is default for UNIX systems.
After you edit dsenv file, you must reboot engine and app tires.Updated on 2014-03-04T10:49:36Z at 2014-03-04T10:49:36Z by Evgen_Odrina