Re: Tora and Oracle Instant Client

I guess I'll respond to my own post. Here's what had to be done to get TOra 1.3.14.1 to work with Oracle Instant Client 10.1.0.2

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) otherwise TOra will display a some error message: "No connection provider. Missing Plugins" or something like that.

TOra should now run assuming you have a valid tnsnames.ora file.

I wrote in message news:<fb12e68a.0408101641.49d4cfcd_at_posting.google.com>...
> Can anyone that has successfully installed Tora using the Oracle
> Instant Client on Linux describe the steps they took to accomplish
> this? I installed the instant client software and can successfully
> connect to a remote Oracle 9 instance using sqlplus however I cannot
> get Tora to cooperate. I am not really sure which environment
> variables need to be set in order for Tora to work with the instant
> client.
> Any help is appreciated.
Received on Fri Aug 13 2004 - 21:47:55 CEST