This discussion is archived
5 Replies Latest reply: Feb 5, 2013 2:35 AM by 955945 RSS

ORA-29158: Unable to open library.

957858 Newbie
Currently Being Moderated
Hi

posting here after looking around the web, and trying the suggestions.

On my windows 32 bit , I have failed to use the ado.net library for TimesTen. The command line, sqldeveloper access works fine.

I installed oracle client tools to have correct version of OCI, and the lib and bin directories from TimesTen are in the path.

any ideas what could be wrong, how do I find out the exact cause of the problem.

thanks
  • 1. Re: ORA-29158: Unable to open library.
    Gennady Sigalaev Journeyer
    Currently Being Moderated
    Hi 954855,

    What version do you use?

    Regards,
    Gena
  • 2. Re: ORA-29158: Unable to open library.
    957858 Newbie
    Currently Being Moderated
    11.2.2.3.0, both on 32 bits, 64 bits windows
  • 3. Re: ORA-29158: Unable to open library.
    Gennady Sigalaev Journeyer
    Currently Being Moderated
    Hi 954855,

    First of all you don't need to install Oracle client separately of Oracle TimesTen, because TimesTen already contains Oracle instant client.

    Regarding ado.net library, Do you use Oracle Data Provider for .NET? You can download it from here (http://www.oracle.com/technetwork/products/timesten/downloads/index.html).

    I hope it helps.

    regards,
    Gena
  • 4. Re: ORA-29158: Unable to open library.
    957858 Newbie
    Currently Being Moderated
    Hi Gena

    That is what I tried first but had same issues. Then read in the documentation that for ado.net .net provider , times ten needs to use a different version of OCI then why ships with the times ten distribution eg see following . Thanks for help


    ODP.NET support for TimesTen depends on Oracle Call Interface (OCI) support for TimesTen. Specifically, an OCI version included with Oracle Database 11.2 releases is required. The current ODP.NET release must not, and will not, use the OCI version included with TimesTen, which is under the tt_install_dir\ttoracle_home directory, where tt_install_dir is the TimesTen installation root directory. (There is no issue, however, in using the TimesTen version of OCI for OCI or Pro*C/C++ programs that do not use ODP.NET. Refer to "TimesTen Support for Oracle Call Interface" and "TimesTen Support for Oracle Pro*C/C++ Precompiler" in Oracle TimesTen In-Memory Database C Developer's Guide for information on those programming interfaces.
  • 5. Re: ORA-29158: Unable to open library.
    955945 Newbie
    Currently Being Moderated
    Hi 954855,

    Documentation says that ODP.NET uses personal libraries (OCI for instance), but in some cases you can configure ODP for using TimesTen libraries (see ID 1479921.1 for example).
    Regarding your question, could you please check the TNS_ADMIN variable in your environment.
    Additionally, could you please post the steps you've done.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points