Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Tora 1.2.4 Instant Client 10g SuSe 9.2 Pro

Help
s_70
2004-11-16
2012-12-13
  • s_70
    s_70
    2004-11-16

    I am trying to get Tora to work with Oracle instant client 10g in SuSe 9.2 Pro. I get an ORA-12154 error 'cannot retrieve text'.

    I have all my env. variables set and can connect with SQL*Plus. Is this a conflict or am I missing something.

    I tried to bump up a level to tora-alpha-1.3.14.1-1static.i686.rpm but when I compile and try to start it, I get

    "lin1:/home/user1 # tora
    Xlib: connection to ":0.0" refused by server
    Xlib: No protocol specified

    tora.real: cannot connect to X server :0.0
    /usr/X11R6/bin/tora: line 10:  6630 Segmentation fault      tora.real"

    TIA

     
    • ace
      ace
      2004-11-17

      I couldn't get 1.2.4 to work with the instant client but I did get the alpha 1.3.14.1 to work. Here was what I did:

      Installed Oracle Instant Client rpm
      Installed tora-alpha-1.3.14.1-1mdk.i686.rpm
      Installed tora-oracle-alpha-1.3.14.1-1mdk.i686.rpm

      Set these environment variables:
      export LD_LIBRARY_PATH=/usr/lib/oracle/10.1.0.2/client/lib
      export TNS_ADMIN=/usr/lib/oracle/10.1.0.2/client

      created tnsnames.ora in the $TNS_ADMIN directory that points to my database instances.

      Finally you have to make a soft link to libclntsh.so.10.1 named libclntsh.so in the /usr/lib/oracle/10.1.0.2/client/lib directory ($LD_LIBRARY_PATH)

      This was with SuSe 9.1