How to Setup Toad Oracle Freeware

The following article will help us in configuring our Toad Oracle Freeware with Oracle XE database. For development purposes I normally use XE so it's light.

 Steps:

1. Download and install Oracle XE - I use 10.2.x
1. I installed in: C:\java\oraclexe
2. Download and install Toad Freeware (http://www.toadworld.com/m/freeware/default.aspx)
1. Can be install anywhere
3. Download and install Toad Client, go to http://www.oracle.com/technetwork/topics/winx64soft-089540.html and download the following files:
1. instantclient-basic-win-x86-64-10.2.0.2.0-20060503
2. instantclient-jdbc-win-x86-64-10.2.0.2.0-20060503
3. instantclient-odbc-win-x86-64-10.2.0.2.0-20060503
4. instantclient-sqlplus-win-x86-64-10.2.0.2.0-20060503
5. Extract them all in C:\java\oraclexe\instantclient_10_2
4. Add the following to environment path:
1. C:\java\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
2. C:\java\oraclexe\instantclient_10_2
5. Connect in Toad using XE connection

Optional:

You can also install the Toad Eclpse plugin to connect to the database.