Here is a quick guide on how to get it working.
Download Tora from http://tora.sourceforge.net/ and extract it to a directory.
Make sure you have all the required devel RPM packages before you start, use rpm -qa a look for things like kdelibs-devel, qt-devel and other KDE related devel stuff. On my FC4 box ./configure complained that I didn't have qscintilla installed, yum did the job in a few seconds.
yum -y install qscintilla qscintilla-develAll done!
export ORACLE_HOME LD_LIBRARY_PATH
./configure --prefix=/u01/app/tora --with-oci-version=10G
# 'make' took ages on my machine and for some reason
# it failed when I used the -j3 make option.
sudo make install
Launch tora with /u01/app/tora/bin/tora.
Last thing, Oracle SQL Developer is written in Java, it takes 1 minute to install and configure. It's better than Tora in most aspect. Just use SQL Developer instead of Tora!