5 Replies Latest reply on Feb 5, 2013 10:35 AM by 955945

    ORA-29158: Unable to open library.

    957858
    957858 Aug 24, 2012 4:45 PM
      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
      • 537 Views
      • Tags:
        • 1. Re: ORA-29158: Unable to open library.
          Gennady Sigalaev
          Gennady Sigalaev Aug 24, 2012 9:12 PM (in response to 957858)
          Hi 954855,

          What version do you use?

          Regards,
          Gena
          • 2. Re: ORA-29158: Unable to open library.
            957858
            957858 Aug 24, 2012 9:54 PM (in response to Gennady Sigalaev)
            11.2.2.3.0, both on 32 bits, 64 bits windows
            • 3. Re: ORA-29158: Unable to open library.
              Gennady Sigalaev
              Gennady Sigalaev Aug 27, 2012 2:06 PM (in response to 957858)
              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
                957858 Aug 27, 2012 9:13 PM (in response to Gennady Sigalaev)
                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
                  955945 Feb 5, 2013 10:35 AM (in response to 957858)
                  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.