0 Replies Latest reply on Aug 28, 2018 5:25 PM by Dmitrii Dunaev

    [unixODBC][Driver Manager]Can't open lib '/oracle/TimesTen/tt1122/lib/libttclient.so' : file not found

    Dmitrii Dunaev

      Hello everyone.

       

      I am trying to connect to timesten through oracle gateaway and get the following error when selecting using a db link:

      SQL> select * from dual@tt1122;
      select * from dual@tt1122
                         *
      ERROR at line 1:
      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      [unixODBC][Driver Manager]Can't open lib '/oracle/TimesTen/tt1122/lib/libttclient.so' : file not found {01000}
      ORA-02063: preceding 2 lines from TT1122
      

      Oracle database server and TimesTen server are installed on seperate machines. TimesTen client has been installed on the Oracle machine.

      Here is my configuration files, all found on the oracle machine:

      • /oracle/11.2.0/hs/admin/inittt1122.ora
      # This is a sample agent init file that contains the HS parameters that are
      # needed for the Database Gateway for ODBC
      
      
      #
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO = cp_ttdbCS
      HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
      
      
      #
      # ODBC specific environment variables
      #
      set ODBCINI=/oracle/TimesTen/tt1122/info/sys.odbc.ini
      
      
      
      
      #
      # Environment variables required for the non-Oracle system
      #
      set LD_LIBRARY_PATH=/oracle/TimesTen/tt1122/lib:/oracle/11.2.0/lib:/lib64:/usr/lib64:/lib:/usr/lib:
      
      • /oracle/11.2.0/network/admin/listener.ora
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDRESS_HIDDEN)(PORT = 1521))
            )
            (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
            )
          )
        )
      
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SDU=32767)
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /home/oracle/11.2.0)
            (PROGRAM = extproc)
          )
          (SID_DESC =
            (SDU=32767)
            (SID_NAME = MAINSID)
            (ORACLE_HOME = /home/oracle/11.2.0)
          )
          (SID_DESC =
            (SID_NAME = tt1122)
            (ORACLE_HOME = /home/oracle/11.2.0)
        (PROGRAM = dg4odbc)
        (ENVS="LD_LIBRARY_PATH=/oracle/TimesTen/tt1122/lib:/oracle/11.2.0/lib:/lib64:/usr/lib64:/lib:/usr/lib:")
          )
        )
      
      • /oracle/TimesTen/tt1122/info/sys.odbc.ini
      [ODBC Data Sources]
      cp_ttdbCS=TimesTen 11.2.2 Client Driver
      
      
      [cp_ttdbCS]
      DRIVER=/oracle/TimesTen/tt1122/lib/libttclient.so
      TTC_Server=LogicalServer_tt
      TTC_Server_DSN=cp_ttdb
      UID=vtbs
      DATABASECHARACTERSET=CL8MSWIN1251
      CONNECTIONCHARACTERSET=US7ASCII
      TYPEMODE=0
      

       

      here is the output from "ldd /oracle/TimesTen/tt1122/lib/libttclient.so"

      [root@score-rnd ~]# ldd /oracle/TimesTen/tt1122/lib/libttclient.so
              linux-vdso.so.1 =>  (0x00007fff60f13000)
              libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f55f6375000)
              libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f55f6157000)
              libm.so.6 => /lib64/libm.so.6 (0x00007f55f5ed3000)
              libc.so.6 => /lib64/libc.so.6 (0x00007f55f5b3f000)
              libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f55f5928000)
              libdl.so.2 => /lib64/libdl.so.2 (0x00007f55f5724000)
              libttco.so => /oracle/TimesTen/tt1122/lib/libttco.so (0x00007f55f285a000)
              /lib64/ld-linux-x86-64.so.2 (0x00007f55f695d000)
              librt.so.1 => /lib64/librt.so.1 (0x00007f55f2651000)
              libaio.so.1 => /lib64/libaio.so.1 (0x00007f55f2450000)
              libelf.so.1 => /usr/lib64/libelf.so.1 (0x00007f55f223a000)
              libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f55f2020000)
      

       

      I am able to connect to timesten using ttisqlcs. I can connect to TimesTen using isql utility as well.

       

      Any help is highly appreciated.