2 Replies Latest reply on Feb 16, 2012 6:58 AM by 880902

    how to use TNSNAMES in ODI Topology

    880902
      Hi
      In the Physical Architecture under oracle i defined a new DAta Server .
      I defined it as oracle.jdbc.driver.OracleDriver and used "jdbc:oracle:oci8:@<tns_alias>
      when i tried ti run it from my unix i got error :
      OracleDI: Starting scenario RUN_ALL_REPORT_PHASES_FOR_REGION -1 in context RSA_VARIABLE_CONTEXT ...
      java.lang.UnsatisfiedLinkError: t2cGetCharSet
      at oracle.jdbc.driver.T2CConnection.t2cGetCharSet(Native Method)
      at oracle.jdbc.driver.T2CConnection.getCharSetIds(T2CConnection.java:2957)
      at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:320)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:361)
      at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:142)
      at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:79)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
      at com.sunopsis.sql.SnpsConnection.getConnectionFromDriverManager(SnpsConnection.java)
      at com.sunopsis.sql.SnpsConnection.access$2(SnpsConnection.java)
      at com.sunopsis.sql.SnpsConnection$ConnectionConnectThread.run(SnpsConnection.java)

      If i'm using the jdbc:racle:thin:@host:@port:@sid - it works fine .

      What should i do ? what is missing ?


      Thanks
      Tamar
        • 1. Re: how to use TNSNAMES in ODI Topology
          actdi
          Tamar,

          Looks like a problem with the JDBC driver. Check this post
          Java 10g OCI connection
          • 2. Re: how to use TNSNAMES in ODI Topology
            880902
            Hi
            I played a little with all the paraleter : ORACLE_HOME , ODI_JAVA_HOME and LD_LIBRARY_PATH
            and i got diffrent errors
            for :
            ODI_JAVA_HOME=/oracle/product/odi10.1.3/jre/1.4.2
            ORACLE_HOME=/oracle/product/10.2
            LD_LIBRARY_PATH=/oracle/product/10.2/lib:/usr/lib
            Got Error :
            java.lang.UnsatisfiedLinkError: /oracle/product/10.2/lib/libocijdbc10.so: /oracle/product/10.2/lib/libocijdbc10.so: wrong ELF class: ELFCLASS64
            at java.lang.ClassLoader$NativeLibrary.load(Native Method)
            and for :
            ODI_JAVA_HOME=/oracle/product/odi10.1.3/jre/1.4.2
            ORACLE_HOME=/oracle/product/10.2
            LD_LIBRARY_PATH=/oracle/product/10.2/lib32:/usr/lib
            Got Error :
            java.lang.UnsatisfiedLinkError: /oracle/product/10.2/lib/libocijdbc10.so: /oracle/product/10.2/lib/libocijdbc10.so: wrong ELF class: ELFCLASS32
            at java.lang.ClassLoader$NativeLibrary.load(Native Method)

            Any idea what to do ?

            Thanks in advance
            Tamar