TOra is a Toolkit for Oracle which aims to help the DBA or developer of database applications. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a full set of DBA tools. TOra also includes support for MySQL and Postgres.
1. Get TOra from SourceForge and install it.
2. Note the release notes note:
Important! Because of legal reasons TOra comes with a stub oci.dll file which makes it possible to use TOra with non Oracle databases even when Oracle client is not installed. If you need to access Oracle - you must install Oracle client (for example oracle instant client) and delete stub oci.dll from TOra installation folder.
3. Install the Oracle "instant client" (http://www.oracle.com/technetwork/indexes/downloads/index.html)
In this example, the installation path will be "D:\Archivos de programa\Oracle\instantclient_11_2"
4. Add system environtment variable
ORACLE_HOME=D:\Archivos de programa\Oracle\instantclient_11_2
5. Add %ORACLE_HOME% to the system environment variable PATH
6. Delete Tora oci.dll file
For this example we will use the following connection data:
User=PRS; Pwd =PRS; Host=172.23.220.36; Port = 1521; SID = ORCL
So, the TOra connection will be:
Connection provider:Oracle (Instant Client)
Username:PRS
Password:PRS
Host:172.23.220.36
Schema:
Database:ORCL
Options:SQL*Net
The following image shows a working configured connection: