TOra (Toolkit for Oracle)
Introduction
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.
Intall to use it with Oracle RDBMS
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
Configure Oracle DB connection
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: