Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2014-03-04T10:48:15Z by Evgen_Odrina
SystemAdmin
SystemAdmin
61 Posts
ACCEPTED ANSWER

Pinned topic Import Orchestrate Schema error: Could not load "orchoracle": libclntsh.so.

‏2012-10-24T16:48:30Z |
Hi All,

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 ?

Thanks
David Peixotto
Updated on 2012-11-26T10:06:10Z at 2012-11-26T10:06:10Z by mdz
  • mdz
    mdz
    1 Post
    ACCEPTED ANSWER

    Re: Import Orchestrate Schema error: Could not load "orchoracle": libclntsh.so.

    ‏2012-11-26T10:06:10Z  in response to SystemAdmin
    We have the same issue, did you ever find a solution?

    Thanks.
  • Evgen_Odrina
    Evgen_Odrina
    1 Post
    ACCEPTED ANSWER

    Re: Import Orchestrate Schema error: Could not load "orchoracle": libclntsh.so.

    ‏2014-03-04T10:48:15Z  in response to SystemAdmin

    Hi,

    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:

    #fi

    if [ -z "$ORACLE_HOME" ]

    then
          ORACLE_HOME=/u01/oracle/product/11.2.0/client_1; export ORACLE_HOME
    fi
     

    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