- Download Oracle Client Version 10.2.0.4 "Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications". (Note: Lite version may work too)
Here's a link although it might eventually stop working:
Note: (Imonoid) TORA won't work if you try to use the BaciLite InstantClient when connecting to a non-english Oracle database.
- Extract (copy or drag) the DLL files from "instantclient-basic-win32-10.2.0.4.zip" to "C:\Program Files\TOra\"
- Next, launch the TOra icon on your desktop. There will be two icons. Click the one that just says "TOra". (If TOra isn't installed already, download and install it from here: http://tora.sourceforge.net)
- Now set up your client as follows:
Connection Provider: Oracle (Instant Client)
Host: 10.1.1.1 (The ip or hostname of the server)
Schema: (leave blank for now)
Port: (leave at 1521)
Database: (get this from the SID = XXX value in your ORACLE_HOME's TNSNAMES.ORA file. You may also find it in "c:\orant\NET80\ADMIN\TNSNAMES.ORA") If this file doesn't exist, you can probably guess this value pretty easily.
Took me a while to get this working. Hopefully this saves some work for others out there. Thanks to TOra for an excellent client.