After many hours of playing around , trying to get Tora to work, I
finally did it.
And I'd have to say, although it isnt toad, its close enough :)
There are some things I even like more about it than Toad.
I had one heck of a time getting it to work though, I though I'd share
how I got it to work
to save others the time and aggravation :)
Note: Im running on Fedora Core 2.
Tora can be obtained from
http://sourceforge.net/projects/tora/
Oracle instant client can be obtained from
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
I ended up using tora-alpha-1.3.14.1-1static.i686.rpm with the 10g
instant client rpms.
The other versions would install but just wouldnt work with the instant
client.
To get it to work I added this to my .bash_profile:
ORACLE_HOME=/usr/lib/oracle/10.1.0.2/client; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:$PATH; export PATH
CLASSPATH=$ORACLE_HOME/bin:$PATH; export CLASSPATH
TNS_ADMIN=/usr/lib/oracle/10.1.0.2/client/network/admin/; export TNS_ADMIN
LD_LIBRARY_PATH=/usr/lib/oracle/10.1.0.2/client/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
NLS_LANG=AMERICAN; export NLS_LANG
NLS_LANGUAGE=AMERICAN; export NLS_LANGUAGE
unset ORA_NLS33
Install the oracle instant client using rpm -ivh (I installed all three
including sqlplus).
I created a network/admin directory in the
/usr/lib/oracle/10.1.0.2/client and copied the tnsnames.ora and
sqlnet.ora files from another machine.
Tested that sqlplus worked before installing tora.
Added /usr/lib/oracle/10.1.0.2/client/lib:/lib:/usr/lib to
/etc/ld.so.conf and ran ldconfig.
Created symlink from libclntsh.so.10.1 to libclntsh.so ( ln -s
libclntsh.so.10.1 libclntsh.so )
Attempted to rpm -ivh tora-alpha-1.3.14.1-1static.i686.rpm .. rpm
doesn't know about the symlink I created.. so force it :)
To get it to install: rpm --nodeps -ivh tora-alpha-1.3.14.1-1static.i686.rpm
Done.
I searched all over the net but couldn't find enough information to get
it to work (until I figured it out myself).
--
JD Austin
Twin Geckos Technology Services LLC
email:
jd@twingeckos.com
http://www.twingeckos.com
phone/fax: 480.344.2640
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)