TOra QuickStart - Connecting TOra to an Oracle Server

This is a TOra and Windows XP quickstart guide. This guide should work with other versions of Windows, and should be very similar for Linux clients. Pay close attention to the oracle client version. If unsure, visit the TOra sourceforge page and ask.

Steps:
  1. 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:
    http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

    Note: (Imonoid) TORA won't work if you try to use the BaciLite InstantClient when connecting to a non-english Oracle database.

  2. Extract (copy or drag) the DLL files from "instantclient-basic-win32-10.2.0.4.zip" to "C:\Program Files\TOra\"

  3. 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)

  4. Now set up your client as follows:

    Connection Provider: Oracle (Instant Client)
    Username: username
    Password: ******
    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.

Good luck!

Took me a while to get this working. Hopefully this saves some work for others out there. Thanks to TOra for an excellent client.

-Tres

Comments

Imonoid said…
Thanks very much for this. I have installed TORA on my PC too and was kinda curious why It was not working. I'm quite glad to have read this HOW-TO of yours because I was not aware of how important the InstantClient client was in making TORA work properly. Thanks again!

BTW, TORA won't work if you try to use the BaciLite InstantClient when connecting to a non-english Oracle database.
March 30, 2009 at 12:00 AM
Tres Finocchiaro said…
Glad to have helped. I've appended your InstaClient notes. :)

Thanks for the feedback.

-Tres
March 30, 2009 at 6:40 AM
tariqd said…
thanks a lot for this post, I installed tora but had no clue how to run it and where to get the dlls, you really saved my day :)
September 16, 2009 at 4:46 PM
Tim Mothery said…
Useful. Thanks.

Had the 11.2 instClient, reverted to 10.2 (some other post mentioned that TORA binary was built against the 10.2 libraries), but forgot the oci.dll local to TORA was going to be picked up before the dll in the instClient install directory. The copy of client dll's into TORA dir was the ticket.

Wheeew -- oracle without TORA... not pretty.

Thanks, again.
August 22, 2011 at 11:54 PM
chandra said…
Please help me to install in ubuntu
January 1, 2019 at 6:47 AM
Post a Comment

Popular posts from this blog

Dell Zino HD Remote Standard

Image
Took me hours and multiple calls to Dell Technical Support to find this information out. The Dell Zino HD uses the following IR standard for the Remote Sensor on the front: UPD6124A Here is the PDF specification:  http://www.datasheetcatalog.org/datasheet/nec/UPD6600A.pdf The support representative said most universal remotes use one of these two standards: RC5, RECS80 Unfortunately, this causes issues when trying to use a universal remote (example: XBOX 360 Universal Remote) with the Dell Zino HD.  A USB External IR sensor is needed to work with most universal remotes.  This is very confusing, as both devices list as a standard "Microsoft eHome Infrared Tranciever". What this means is that no remote -- other than the one that shipped with your device -- will work with your Dell Zino HD!  Scroll down to see my work-around. Since the Dell Zino HD only comes with 4 usb ports, the external sensor may have to be plugged in to the front of the device, which is partic
Read more

iPod Touch iPhone 3G Ubuntu 9.10 in 5 minutes

Image
"Lucid (Ubuntu 10.04) has 'out of the box', zero-configuration support in Rhythmbox for the iPod touch running firmware 3.12/3.13. It does not require jailbreaking, though I have personally discovered it will work with both a "stock" and a jailbroken iPod touch." - Raffisson Studio Changes (skip this) : Mar 28, 2010: Added link to French tutorial in step 1. Mar 16, 2010: Added Amarok 2.3 notes pe r Gary Feb 23, 2010: Removed "-dev" packages and made some small changes per farfouille64 feedback. Feb 19, 2010: Bifster found a similar tutorial. Worth trying if you have issues. Here's the link: easy way to sync your iphone Feb 19, 2010: Step 11 added DFB 's RythmBox plugin suggestion. Confirmation working with firmware 3.1.3! Thanks DFB! Feb 15, 2010: Step 11 added AJ's unicode work-around. Thanks AJ! Feb 11, 2010: Step 10 modified to automatically add user to group "fuse". Thanks for the
Read more

Pidgin - Microsoft Office Communicator

Image
Update: 11/15/10 - Added ICONV.DLL, LIBXML2.DLL work-around for Windows. Update: 05/01/10 - SIPE 1.10 is out. Tutorial updated. Update: 01/27/10 - SIPE 1.7.1 is out. Download it here . Update: 08/20/09 - SIPE 1.6.0 seems to be available, so I've updated this article with some 1.6.0 comments in red below. Steps: Downloading and installing the latest Pidgin for your platform. - Windows: For first time users, the installer will require GTK to be installed. - Windows: Recommended: Install automatic spell-check (Aspell) for your language, which needs to be selected during install. (Requires a connection to the internet). Download and install the latest SIPE ( SI mple P rotocol E xchange) for your platform. - Windows: The plugin will come bundled as a zip file with a MSI installer. Run the MSI installer. This will install the plugin to "Program Files\Pidgin" - Linux: If a precompiled version (usually ".DEB" or ".RPM" is not ava
Read more