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: