Skip to Content
avatar image
Former Member

Relapse on SDA/Oracle

Hi all,

Firstly after my last "adventure" with SDA where I made a highly fundamental error, we managed to have some great success with SDA.  We connected to Oracle, Hadoop and MS/SQL.  In the case of Oracle we managed to almost seamlessly creqte HANA definitions by using Oracle Meta Data via Data Pump creating pluggable databases in out lab, then creating virtual HANA tables  and finally creating actual HANA tables.  The advantage of this is that we can now ensure correct domain translation.

OK, so I know that I actually owed the forum a "blog" on the above, but (and I seem to live my life in embarrassment 😊 ) but I actually "lost" my original machine (VM) and have now started to deploy an SDA setup (on both an 82 and an 84 HANA) again.  Once again I am using the manuala anf Leo Hue's excellent article.

So the embarrasment is that I have installed the ODBC  and the instantclient software but for some reason, the ldd produces the following (I have dome the isql --version successfully):

linux-gate.so.1 =>  (0xffffe000)

libdl.so.2 => /lib/libdl.so.2 (0xf75c6000)

libm.so.6 => /lib/libm.so.6 (0xf759d000)

libpthread.so.0 => /lib/libpthread.so.0 (0xf7582000)

libnsl.so.1 => /lib/libnsl.so.1 (0xf7568000)

librt.so.1 => /lib/librt.so.1 (0xf755e000)

libclntsh.so.12.1 => /root/instantclient_12_1/libclntsh.so.12.1 (0xf51c9000)

libodbcinst.so.2 => not found

libc.so.6 => /lib/libc.so.6 (0xf502a000)

/lib/ld-linux.so.2 (0xf7774000)

libnnz12.so => /root/instantclient_12_1/libnnz12.so (0xf4bd2000)

libons.so => /root/instantclient_12_1/libons.so (0xf4b9e000)

libaio.so.1 => /lib/libaio.so.1 (0xf4b9b000)

libclntshcore.so.12.1 => /root/instantclient_12_1/libclntshcore.so.12.1 (0xf4932000)

So the problem is with libodbcinst.so.2 . The module is definitely there (installed in /usr/ocal/lib) and the library in the LD_LIBRARY_PATH and implemented via hdbenv.sh

I think that my problrm is that last time I had done so much to "fix" my eventually silly error that I it was not obvious this time.  The permissions all look OK, but any help as usual appreciated and (the promise of s desperate man!) if I get out of this I promise to share more .

Regards

John

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 09, 2015 at 05:52 PM

    Ouch!!  wrong driver.  I realised this as I boarded the train.

    Moderator, I will leave open until Monday when I can re-test.

    Regards

    John

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Avinash,

      Just a quick placeholder for now.  I just need put my mind where it was when this happened as it has been a while.

      Regards

      John