Toad + Oracle instant client

many thanks to Christian Gosselin’s weblog

1. Dowload Oracle instant client
2. Create a directory called oracle with the following subdirectories

c:\Program Files\oracle
├─bin
└─network
└──admin

3. Uncompress the instant client under the bin directory
4. Add the following environment variables:
   • SQL_PATH = c:\Program Files\oracle
   • TNS_ADMIN c:\Program Files\oracle\network\admin
   • LD_LIBRARY_PATH = c:\Program Files\oracle\bin
5. Copy the tnsnames.ora in the following directory: c:\Program Files\oracle\network\admin. Here’s a simple tnsnames.ora:
   DEV =
   (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = foo)(PORT = 1531))
   )
   (CONNECT_DATA =
   (SERVICE_NAME = foo)
   )
   )

traceback: http://www.javamart.ca/blog/wp-trackback.php?p=34