[NTLUG:Discuss] TOra on RH 7.2 - need help connecting to Oracle database

[Kyle_Davenport@compusa.com]

I just got this working last week.   (Tora with Oracle Client 8.1.7 on RH
8.0).   The hard part is getting the oracle client installed.  The other
gotcha could be using RH's tora.  On 8.0, it simply does not work (it was
compiled incorrectly), but you can get it from the tora homepage,
http://www.globecom.se/tora.

After defining your
~oracle/u01/app/oracle/product/8.1.7/network/admin/sqlnet.ora
   - and -
~oracle/u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora

Put this in your .bash_profile:

# oracle #############################
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.1.7
#NLS_LANG=AMERICAN_AMERICA.UTF8
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
ORACLE_SID=ora
export ORACLE_BASE ORACLE_HOME NLS_LANG ORA_NLS33 ORACLE_SID
if [ "${LD_LIBRARY_PATH:-}" == "" ]; then
        LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/lib:/usr/local/lib
else
        LD_LIBRARY_PATH=${ORACLE_HOME}/lib:$LD_LIBRARY_PATH
fi
export LD_LIBRARY_PATH
######################################

Verify you can connect with sqlplus first, then tora should come up with
available "Connection Providers"

Documentation was woefully inadequate on all these separate steps.  Good
luck. Kyle