Monday, February 16, 2009

Using Toad with Oracle Instantclient

1. Install the Oracle instant client from here. Make sure you download version and not any of the 11.x.x.x versions, they didn't work with my version of Toad. (9.1)

2. Extract the zip somewhere. Say C:\instantclient

3. Add this directory to the PATH environmental variable. To do this, right click on My Computer, go to the Advanced tab, and click 'Environment Variables'. Under System variables, find Path. Select it, and click edit, and add to the end. (Example: %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\instantclient)

4. In the same window, under 'User variables for …', Click the New button. Call the variable 'TNS_ADMIN' and point to your instant client directory. (C:\instantclient)

5. Create a file called 'TNSNAMES.ORA' in your instant client installation directory. In this file designate the connection parameters for your database. Mine looked something like this:


6. You can also create a sqlnet.ora file but its not neccesary.

7. Restart your computer and fire up toad.

You can use other clients like Oracle Sqldeveloper as well.

Done on Windows XP & Toad 9.1

No comments: